45+ Shortcuts to make Microsoft Excel easier

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 thisPress
Go to column A of the active rowHOME
Go to the edge of the spreadsheetEND+ arrow
Go to cell A1 of the active worksheetCTRL+HOME
Go to last cell of the spreadsheet dataCTRL+END
Scroll one window up or downPAGEUP OR PAGEDOWN
Scroll one window left or rightALT+PAGEUP OR PAGEDOWN
Move among the four corners of the selected rangeCTRL+.
Go to a specified cellClick 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 rangesCTRL+ALT+LEFT ARROW or RIGHT ARROW

Selecting Cells, Rows, Columns & Worksheets

To selectDo this
The contents of a cellDouble-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 cellClick the cell, or press the arrow keys to move to the cell.
A range of cellsClick 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 cellsClick 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 rangesSelect the first cell or range of cells, and then hold down CTRL while you select the other cells or ranges.
An entire row or columnClick the row or column heading.
All cells on a worksheetClick the Select All button or press CTRL+A on your Keyboard
Adjacent rows or columnsDrag 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 columnsClick 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 selectionHold 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 worksheetClick the sheet tab
The next worksheetCTRL+PAGEDOWN
The previous worksheetCTRL+PAGEUP
Two or more adjacent worksheetsClick the tab for the first, and then hold down SHIFT and click the tab for the last sheet.
Two or more nonadjacent worksheetsClick the tab for the first, and then hold down CTRL and click the tabs for the other sheets.
All sheets in a workbookRight-click a sheet tab, and then click Select All Sheets.
Cancel a selection of multiple worksheets in a workbookClick 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
[table "80" not found /]
One Comment

Add a Comment

Your email address will not be published. Required fields are marked *

Notify me of followup comments via e-mail. You can also subscribe without commenting.