• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Custom notebook (2nd tab not customized)

I created a custom notebook with my preferred settings such as text alignment and no gridlines. I have it setup so that only 1 sheet appears. It works fine for that one sheet, however, when I add a second sheet, my custom settings aren't present.

In the attached file, notice how the alignment on the sheet2 differs from sheet1. Also sheet2 has gridlines, even though sheet 1 doesn't.

Sheet1 has the settings I want all sheets to have.

How can I ensure that my preferred settings will appear on each new tab I add?


Peter Bartholomew

Well-Known Member
There is another way of removing the default grid lines. If you modify the Normal Style to a white fill rather than no fill, all background grids will disappear. I wouldn't recommend it if you use slicers though.