Excel not Displaying Gridlines but View Gridlines is checked

R

rjorton

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi,

I have Office 2004 installed on MacPro with Leopard 10.5.7

When I open a new Excel file and start using it, NO gridlines are displayed (the View Gridlines checkbox is checked).

I have to go to Excel->Preferences and change the Gridlines colour from Automatic to Black (even though the automatic colour is apparently black). Then I get Gridlines displayed (but in dotted black lines, not solid black, in the current sheet).

However, this will only be for the current sheet - I have to do this on all sheets and all Excel files to view gridlines.

Does anyone else get this?

Does anyone know how to resolve it? To get gridlines displayed automatically in black?

Perhaps changing the default colour of gridlines? how?

Thanks
 
R

rjorton

Found a workround.

Open a new Excel file, go Excel->Preferences and change the Gridlines colour you want from Automatic to Black or Grey or whatever.

Do this for all three worksheets in the file. Then go File -> Save As
Name=Workbook
Format=Template
Uncheck Append File Extension

Save the file in Applications/Microsoft Office 2004/Office/Startup/Excel

Restart Excel.

Now means every NEW Excel file you open will look like the one you just saved.

Then so that every new worksheet you insert looks like this:

Open a new Excel file, delete Sheets 2 and 3, go File -> SaveAs
Name=Sheet
Format=Template
Uncheck Append File Extension

Save the file in Applications/Microsoft Office 2004/Office/Startup/Excel

Restart Excel.

Don't know why Gridlines aren't displayed but this is a workaround.

Got the info from this MacTopia page:

Change the format and settings for new workbooks & Change the format and settings for new sheets

<http://www.microsoft.com/mac/help.m...81-4f3f-abf3-e0d8a80b96b61033&CTT=RelatedLink>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top