Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Format Cell - Cell Shading Removes Grid Lines

Posted on 1999-07-06
Medium Priority
Last Modified: 2012-06-21
Re Excel97
I want to colour cells (Format cell - patterns) - however when I do so the grid lines disappear.
I know I could manually put borders around the cells - but
this would mean that they would print out aswell - I don't want that.
I just want to see the grid lines for layout purposes.
Any ideas anyone?
Question by:capital052798
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 13

Expert Comment

ID: 1608305
Obviously the cell address indication on the left upper corner is not good enough for your needs. If your spreadsheet is very long and/or wide, you might want to try the split window feature to have your own row and/or column titles always visible. Helps you to mantain the overview. If unsure what I mean, ask back.

LVL 22

Accepted Solution

ture earned 60 total points
ID: 1608306

When you apply a pattern to a cell, the gridlines will diappear. Sorry, that's just the way it is. Here is a trick that may be ok as a work-around...

1. Select an empty non-colored area with same row height and column width as the one you want colored.

2. Hold down Shift while clicking the Edit menu. Choose 'Copy picture' - OK

3. Select first cell of colored area and do Edit-Paste (or Ctrl+V).

4. Right-click the inserted picture, choose 'Format Picture'

5. Click 'Properties' tab. Uncheck 'Print object'.

OK. Done.

Problem 1: The cells cannot be selected by clicking them, because the picture lies on top of them. Cells can be selected by going there with arrow keys, though.

Problem 2: The picture can easily be moved by mistake. If you protect the sheet (Tools - Protection - Protect Sheet - OK) you won't be able to mess with the picture.

Ture Magnusson
Karlstad, Sweden

Author Comment

ID: 1608307
Thanks for your work around - its the best solution I can see - but it does have lots of drawbacks.
Resizing of columns messes it up despite setting  properties "move and size with cells" .
Also if you want to go on and format cells with borders etc.
the overlaid picture obscures this.

re cri's comments - the reason I want to see the grid lines
is purely psychological - rather than for navigation purposes
besides which LOTUS 123 retains the grid lines after colouring and I have worked with this a lot too.
thanks capital
LVL 13

Expert Comment

ID: 1608308
Truly amazing reason. You must be very recently drafted to serve on board of the Microsoft galley... >8-P

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question