0

I know that we could turn on or off gridlines for a given sheet here:

enter image description here

Does anyone know how to set this option by default for every newly created worksheet?

1
  • You don't say which version you are using so I can't suggest anything specific. But try to edit your default template to include the gridlines being enabled.
    – Mockman
    Oct 27, 2021 at 18:50

2 Answers 2

1

Make the workbook to be like you want it: Gridlines, Margins, Footers, Headers Etc. Then Save it as a Template called "book" (excel will add ".xltx"). Then move or make sure it is saved in excels XLSTART folder. Lately this is at "C:\Users\[USERNAME]\AppData\Roaming\Microsoft\Excel\XLSTART". For more info, I.e. how to specify a custom Startup folder, see https://exceljet.net/how-to-set-a-default-template-in-excel

-2

Go to: File, Options, Advanced. Scroll about 3/5's way down and un-click the Show Gridlines box.

1
  • 2
    That applies the same as changing it in the Ribbon - notice the sections in Excel's options dialog show that some options apply to the workbook or worksheet rather than globally.
    – AdamV
    Nov 1, 2021 at 13:35

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .