Thread: How do I enable default to show gridlines on an inserted worksheet?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default How do I enable default to show gridlines on an inserted worksheet?

Excel will use a template file named Book.xlt on which to base new
workbooks. Similarly, it will use a template file name Sheet.xlt for
newly created sheets. These files are in the XLStart folder, whose
location depends on your version of Excel and of Windows. There may be
more than one XLStart folder. Use Search to find them and then
customize Book.xlt and Sheet.xlt to your desired format and save the
templates.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Sat, 18 Apr 2009 16:19:48 -0400, "J" wrote:

I have a couple of notebooks that do not show gridlines on new sheets.

I know how to make them on.

How do I set the default for this?

J
Reply With QuoteReply With Quote