Lets make working in MS Excel easier, smarter and faster. Here I’ve listed over 45 easy to use and remember shortcuts that will really increase your productivity with Microsoft Excel. This tables includes shortcuts for Navigation in Excel; Formatting Excel Cells, Rows, Columns, Worksheets & Many Selection options available in Excel.
Excel Workbook Navigation Options
|To do this||Press|
|Go to column A of the active row||HOME|
|Go to the edge of the spreadsheet||END+ arrow|
|Go to cell A1 of the active worksheet||CTRL+HOME|
|Go to last cell of the spreadsheet data||CTRL+END|
|Scroll one window up or down||PAGEUP OR PAGEDOWN|
|Scroll one window left or right||ALT+PAGEUP OR PAGEDOWN|
|Move among the four corners of the selected range||CTRL+.|
|Go to a specified cell||Click the Name box, type the cell reference you want to go to and press ENTER|
|Move one column to the left or right.||LEFT ARROW or RIGHT ARROW|
|Move one row up or down.||UP ARROW or DOWN ARROW|
|Move between noncontiguous selected ranges||CTRL+ALT+LEFT ARROW or RIGHT ARROW|
Selecting Cells, Rows, Columns & Worksheets
|To select||Do this|
|The contents of a cell||Double-click the cell (or press F5), and then select the contents of the cell or select the cell, and then select the contents of the cell in the formula bar .|
|A single cell||Click the cell, or press the arrow keys to move to the cell.|
|A range of cells||Click the first cell in the range, and then drag to the last cell, or hold down SHIFT while you use the arrow keys to extend the selection.|
|A large range of cells||Click the first cell in the range, and then hold down SHIFT while you click the last cell in the range. You can scroll to make the last cell visible.|
|Nonadjacent cells or cell ranges||Select the first cell or range of cells, and then hold down CTRL while you select the other cells or ranges.|
|An entire row or column||Click the row or column heading.|
|All cells on a worksheet||Click the Select All button or press CTRL+A on your Keyboard|
|Adjacent rows or columns||Drag across the row or column headings. Or select the first row or column; then hold down SHIFT while you select the last row or column.|
|Nonadjacent rows or columns||Click the column or row heading of the first row or column in your selection; then hold down CTRL while you click the column or row headings of other rows or columns that you want to add to the selection.|
|More or fewer cells than the active selection||Hold down SHIFT and click the last cell that you want to include in the new selection. The rectangular range between the active cell and the cell that you click becomes the new selection.|
|A single worksheet||Click the sheet tab|
|The next worksheet||CTRL+PAGEDOWN|
|The previous worksheet||CTRL+PAGEUP|
|Two or more adjacent worksheets||Click the tab for the first, and then hold down SHIFT and click the tab for the last sheet.|
|Two or more nonadjacent worksheets||Click the tab for the first, and then hold down CTRL and click the tabs for the other sheets.|
|All sheets in a workbook||Right-click a sheet tab, and then click Select All Sheets.|
|Cancel a selection of multiple worksheets in a workbook||Click any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu|
Formating Cells, Rows, Columns & Worksheets
|To Do||Do this|
|Enter data into a cell||Select the cell and type your entry (you’ll be in edit mode) and then press ENTER to confirm the entry.|
|Enter data in a range of cells||Select the range. When you type, your entry will be entered into the active (white) cell. To move from cell to cell, use TAB, SHIFT+TAB, ENTER, and SHIFT+ENTER to remain within the selected range.|
|Delete the contents of a cell||Select the cell and press DELETE|
|Delete the cell||Select the cell and go to the Edit menu and select Delete… The Delete dialog box will open. Choose which way to shift the remaining cells or delete the entire row or column.|
|Insert a row or column||Right-click the row or column heading and select Insert OR select the row(s) or column(s) and go to the Insert menu and select Rows or Columns. Select multiple rows or columns to insert the same number selected.|
|Delete a row or column||Right-click the row or column heading and select Delete OR select the row(s) or column(s) and go to the Edit menu and select Delete OR press CTRL+- (hyphen).|
|Resize the row or column||Drag the right or bottom margin of the row or column headings with your mouse OR go to the Format menu and select Row or Column (choose AutoFit Selection to fit to the size of the largest entry you have selected)..|
|Resize the row or column||Resize the row or column to the widest entry by double-clicking the bottom or right margin in the headings.|
|Add Color to Sheet Tabs||Select the sheets you want to color.
On the Format menu, point to Sheet, and then click Tab Color OR right-click on the sheet tab and then click Tab Color.
Click on the color you want and click OK.
|Delete Sheets||Select the sheet(s) you want to delete.
On the Edit menu, click Delete Sheet OR right-click the sheet tab and then click Delete.
|Insert a New Worksheet(s)||Select the same number of existing worksheet tabs that you want to add. (i.e.: If you want to add three new worksheets, select three existing worksheet tabs.)
Click Worksheet on the Insert menu.
|Rename a Worksheet||On the Format menu, point to Sheet and then click Rename OR right-click the tab to rename, and then click Rename OR double-click the tab to rename.
Type the new name over the current name.
|Move or Copy Sheets||To move or copy to another workbook, open the workbook that will receive the sheets.
Switch to the workbook that contains the sheets you want to move or copy, and then select the sheets.
On the Edit menu, click Move or Copy Sheet.
In the To book box, click the workbook to receive the sheets. To move or copy the selected sheets to a new workbook, click new book.
In the Before sheet box, click the sheet before which you want to insert the moved or copied sheets.
To copy the sheets instead of moving them, select the Create a copy check box.
|Display or Hide All Sheet Tabs||On the Tools menu, click Options.
On the View tab, under Window options, select or clear the Sheet tabs check box.
|Make More or Fewer Sheet Tabs Visible||Point to the tab split bar on the right side of the Sheet tab bar.
When the pointer changes to a split pointer , drag the tab split bar to the right or left.
To return the tab split bar to its original position, double-click the tab split bar.