Free Excel Tips & Tricks

Subscribe to Get Daily Excel Tips & Tricks to your Inbox for Free!

Friday, July 6, 2018

FORMAT CELLS USING EXCEL SHORTCUT KEYS

FORMAT CELLS USING EXCEL SHORTCUT KEYS

CTRL +1
Purpose:Use this excel shortcut key to Format cells dialog.

CTRL +B
Purpose:Use this excel shortcut key to Apply or remove bold formatting.

CTRL +I
Purpose:Use this excel shortcut key to Apply or remove italic formatting.

CTRL +U
Purpose:Use this excel shortcut key to Apply or remove an underline.

CTRL +5
Purpose:Use this excel shortcut key to Apply or remove strikethrough formatting.

CTRL +SHIFT +F
Purpose:Use this excel shortcut key to Display the Format Cells with Fonts Tab active. Press tab 3x to get to font-size. Used to be ctrl+shift+p, but that seems just get to the Font Tab in 2010.

ALT +' (APOSTROPHE / SINGLE QUOTE)
Purpose:Use this excel shortcut key to Display the Style dialog box.

No comments:

Post a Comment

EDITING CELLS USING EXCEL SHORTCUT KEYS

F2 Purpose: Use this excel shortcut key to Edit the active cell with cursor at end of the line. ALT +ENTER Purpose: Use this exc...