How to Add a Border to a Range

Lesson 43: Add Borders to a Range

1. First Select the range you want to add a border around. I selected the range A5 to G11. Check Lesson 10 for how to select a range.

add borders to a range 1


2. Under the ‘Home’ tab – Left-click the down arrow next to the Borders command – When you do, you will be presented with several border options. Choose the border option you want to apply to your selected Range by left clicking on it. I chose the ‘All Borders’ option as seen in the diagram below.

how to add border to a range 3

3. Excel executes your command. Just look at the border I placed around my selected range in the diagram below. 


how to add border to a range 4



Lesson 44: How to Copy formatting from one cell to Another