T
tomoes0745O163
Print preview seems to be correct. There no gridlines visible.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Paul B
tomoes, do you have the gridlines set to print? file page setup, sheet,
under print check gridlines
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
under print check gridlines
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
T
tomoes0745O163
Paul
Yes the gridlines function was checked in page setup. I even tried saving
the file, closiing and reopening to see if the file or the computer had a
momentary quirck. Nothing helped that I did.
Yes the gridlines function was checked in page setup. I even tried saving
the file, closiing and reopening to see if the file or the computer had a
momentary quirck. Nothing helped that I did.
P
Paul B
tomoes, have you filled any cells with a color or have any borders on the
sheet? This will override the grid lines. Do you see them on the sheet? how
about in print preview?
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
sheet? This will override the grid lines. Do you see them on the sheet? how
about in print preview?
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
T
tomoes0745O163
Paul:
I haven't done any of those things. In theory, this should have been a
simple page setup, print gridlines, print preview, and see how the printed
verson will appear. Print preview didn't show the gridlines and the printer
didn't print the gridiines. On another machine, I'm runnig Office 97 which
never failed me. Could I have some conflict with another file which was
copied into this computer, and runnig as an earlier version?
I haven't done any of those things. In theory, this should have been a
simple page setup, print gridlines, print preview, and see how the printed
verson will appear. Print preview didn't show the gridlines and the printer
didn't print the gridiines. On another machine, I'm runnig Office 97 which
never failed me. Could I have some conflict with another file which was
copied into this computer, and runnig as an earlier version?
P
Paul B
tomoes, I have not had that happen before, one more thing to check, tools,
options, view check gridline color and see if it has been changed to the
background color. Are there any macros in the workbook? Could be something
in the before print event turning them off
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
options, view check gridline color and see if it has been changed to the
background color. Are there any macros in the workbook? Could be something
in the before print event turning them off
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
D
David McRitchie
Hi Tomoes,
check my page
Gridlines and Borders
http://www.mvps.org/dmcritchie/excel/gridline.htm
Gridlines can be lost with a draft resolution (low resolution) on printer.
and white is a color whether used for shading or for borders,
gridlines are lost when you have a color pattern (shading) or have borders.
check my page
Gridlines and Borders
http://www.mvps.org/dmcritchie/excel/gridline.htm
Gridlines can be lost with a draft resolution (low resolution) on printer.
and white is a color whether used for shading or for borders,
gridlines are lost when you have a color pattern (shading) or have borders.
T
tomoes0745O163
Thank you both for suggestions. I will investigate the comments this weekend
and post my findings.
and post my findings.
David McRitchie said:Hi Tomoes,
check my page
Gridlines and Borders
http://www.mvps.org/dmcritchie/excel/gridline.htm
Gridlines can be lost with a draft resolution (low resolution) on printer.
and white is a color whether used for shading or for borders,
gridlines are lost when you have a color pattern (shading) or have borders.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
Paul B said:tomoes, I have not had that happen before, one more thing to check, tools,
options, view check gridline color and see if it has been changed to the
background color. Are there any macros in the workbook? Could be something
in the before print event turning them off
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
T
tomoes0745O163
Paul and David:
I went through all of the menus and options yesterday. Gridlines is set to
automatic with a black color in the "View gridline color". There is no
background specified that I could find. Shading and borders were null.
Copying and trying to print on Win 98 didn't work either. I don't think I've
done enough to have a macro problem with this version and this should have
been a new notebook file. I'm not experienced enough yet to see if this
notebook has some attachment to another file.
I went through all of the menus and options yesterday. Gridlines is set to
automatic with a black color in the "View gridline color". There is no
background specified that I could find. Shading and borders were null.
Copying and trying to print on Win 98 didn't work either. I don't think I've
done enough to have a macro problem with this version and this should have
been a new notebook file. I'm not experienced enough yet to see if this
notebook has some attachment to another file.
D
David McRitchie
Okay, I must have been reading part of an answer then because
I remembered colored cells. Perhaps you are printing in draft mode
since it will only print 1/4 of the dots it wouldn't do a good job of printing
gridlines so they are just ignored..
Try removing all color within cells, and removing all borders
Select all cells Ctrl+A (or in Excel 2003 Ctrl+Shift+SpaceBar
-- Borders drop down upper left corner is no borders
-- Fill color (paint bucket), top is no fill color
Check with Print Preview
Try printing with all borders involved.
. http://www.mvps.org/dmcritchie/excel/gridline.htm
Select all cells Ctrl+A (or Excel 2003 same as above)
Format, cells, borders
choose a line, choose automatic, click on both inside and outside borders
Check with Print Preview
I remembered colored cells. Perhaps you are printing in draft mode
since it will only print 1/4 of the dots it wouldn't do a good job of printing
gridlines so they are just ignored..
Try removing all color within cells, and removing all borders
Select all cells Ctrl+A (or in Excel 2003 Ctrl+Shift+SpaceBar
-- Borders drop down upper left corner is no borders
-- Fill color (paint bucket), top is no fill color
Check with Print Preview
Try printing with all borders involved.
. http://www.mvps.org/dmcritchie/excel/gridline.htm
Select all cells Ctrl+A (or Excel 2003 same as above)
Format, cells, borders
choose a line, choose automatic, click on both inside and outside borders
Check with Print Preview
T
tomoes0745O163
David:
I will try youir suggestions this weekend. Thank you.
I will try youir suggestions this weekend. Thank you.
David McRitchie said:Okay, I must have been reading part of an answer then because
I remembered colored cells. Perhaps you are printing in draft mode
since it will only print 1/4 of the dots it wouldn't do a good job of printing
gridlines so they are just ignored..
Try removing all color within cells, and removing all borders
Select all cells Ctrl+A (or in Excel 2003 Ctrl+Shift+SpaceBar
-- Borders drop down upper left corner is no borders
-- Fill color (paint bucket), top is no fill color
Check with Print Preview
Try printing with all borders involved.
. http://www.mvps.org/dmcritchie/excel/gridline.htm
Select all cells Ctrl+A (or Excel 2003 same as above)
Format, cells, borders
choose a line, choose automatic, click on both inside and outside borders
Check with Print Preview
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
tomoes0745O163 said:Paul and David:
I went through all of the menus and options yesterday. Gridlines is set to
automatic with a black color in the "View gridline color". There is no
background specified that I could find. Shading and borders were null.
Copying and trying to print on Win 98 didn't work either. I don't think I've
done enough to have a macro problem with this version and this should have
been a new notebook file. I'm not experienced enough yet to see if this
notebook has some attachment to another file.
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.