Forum Discussion

Dan Brown's avatar
Dan Brown
Copper Contributor
Apr 10, 2017

Default Border

Using 365.

Cannot get Excel to change the default border from Bottom only to all.

Tried creating a custom Template. Nope.

Any help?

excel

2 Replies

  • Tommy2355's avatar
    Tommy2355
    Copper Contributor
    Mar 27, 2025

    I to struggled with this and finally tried creating a macro and it worked. I simply selected View>Macros and selected record macro. I called it Borders and then selected Shift +B which Excel included the CTRL key and saved it in Personal Macro Workbook and started it.  Then selected a small range of cells, then selected the Border icon just to the left of the fill color icon and selected All Borders and then stopped the Macro. To my surprise, when I went to a new sheet. highlighted a group of cells and selected Ctrl Shft B, All Borders appeared.  I have tried it several times and it works perfect.  Couldn't be happier! 

  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Apr 11, 2017
    If you right click on the bottom border icon (after selecting the borders icon) then select add to quick access toolbar, you'll then have a button to use repeatedly

Resources