Excel2000 question

Factual Questions
1

I have Excel2000 on my machine. I have a spread sheet that I need to print WITH gridlines. I go to “Page SetUp,” click on the “Sheet” tab and then, under “Print,” I select “Gridlines.” After that, I save the spreadsheet and then print it. No gridlines. I have tried printing from the “Print” menu as well as from the printer icon. Something somewhere is deciding “We don’t need no stinking gridlines” but I don’t know what. I NEED those gridlines and would greatly appreciate any help in getting them.

Thank you.

P.S. Please don’t tell me to get a different OS or a different spread sheet program because I ain’t gonna do either one.

Thanks.

2

Gridlines are not printable. You need to go to “Borders” and create borders where your gridlines are currently displayed. It is the border icon called “All Borders” and looks like four small boxes within a box. Select the area of your spreadsheet and then click that border icon.

3

Gridlines are not printable. You need to go to “Borders” and create borders where your gridlines are currently displayed. It is the border icon called “All Borders” and looks like four small boxes within a box. Select the area of your spreadsheet and then click that border icon.

4

Well I tried it on page setup for my Excel 2000 and the gridlines print, except where I have patterns formatted in particular cells. I removed those pattern formats and the gridlines are plain as day. Check to see if your sheet has any patterns formatted, or just highlight the whole sheet, click format/cells and click on the patterns tab and choose “No Color.” Hope it helps.

5

Gridlines are printable, Qeue. But your solution is an easy way to get them to print for the OP.

6

Tattva

Hmmm. You’re right, gridlines are supposed to print. Yet, mine do not as well. It only seems to print using borders.

Perhaps it’s a printer related problem ??

7

LouisB, do those gridlines appear in Print Preview mode. If they do, and they still don’t print, then there’s something wrong with your printer driver or hardware.

8

Is the “Draft Quality” checkbox selected on the “Sheet” tab in the “Page Setup” dialog box? Printing in “Draft Quality” turns off formatting (including gridlines).

If the “Draft Quality” is not selected then I would vote for a printer driver problem.

9

dreamland hit the nail on the head. I highlighted the entire sheet, selected “No Borders” and “No colors.” Sure enough, the gridlines printed.

Victor 1100, thanks for the tip. I didn’t know that.

Thanks to all for the input.

This is the third time I have attempted to make this response, by the way. I haven’t been ignoring those who responded.