Keyboard Shortcuts, Ribbon Options to Add Borders in Excel – Knowligent
Keyboard Shortcuts, Ribbon Options to Add Borders in Excel

Keyboard Shortcuts, Ribbon Options to Add Borders in Excel

HomeHow to, TechKeyboard Shortcuts, Ribbon Options to Add Borders in Excel

Adding borders to your Excel spreadsheet lets you emphasize or separate information to make your document easier to read and use. Here's how to do this using both keyboard shortcuts and ribbon options in Excel versions 2019, 2016, 2013, and 2010.

Excel Quick Tip: Shortcuts on the Quick Access Toolbar

Use a keyboard shortcut to quickly add a border to the outer edges of one or more selected cells.

Highlight the desired range of cells in the worksheet.

Press and hold Ctrl + Shift + & . (This shortcut uses the default line color and thickness.)