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
|
|||
|
|||
Gridlines do not print, it is selected in sheet setup
I have a workbook with multiple worksheets. All sheets are set up to print
gridlines. I have one out of 5 worksheets, that when I print this worksheet the gridlines do not print. All the other worksheets print the gridlines. I have checked page setupsheets, and, toolsoptionsview. |
#2
|
|||
|
|||
Gridlines do not print, it is selected in sheet setup
Susan
Gridlines will not print if you have changed the background colour of the cells, you will have to set borders for these and they will print. Any good? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS www.nickhodge.co.uk "Susan" wrote in message ... I have a workbook with multiple worksheets. All sheets are set up to print gridlines. I have one out of 5 worksheets, that when I print this worksheet the gridlines do not print. All the other worksheets print the gridlines. I have checked page setupsheets, and, toolsoptionsview. |
#3
|
|||
|
|||
Gridlines do not print, it is selected in sheet setup
Thanks Nick, I should have mentioned that there is no background color on any
of the sheets in this workbook. There are also no borders around the data. Any more ideas? "Nick Hodge" wrote: Susan Gridlines will not print if you have changed the background colour of the cells, you will have to set borders for these and they will print. Any good? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS www.nickhodge.co.uk "Susan" wrote in message ... I have a workbook with multiple worksheets. All sheets are set up to print gridlines. I have one out of 5 worksheets, that when I print this worksheet the gridlines do not print. All the other worksheets print the gridlines. I have checked page setupsheets, and, toolsoptionsview. |
#4
|
|||
|
|||
Gridlines do not print, it is selected in sheet setup
Susan
Mayhaps you have "Draft Quality" checked? Uncheck it, if so. Gord Dibben MS Excel MVP On Wed, 18 Oct 2006 14:08:01 -0700, Susan wrote: Thanks Nick, I should have mentioned that there is no background color on any of the sheets in this workbook. There are also no borders around the data. Any more ideas? "Nick Hodge" wrote: Susan Gridlines will not print if you have changed the background colour of the cells, you will have to set borders for these and they will print. Any good? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS www.nickhodge.co.uk "Susan" wrote in message ... I have a workbook with multiple worksheets. All sheets are set up to print gridlines. I have one out of 5 worksheets, that when I print this worksheet the gridlines do not print. All the other worksheets print the gridlines. I have checked page setupsheets, and, toolsoptionsview. |
Thread Tools | |
Display Modes | |
|
|