Wednesday, December 26, 2018

Microsoft Excel shortcut keys A to Z Keys



Microsoft Excel shortcut keys


Shortcut
Description


Tab
Move to the next cell, to the right of the currently selected cell.


Ctrl+A
Select all contents of a worksheet.


Ctrl+B
Bold all cells in the highlighted section.


Ctrl+C
Copy all cells in the highlighted section.


Ctrl+V
Pastes everything copied onto the clipboard.


Ctrl+D
Fill down. Fills the cell beneath with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Down to select multiple cells. Then press Ctrl+D to fill them with the contents of the original cell.


Ctrl+F
Search current sheet.


Ctrl+G
Go to a certain area.


Ctrl+H
Find and replace.


Ctrl+I
Puts italics on all cells in the highlighted section.


Ctrl+K
Inserts a hyperlink.


Ctrl+N
Creates a new workbook.


Ctrl+O
Opens a workbook.


Ctrl+P
Print the current sheet.


Ctrl+R
Fill right. Fills the cell to the right with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Right to select multiple cells. Then press Ctrl+R to fill them with the contents of the original cell.


Ctrl+S
Saves the open worksheet.


Ctrl+U
Underlines all cells in the highlighted section.


Ctrl+V
Pastes everything copied onto the clipboard.


Ctrl+W
Closes the current workbook.


Ctrl+X
Cuts all cells in the highlighted section.


Ctrl+Y
Repeats the last entry.


Ctrl+Z
Undo the last action.

No comments:

Post a Comment