Free Excel Tips & Tricks

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

Saturday, June 23, 2018

APPLY BORDERS TO CELLS IN EXCEL USING SHORTCUT KEYS

APPLY BORDERS TO CELLS IN EXCEL USING SHORTCUT KEYS

CTRL +SHIFT +&
Purpose:Use this excel shortcut key to Apply outline border from cell or selection

CTRL +SHIFT +_ (UNDERSCORE)
Purpose:Use this excel shortcut key to Remove outline borders from cell or selection

CTRL +1 , THEN CTRL +ARROW RIGHT /ARROW LEFT
Purpose:Use this excel shortcut key to Access border menu in 'Format Cell' dialog. Once border was selected, it will show up directly on the next Ctrl+1

ALT +T (IN CELL FORMAT IN 'BORDER' DIALOG WINDOW)
Purpose:Use this excel shortcut key to Set top border to a cell.

ALT +B (IN CELL FORMAT IN 'BORDER' DIALOG WINDOW)
Purpose:Use this excel shortcut key to Set bottom Border to cell

ALT +L (IN CELL FORMAT IN 'BORDER' DIALOG WINDOW)
Purpose:Use this excel shortcut key to Set left Border to selected cells.

ALT +R (IN CELL FORMAT IN 'BORDER' DIALOG WINDOW)
Purpose:Use this excel shortcut key to Set right Border to selected cells

ALT +D (IN CELL FORMAT IN 'BORDER' DIALOG WINDOW)
Purpose:Use this excel shortcut key to Set diagonal and down border

ALT +U (IN CELL FORMAT IN 'BORDER' DIALOG WINDOW)
Purpose:Use this excel shortcut key to Set diagonal and up border

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