Keyboard Shortcut keys for Excel File

 11/26/2017 - 05:54
Shortcut keys for Excel File

1. ALT+=
Inserts a SUM formula.
Switches between open Excel windows.

this has various scenarios:  
If you
are in regular data range and press CTRL+A all the data is selected.
If you press CTRL+A a second time in the same range
selects the entire spreadsheet
If you are in a table then pressing the CTRL+A key selects the data excluding the total row
AND titles
If you press the CTRL+A key a second time it selects the data, titles, and total row
It does not make any difference whether the spreadsheet contains data or not, if you are
outside the data area, in a blank area with no directly adjacent cells containin
g data,
CTRL+A selects the entire sheet.
If you have one or more objects
e.g. Charts,
selected then pressing
selects them all.

4. CTRL+1
Displays the Format Cells dialog box.

Copies the value from the cell above the active cell into the
cell or the Formula Bar.

6. F4
Repeats an action, or if you’re editing a cell and the cursor is in between the cell references it
will insert the $ signs for absolute references. Repeated pressing F4 will scroll through different
levels of absolute references.

Uses the
Undo command to reverse the last command or to delete the last entry
that you typed.

8. CTRL+'
Copies a formula from the cell above the active cell into the cell or the Formula Bar.

Opens the Hyperlink dialog box.

10. CTRL+F
Opens the Find dialog box.

11. CTRL+H
Opens the Find & Replace dialog box.

12. CTRL+N
Opens a new workbook.

13. CTRL+O
Displays the Open
dialog box to open or find a file.
Note: In Excel 2013 it opens the
File tab of the ribbon.

14. F2
Edits the active cell and positions the insertion point at the end of the cell contents. It
also moves the insertion point into the Formula Bar when editing in a cell is turned off.

15. F7
Runs Spell Check on the entire worksheet if only one cell is selected,
otherwise Spell Checks the selected range.
You can also spell check multiple sheets by grouping them first.

Inserts named ranges for an entire table automatically based on the
column or row headings (your choice).

17. CTRL+P
Opens Print dialog box.

18. CTRL+S
Saves workbook.

19. CTRL+C

20. CTRL+X

21. CTRL+V

22. END key then Up or Down
,or Left or Right Arrows
OR the CTRL+Up Arrow/Down Arrow
etc. Move to end of a range of cells (column or row). Your selected cell will stop at any
empty cell in the range, or if
cells are empty it will stop at the next populated cell in the
column or row.

Quickly move to home. If you have frozen panes your cursor will stop at the
intersection of the frozen panes.

24. CTRL+Page Up or CTRL+Page Down
Scroll between worksheets

25. CTRL+
`View formulas instead of values
(note the ` shares the tilde ~ key)

26. CTRL+D
copies the cell above. Select a range or row and then CTRL+D to copy the row.


admin's picture
Arshad Ali Ansari

Follow the author on         or visit   Personal Blog