Excel Hack

All border shortcut in Excel

One of the effects of Excel to make data easier to read is to draw a border around cells. Most of you probably use your mouse to draw a border around selected cells. There is a shortcut to draw a border around all selected cells, so use this shortcut to save time and increase productivity.

Shortcut for drawing a border all around a cell

Windows
Access Key: Alt + H + B + A

Mac
None

Use a shortcut to draw a border all around the cell

For information on how to draw a border around the entire perimeter of a cell containing data using a shortcut key, see below.

Total Time: 1 minute

Select a cell

Select a cell

Select any one cell that contains data.

Select all cells with data

Select data

Press Ctrl + A. Select all cells with data.

Bordering all cells containing data is complete

Draw a border around the cell

Press Alt + H + B + A. Drawing borders around all cells containing data is now complete.