MrExcel Publishing
Your One Stop for Excel Tips & Solutions

GridLines in Excel


Posted by S. Grassy on December 13, 2001 9:46 AM

Hi Mr. Excel,

Since recieving a newer version of excel (97), gridlines is no longer a default for excel work sheets. Is there somewhere I can go to make gridline a default in 97 excel, instead of having to turn them on all the time, by going into page set-up???

Thanks for your help!!


Posted by Russell Hauf on December 13, 2001 9:49 AM

Tools - Options, View tab = under "Window options", check the box next to "Gridlines".

Hope this helps,

Russell
(not Mr. Excel)

Posted by S. Grassy on December 13, 2001 10:00 AM

Hi Russell,
Thank you so much, I tried that, but it did not work, gridlines was already checked. That just shows me the gridlines on the page in excel. So I need to clarify further. I want my document to print out with gridlines at all times, instead of having to go to page set-up all the time to turn them on.

Can you help?

Posted by Russell Hauf on December 13, 2001 10:09 AM

Sorry, I didn't realize that you wanted them to PRINT every time. I'm not sure that you can set the default page setup to print them every time. Personally, if I want gridlines to show up in my printout, I border the cells I'm printing.

Sorry,

Russell

Posted by Mark W. on December 13, 2001 10:18 AM

1. Open a fresh workbook
2. Using Page Setup check the Print Gridlines
Sheet option
3. Save this workbook as a template named Book.xlt
into your XLStart folder

Posted by S. Grassy on December 13, 2001 10:39 AM

Oh darn, I was so hoping it was some type of default type setting. Anyway if you could tell me what you mean by (I border the cells I'm printing.) How would I do this. Sorry! I need like excel help for dummies. :-)

S.

Posted by S. Grassy on December 13, 2001 11:27 AM

Thank You much!! That solves my creating new documents. But heres one more twist, I believing I'm pushing now but, is there any way to open up excel attachments from say email, and have them already have the gridlines on them?

S.

Posted by Mark W. on December 13, 2001 11:58 AM

I believe that the print gridlines option is a
worksheet attribute. You'd need a macro that
sets it on each worksheet when you opened a
workbook.

Posted by Russell Hauf on December 14, 2001 4:00 PM

The easiest way to border cells is to use the "Border" toolbar button. It should be next to the font color and fill color buttons. If you move your mouse over the different buttons, it should highlight the name of the button (or what it does). If you find the Borders button, click on the downward-pointing triangle on the right of the button and pick the one that has a border around the outside and through the inside. Actually, before you do this, highlight the cells that you want to have a border around.

Hope this helps,

Russell

p.s. You can also go to Format-Cells, and then select the Border tab and do it that way - but it takes longer.