| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I set gridlines in excel as a default setting? How?
Thanks Dave,
I'll give that a go! Happy New Year! "Dave Peterson" wrote: Open excel. Hit alt-f11 (to get to the VBE, where macros live) hit ctrl-g (to see the immediate window) type this and hit enter: ?application.startuppath Make a note of the drive/folder that comes back. Now back to excel and create those workbooks exactly the way you want them. But save each as a template (book.xlt and sheet.xlt) in that folder. It's not too bad to do. JES wrote: Hi Dave, Thanks for the suggestions but unfortunately your explanation was like having a conversation with the teacher from Charlie Brown! Sorry, I'm just not that technical!! Thanks anyway "Dave Peterson" wrote: You could record a macro that changes this setting and just run it whenever you want. For new workbooks and new worksheets added to existing workbooks, you can create a book.xlt and sheet.xlt in your XLStart folder. Set up everything you want and when you click on the New icon, your new workbook will inherit all the settings from Book.xlt. JES wrote: Thanks, I already have the gridlines showing on screen but what I actually meant to ask was how do I set it up to automatically print the gridlines for my worksheets? Any idea? Thanks "Dave Peterson" wrote: Existing worksheets, too? I don't think so. But you could make your life somewhat easier by adding an icon to your favorite toolbar that toggles the gridlines. Tools|Customize|Commands tab|Forms Toolbar Look for Toggle Grid near the bottom Drag it to a nice location. Then just click that button to toggle the gridlines the way you want. ps. I usually turn off the gridlines. I'd rather use borders. I have more control over what they look like. JES wrote: I understand how to set the gridlines for each individual worksheet but is it possible to change the default settings so that all worksheets have gridlines automatically? If so, how? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
| Setting tab colours on Excel spreadsheets (for Excel 2000) | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| Printing gridlines in MS Excel | New Users to Excel | |||
| Setting a Default Value in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
