Loading…

Keyboard Shortcuts for Excel

Who doesn't like shortcuts!!! As we use Microsoft Excel in our day to day office works to create charts, analyze data, run a report and so many other crucial works; having knowledge of keyboard shortcuts for Excel can help users navigating, selecting, formatting and entering formulas with less time consumption and effortlessly. Even if you are well familiar with the workability of Microsoft Excel, you will be surprised by how these keyboard shortcuts for Excel will make your Excel operation more convenient and give you a pro look among your colleagues. Here is a complete list of extremely useful keyboard combo available in Excel for your acknowledgment mentioned further below here. Knowing these Excel shortcuts will help you save a great amount of time so that you can focus more on operations that really matter.

Last update: 04 Aug 2019, 46 Shortcuts

keyboard shortcuts for excel

 

Shortcut

Description

1
Ctrl+A

It is used to Select all the contents of a worksheet.

2
Ctrl+B

It is used to Bold all cells in the highlighted section.

3
Ctrl+C

It is used to Copy all cells in the highlighted section.

4
Ctrl+O

It helps in Opens a workbook.

5
Ctrl+F

It is used to Search current sheet.

6
Ctrl+G

It is used to Go to a particular area.

7
Ctrl+H

It is used to Find and replace.

8
Ctrl+I

It is used to italics on all cells in the selected section.

9
Ctrl+K

It is used to Inserts a hyperlink.

10
Ctrl+N

It is used to Creates a new workbook.

11
Ctrl+P

It is used to Print the current page.

12
Ctrl+D

Fill Down

13
Ctrl+R

Fill Right

14
Ctrl+S

It is used to Save the current sheet.

15
Ctrl+U

It is used to Underline the all selected section.

16
Ctrl+V

It is used to Paste the copied contents

17
Ctrl+W
Closes the current page.
18
Ctrl+X

It is used to Cut the selected cells.

19
Ctrl+Y

It is used to Repeats the last entry.

20
Ctrl+Z

It is used to Undo the last action.

21
Ctrl+1

It is used to Changes the format of the selected cells.

22
Ctrl+2

Bolds all cells

23
Ctrl+3

Puts italics highlighted cells.

24
Ctrl+4

It is used to Underlines all cells in the highlighted section.

25
Ctrl+6

It is used to Hides or Shows objects.

26
Ctrl+7

It is used to Hides or Shows the toolbar.

27
Ctrl+8

Toggles the outline symbols

28
Ctrl+9

It is used to Hides rows.

29
Ctrl+0

It is used to Hides columns.

30
Ctrl+Shift+:

It is used to insert the current time.

31
Ctrl+;

It is used to Enter the current date.

32
Ctrl+Shift+"

It is used to Copies value from the cell above.

33
Ctrl+-

It is used to Deletes the selected row/column.

34
Ctrl+Shift+=

It is used to Inserts a new column/row.

35
Ctrl+Shift+@

Applies time formatting.

36
Ctrl+Shift+&

Add a Border around selected cells.

37
Ctrl+Shift+_
It is used to remove a border.
38
Ctrl+Home

It is used to Move to cell A1.

39
Ctrl+End

It is used to Move to the last cell.

40
Ctrl+Shift+A

It is used to Inserts argument names into a formula.

41
Shift+Page Up

Highlights all cells above that are selected in a single column.

42
Shift+Page Down

Highlights all cells above that are selected in a single column.

43
F1

It is used to Open help menu.

44
F4

Repeat last Action

45
Alt+F1

It is used to Insert a Chart.

46
Alt+F8

It is used to Opens the macro dialog box.

Ask Question