2PTTechnology

The platform that enables you to build rich, interactive communities
Welcome to 2PTTechnology Sign in | Join | Help
in Search

Gray gridlines missing from spreadsheet in Excel

Last post 06-11-2007, 7:36 AM by Anonymous. 3 replies.
Sort Posts: Previous Next
  •  01-31-2007, 10:19 AM 15

    Gray gridlines missing from spreadsheet in Excel

    I’ve received a 2003 Excel file with a spreadsheet that is missing the gray gridlines in some of the cells in the background. Does anyone know how to put them back? I’ve tried what Microsoft suggests,

     

    http://support.microsoft.com/kb/211913

     

    To correct the problem from Microsoft Excel:

    1.

    In Microsoft Excel, open the appropriate workbook.

    2.

    On the File menu, click Page Setup, and then click the Sheet tab.

    3.

    Under Print, click to select the Gridlines check box, and then click OK.

    4.

    Select the worksheet range. On the Edit menu, click Copy.

    5.

    In Word, place the insertion point at the location where you want the Microsoft Excel object to appear.

    6.

    On the Edit menu, click Paste Special. In the As window, select Microsoft Excel Worksheet Object, and then click OK.

     

    but that didn’t work for me. Now when I print this report, since I have some colors in header cells, it appears that the headers have steps in them, like indents.

     

  •  01-31-2007, 1:00 PM 16 in reply to 15

    Re: Gray gridlines missing from spreadsheet in Excel

    Sorry, I figured out my problem.

    the cell was filled with white color and it appeard that the gray gridlines were missing.

    all i did to fix it was click on the down arrow next to the paint bucket and selected "No Fill".

    Thanks anyway.

  •  02-26-2007, 10:53 PM 28 in reply to 16

    Re: Gray gridlines missing from spreadsheet in Excel

    Ha, i had the same problem!
  •  06-11-2007, 7:36 AM 48 in reply to 28

    Re: Gray gridlines missing from spreadsheet in Excel

    This Tip works in Excel 2007 also.

    Reg

    Di

View as RSS news feed in XML
Powered by Community Server (Personal Edition), by Telligent Systems