Hi all
I am trying to create a Excel document with Office Starter. However, some of the gridlines disappeared as I was working on it. Note: only some of them. I want to be able to print the gridlines, but they are still missing in print preview. Nothing I have tried has brought it back. Any suggestions would be appreciated. Thanks.
Do you have a fill color set? The default is none. The disappearing grid is a common "feature" when a fill color is set but the lines should still print if you have selected print gridlines.
Select the cell range or a single cell and check it there's fill color set.
Hi carwiz
Thanks for your reply. Unfortunately, I'm not quite sure what you mean.
Select the cell range or a single cell and check it there's fill color set.
Could you try explaining it so this lady (who is not too computer savvy) could understand what to do? Thanks.
Each block of the grid is referenced as a cell. You select a single cell by left clicking on it. You select a range of cells by clicking and holding then dragging the highlight until it covers all the cells you want to check. That "it" in my last post should be "if". Sorry. It should read; "...check if there's a fill color set".
After selecting the range, click on the small arrow next to the Fill Bucket in the menu ribbon. A drop down will appear like that shown in the previous image. At the bottom of that drop down, check to make sure the No Fill has a box around it rather than one of the colors above it. Click on the No Fill if it doesn't.
Hi carwiz
Your instructions were easy to understand and the solution worked! Thank you so much!
Quote