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

Formating Cells, Rows, Columns & Worksheets

To DoDo 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 cellsSelect 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 cellSelect the cell and press DELETE
Delete the cellSelect 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 columnRight-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 columnRight-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 columnDrag 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 columnResize the row or column to the widest entry by double-clicking the bottom or right margin in the headings.
Add Color to Sheet TabsSelect 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 SheetsSelect 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 WorksheetOn 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.
Press ENTER.
Move or Copy SheetsTo 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 TabsOn 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 VisiblePoint 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.
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.