If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel won't print the gridlines
Print preview seems to be correct. There no gridlines visible.
|
#2
|
|||
|
|||
Excel won't print the gridlines
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 "tomoes0745O163" wrote in message ... Print preview seems to be correct. There no gridlines visible. |
#3
|
|||
|
|||
Excel won't print the gridlines
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. "Paul B" wrote: 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 "tomoes0745O163" wrote in message ... Print preview seems to be correct. There no gridlines visible. |
#4
|
|||
|
|||
Excel won't print the gridlines
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 "tomoes0745O163" wrote in message ... 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. "Paul B" wrote: 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 "tomoes0745O163" wrote in message ... Print preview seems to be correct. There no gridlines visible. |
#5
|
|||
|
|||
Excel won't print the gridlines
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? "Paul B" wrote: 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 "tomoes0745O163" wrote in message ... 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. "Paul B" wrote: 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 "tomoes0745O163" wrote in message ... Print preview seems to be correct. There no gridlines visible. |
#6
|
|||
|
|||
Excel won't print the gridlines
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 "tomoes0745O163" wrote in message ... 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? "Paul B" wrote: 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 "tomoes0745O163" wrote in message ... 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. "Paul B" wrote: 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 "tomoes0745O163" wrote in message ... Print preview seems to be correct. There no gridlines visible. |
#7
|
|||
|
|||
Excel won't print the gridlines
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" wrote in message ... 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 "tomoes0745O163" wrote in message ... 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? "Paul B" wrote: 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 "tomoes0745O163" wrote in message ... 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. "Paul B" wrote: 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 "tomoes0745O163" wrote in message ... Print preview seems to be correct. There no gridlines visible. |
#8
|
|||
|
|||
Excel won't print the gridlines
Thank you both for suggestions. I will investigate the comments this weekend
and post my findings. "David McRitchie" wrote: 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" wrote in message ... 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 "tomoes0745O163" wrote in message ... 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? "Paul B" wrote: 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 "tomoes0745O163" wrote in message ... 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. "Paul B" wrote: 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 "tomoes0745O163" wrote in message ... Print preview seems to be correct. There no gridlines visible. |
#9
|
|||
|
|||
Excel won't print the gridlines
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. "tomoes0745O163" wrote: 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? "Paul B" wrote: 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 "tomoes0745O163" wrote in message ... 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. "Paul B" wrote: 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 "tomoes0745O163" wrote in message ... Print preview seems to be correct. There no gridlines visible. |
#10
|
|||
|
|||
Excel won't print the gridlines
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" wrote in message ... 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. "tomoes0745O163" wrote: 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? "Paul B" wrote: 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 "tomoes0745O163" wrote in message ... 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. "Paul B" wrote: 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 "tomoes0745O163" wrote in message ... Print preview seems to be correct. There no gridlines visible. |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can we import an Excel sheet to use as base for report? | StargateFan | New Users | 9 | November 4th, 2005 07:32 PM |
Excel objects in web page will not print | Bobbodotcom | Publisher | 1 | November 2nd, 2005 06:06 PM |
excel 2003 changing saved print settings | George Applegate | General Discussion | 0 | November 1st, 2005 06:50 PM |
Windows in Taskbar | Chevy | General Discussion | 8 | October 15th, 2004 03:57 PM |
How do I print the details view | David | Running & Setting Up Queries | 5 | August 28th, 2004 12:17 AM |