Free Excel Tips & Tricks

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

Wednesday, July 18, 2018

EXCEL SHORTCUT KEYS FOR ADJUSTING COLUMN WIDTH AND ROW HEIGHT

EXCEL SHORTCUT KEYS FOR ADJUSTING COLUMN WIDTH AND ROW HEIGHT

ALT +O , C A
Purpose:Use this excel shortcut key to Adjust Column width to fit content. Select complete column with Ctrl+Space first, otherwise column adjusts to content of current cell). Remember Format, Column Adjust.

ALT +O , C W
Purpose:Use this excel shortcut key to Adjust Columns width to specific value: Option, Cow, width

ALT +O , R A
Purpose:Use this excel shortcut key to Adjust Row height to fit content: Option, Row, Adjust

ALT +O , R E
Purpose:Use this excel shortcut key to Adjust Row height to specific value: Option, Row, Height

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...