| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enable default to show gridlines on an inserted worksheet?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I enable default to show gridlines on an inserted worksheet?
Click Tools/Options on Excel's menu bar, click the View tab on the dialog
box that appears and put a check mark in the checkbox labeled "Gridlines" in the "Window options" section of the panel. -- Rick (MVP - Excel) "J" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I enable default to show gridlines on an inserted worksheet?
Thank you for your response. New workbooks are fine. Most workbooks are fine. Two do not show gridlines for new sheets. Is it possible to fix just the unhappy workbooks? "Chip Pearson" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I enable default to show gridlines on an inserted worksheet?
I'm not quite sure I understand. Are you saying that when you insert a new
sheet into some workbooks, you see gridlines and when you insert a new sheet into others (a few), then you don't see gridlines? I don't have a good explanation for that. Maybe you have an event macro in those workbooks that changes some display settings??? But until you find the answer, maybe you could add an icon to your favorite toolbar. In xl2003 menus: Tools|Customize|Commands Tab|Forms Category Drag the "toggle grid" icon to your favorite toolbar. In xl2007, you can add that icon to your QAT if you don't like going through the ribbon. J wrote: Thank you for your response. New workbooks are fine. Most workbooks are fine. Two do not show gridlines for new sheets. Is it possible to fix just the unhappy workbooks? "Chip Pearson" wrote in message ... 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 -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I enable default to show gridlines on an inserted worksheet?
"Dave Peterson" wrote in message ... I'm not quite sure I understand. Are you saying that when you insert a new sheet into some workbooks, you see gridlines and when you insert a new sheet into others (a few), then you don't see gridlines? This is the case. Good idea about the toggle. Thank you. I don't have a good explanation for that. Maybe you have an event macro in those workbooks that changes some display settings??? But until you find the answer, maybe you could add an icon to your favorite toolbar. In xl2003 menus: Tools|Customize|Commands Tab|Forms Category Drag the "toggle grid" icon to your favorite toolbar. In xl2007, you can add that icon to your QAT if you don't like going through the ribbon. J wrote: Thank you for your response. New workbooks are fine. Most workbooks are fine. Two do not show gridlines for new sheets. Is it possible to fix just the unhappy workbooks? "Chip Pearson" wrote in message ... 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get an inserted symbol to show in another worksheet? | Excel Discussion (Misc queries) | |||
| Row colors overlay the gridlines...how do I show gridlines? | Excel Discussion (Misc queries) | |||
| Can I change my default settings to never show gridlines ? | Excel Worksheet Functions | |||
| Cannot print gridlines in worksheet even tho they show on screen | Excel Discussion (Misc queries) | |||
| How can I show data under a Chart that I inserted in a worksheet? | Charts and Charting in Excel | |||
Linear Mode
