• AnaM

+40 Helpful Excel shortcuts for Windows users


Using the mouse to do all your work on Excel reduces your productivity, that is why these useful shortcuts will help you save time and make it easier for you.


Ctrl+A=  Select all contents of a worksheet

Ctrl+B=  Bold all cells in the highlighted section

Ctrl+D=  Fill the Content of the selected cell on top to bottom. CTRL + D (i.e. Ctrl+ Down)

Ctrl+F=  Search the current sheet

Ctrl+G=  Go to a certain area

Ctrl+H=  Find and replace. Watch Video 

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

Ctrl+K=  Inserts a hyperlink

Ctrl+P=  Print the current sheet

Ctrl+R=  Fill Right

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 within the highlighted section

Ctrl+Y=  Repeats the last entry

Ctrl+Z=  Undo the last action

Ctrl+1=  Changes the format of the selected cells

Ctrl+2=  Bolds all cells in the highlighted section

Ctrl+3=  Puts italics all cells in the highlighted section

Ctrl+4=  Underlines all cells in the highlighted section

Ctrl+5=  Puts a strikethrough all cells in the highlighted section

Ctrl+6=  Shows or hides objects 

Ctrl+7=  Shows or hides the toolbar

Ctrl+8=  Toggles the outline symbols

Ctrl+9=  Hides rows

Ctrl+0=  Hides columns

Ctrl+1  Changes the format of the selected cells

Ctrl+2  Bolds all cells in the highlighted section

Ctrl+3  Puts italics all cells in the highlighted section

Ctrl+4  Underlines all cells in the highlighted section

Ctrl+5=  Puts a strikethrough all cells in the highlighted section

Ctrl+6=  Shows or hides objects

Ctrl+7=  Shows or hides the toolbar

Ctrl+8=  Toggles the outline symbols

Ctrl+9=  Hides rows

Ctrl+0=  Hides columns

Ctrl+Shift+= Enters the current time

Ctrl+= Enters the current date

Ctrl+`= Changes between displaying cell values or formulas in the worksheet

Ctrl+'=  Copies a formula from the cell above

Ctrl+Shift+"= Copies value from the cell above

Ctrl+- = Deletes the selected column or row


Do you know other shortcuts? Share them with us, we would love to add them to this list. Email us at admin@mybooksntaxes.com

2 views0 comments