Excel tips and tricks to help you excel in business

 

Thank you for reading this post, don't forget to subscribe!

Commonly used Short-cuts

CLOSE A WORKBOOK = Ctrl+W
OPEN A WORKBOOK = Ctrl+O
GO TO THE HOME TAB = Alt+H
SAVE A WORKBOOK = Ctrl+S
COPY=  Ctrl+c
PASTE = Ctrl+V
UNDO = Ctrl+Z
REMOVE CELL CONTENTS = Delete
CHOOSE A FILL COLOR = Alt+H
CUT = Ctrl+X
GO TO INSERT TAB = Alt+N
BOLD = Clt+B
CENTER ALIGN CELL CONTENTS = Alt+H,A,C
GO TO PAGE LAYOUT TAB=  Alt+P
GO TO DATA TAB = Alt+A
GO TO VIEW TAB = Alt+W
OPEN CONTEXT MENU = Shift+F10
ADD BORDERS = Alt+H,B
DELETE COLUMN = Alt+H,D,C
GO TO FORMULA TAB = Alt+M
HIDE THE SELECTED ROWS = Ctrl+9
HIDE THE SELECTED COLUMNS = Ctrl+0

Short-cuts for ribbon tabs

SELECT THE RIBBON COMPLETELY = Alt or F10
OPEN THE HOME_TAB = Alt+H
OPEN THE FILE PAGE = Alt+F
OPEN THE INSERT_TAB = Alt+N
OPEN THE PAGE LAYOUT_TAB=  Alt+P
OPEN THE FORMULAS_TAB=  Alt+M
OPEN THE DATA_TAB=  Alt+A
OPEN THE REVIEW_TAB = Alt+R
OPEN THE VIEW_TAB = Alt+W
OPEN THE MENU FOR A SELECTED CELL=  Alt+Down arrow key
EXPAND OR COLLAPSE THE RIBBON. = Ctrl+F1
OPEN A CONTEXT MENU OF SELECTED CELL = Shift+F10

Short-cuts for Navigating in cells

MOVE TO THE PREVIOUS CELL = Shift+Tab
MOVE TO THE EDGE OF THE CURRENT DATA REGION IN A WORKSHEET = Ctrl+Arrow key
MOVE TO THE LOWEST USED ROW OF THE RIGHTMOST USED COLUMN = Ctrl+End
EXTEND THE SELECTION OF CELLS TO THE LOWER-RIGHT CORNER = Ctrl+Shift+End
MOVE TO THE CELL IN THE UPPER-LEFT CORNER = Home+Scroll Lock
MOVE TO THE BEGINNING OF A WORKSHEET. = Ctrl+Home
MOVE ONE SCREEN DOWN IN A WORKSHEET. = Page Down
MOVE TO THE NEXT SHEET IN A WORKBOOK. = Ctrl+Page
 Down
MOVE ONE SCREEN TO THE RIGHT IN A WORKSHEET. = Alt+Page Down
MOVE ONE SCREEN UP IN A WORKSHEET. = Page Up
MOVE ONE SCREEN TO THE LEFT IN A WORKSHEET. = Alt+Page Up
MOVE TO THE PREVIOUS SHEET IN A WORKBOOK. = Ctrl+Page Up
MOVE ONE CELL TO THE RIGHT IN A WORKSHEET. = Tab key
CYCLE THROUGH FLOATING SHAPES, SUCH AS TEXT BOXES O
R IMAGES. = Ctrl+Alt+5
EXIT FROM THE EDITING CELLS = Esc

Short-cuts for formatting cells

OPEN THE FORMAT CELLS DIALOG. = Ctrl+1
FORMAT FONTS IN THE FORMAT CELLS DIALOG.= Ctrl+Shift+F or Ctrl+Shift+P
EDIT THE ACTIVE CELL= F2
INSERT A NOTE= Shift+F2
OPEN AND EDIT A CELL NOTE = Shift+F2
INSERT A THREADED COMMENT = Ctrl+Shift+F2
OPEN AND REPLY TO A THREADED COMMENT= Ctrl+Shift+F2
OPEN THE INSERT DIALOG TO INSERT BLANK CELLS. = Ctrl+Shift+Plus sign (+)
OPEN THE DELETE DIALOG TO DELETE SELECTED CELLS. = Ctrl+Minus sign (-)
ENTER THE CURRENT TIME.= Ctrl + Shift + :

 

ENTER THE CURRENT DATE.= Ctrl+ ;

 

SWITCH BETWEEN DISPLAYING CELL VALUES OR FORMULAS IN THE WORKSHEET.= Ctrl+ ‘
OPEN THE PASTE SPECIAL DIALOG.= Ctrl+Alt+V
ITALICIZE TEXT OR REMOVE ITALIC FORMATTING.=  Ctrl+I or Ctrl+3
BOLD TEXT OR REMOVE BOLD FORMATTING.= Ctrl+B or Ctrl+2
UNDERLINE TEXT OR REMOVE UNDERLINE.= Ctrl+U or Ctrl+4
APPLY OR REMOVE STRIKETHROUGH FORMATTING. = Ctrl+5
SWITCH BETWEEN HIDING OBJECTS, DISPLAYING OBJECTS, AND DISPLAYING PLACEHOLDERS FOR OBJECTS.=  Ctrl+6
APPLY AN OUTLINE BORDER TO THE SELECTED CELLS.= Ctrl+Shift+ &
REMOVE THE OUTLINE BORDER FROM THE SELECTED CELLS. =Ctrl+Shift+ _