Click the arrow on the Merge & Center button in theĪlignment group and do one of the following: Copy the data into the upper left cell of the range.Merge cells to spread the contents of one cell over several cells. Click the OK button when you are finished. Make formatting selections in the Format Cells dialog box.Select Format Cells from the resulting menu.Click the Format button in the Cells group.Select the cells you want to change the formatting for.Select how you want to shift the cells and click the OK button.Select Insert Cells from the resulting menu.Click the arrow on the Insert Cells button in the Cells group.Select the cell or range of cells where you want to insert the new blank cells.∙ To select all the cells in a worksheet, click the SelectĪll button in the upper left corner of the worksheet. Nonadjacent cells, hold the Ctrl key and click on each cell you want to select. ∙ To select a range of cells, click on the first cell in the range, hold the Shift key, and click on the last cell in the range, or click and drag the mouse pointer over the range of cells. ∙ To select a single cell, click on the cell. Select Insert Sheet Rows or Insert Sheet Columns from the resulting menu. Click the arrow on the Insert Cells button in the Cells group.Ĥ. (To insert multiple rows or columns, elect the same number of columns or rows that you want to insert.)ģ. Select the row heading below or the column hearing to the right of where you want to insert the row or column. Select Delete Sheet from the resulting menu.ġ. 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.