LinkBack URL
About LinkBacks
Is it possible to permanently hide grid lines? I've gone into excel options to hide them but they reappear next time you open the book. Much obliged.
Is it possible to permanently hide grid lines? I've gone into excel options to hide them but they reappear next time you open the book. Much obliged.
Last edited by Marvo; 10-01-2018 at 01:58 PM.
The display gridlines setting is for that worksheet only.
If you want to have them off by default, then create a blank sheet, turn them off on that sheet and save it as 'Sheet' with the file type 'Excel template' - which will give it the filename 'Sheet.xltx.' Then save it again as 'Book' ('Book.xltx'). Those are the templates for a new worksheet and new workbook respectively.
You need to save them in your XLStart folder (or move them there after saving). The exact location of this folder varies slightly dependent on your windows version, but will be something like this: C:\Users\<yourusername>\AppData\Roaming\Microsoft\Excel\XLSTART. It's hidden by default so you'll need to turn on viewing hidden files and folders to be able to see it. If you still can't find it, follow the instructions here.
Hope that helps.
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
Thank you. Got distracted and called out, will try what you suggested when I get home. Thank you very much.
I've done it (sort of). If I open excel then a new grid less book appears but if I open a new book when excel is already open it reverts to the grid lined one. I'm sure that's not exactly what you meant but I can work with that. Thank you.
Interesting - when I do the same, I get the non-gridlined book in both cases. I'm using 2010 on Windows 7, so maybe there's something different with 2007. Glad to hear it's at least something you can work with though, and thanks for the rep.
ps If that takes care of your original question, then please take a moment to mark the thread as Solved so others know there's an answer here (instructions are in my sig). Thanks.
If you use the File - New - Blank workbook option, that will not use a book.xltx template. You have to use Ctrl+n to use the template.
Everyone who confuses correlation and causation ends up dead.
Thank you.
Without the hotkeys File>Open, then select the sheet manually.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks