Select the worksheet you want to delete.Ĥ. ∙ To move the selected worksheet, clear theġ. ∙ To copy the selected worksheet, check the Select the worksheet you want to move or copy. Select Move or Copy from the shortcut menu. Right click the tab for the worksheet you want to move or copy.Ģ. Enter a name for the worksheet and press the Enter key.ġ.Right click the tab for the worksheet you want to.Click the arrow on the Insert Cells button in the Cells group and select Insert Sheet from the resulting menu. ∙ To insert a new worksheet before an existing worksheet, select the worksheet and click on the Home tab. ∙ To insert a new worksheet at the end of existing worksheets, click the Insert Worksheet button on the right side of the row of worksheet tabs. Select the location where you want to save the workbook.Ĥ. Click the arrow on the Save as type box and select a format from the resulting menu.ģ. Select the location you would like to save the file to and click Browse. ∙ To save the document as another file format, select Save As in the left pane. ∙ To save the document as an Excel 2013 file (.xls), Save from the left pane. Select the location where your file is stored from Recent Workbooks or your Computer.Enter your search query and click the Search button. ∙ To search the web for a template, click in the Search for online templates bar. ∙ To look through commonly searched template, click the options in the Suggested searches spaces. ∙ To use a default template, scroll through listed templates. ∙ To select a blank workbook, select Blank workbook. From here, you can do one of the following from the Available Templates pane: To access the Backstage view, click on the File tab on the Tab Bar. The Backstage view allows you to quickly manage Excel settings as, functions, and options. The Backstage view replaces and expands on the File menu. Click Show Tabs and Commands to restore the ribbon again once you have hidden it. Click Show Tabs to only show the ribbon’s tab headings. Click Auto-Hide Ribbon to hide the entire ribbon.
∙ To hide the Ribbon, Click the Customize the Ribbon button in the top right corner of the screen. ∙ To customize the Quick Access Toolbar, click the Customize Quick Access Toolbar button in the top right corner of the toolbar.Ĭheck or uncheck commands from the resulting menu to add or remove shortcuts. To optimize Excel for the tools and features you use most, you can customize the toolbars and ribbon. Status Bar – contains worksheet information and shortcuts.Tab Bar – contains tabs that display tools and commands in the ribbon.Sheet Tabs – displays tabs for the sheets in the current workbook.Worksheet Area – displays the current worksheet.Ribbon – contains groups of tools for use with the Excel 2013.Backstage View – contains tools to work with workbook files and manage Excel settings.Quick Access Toolbar - contains shortcuts for the most commonly used tools.