Printing Grid lines & Shaded cells

A

apatec

PAGE SETUP
Gridlines: checked
Black and White: tried both ways
Draft Quality: unchecked

Tools/Options/View/Window Options/ Gridlines:checked

Problem:
I have user with a workbook with 4 spreadsheets. These spreadsheets
have pivot-tables I think, calcuations, and linked data from the other
3 spreadsheets. These spreadsheets also have some cells shaded in grey,
and 'column and line borders' but not everywhere.

Q:1 Although in Edit mode, NONE of the spreadsheets show Gridlines,
why?

Q2: When printing, gridlines AND shaded cells do not appear at the
same time in Print Preview; it's either one or the other depending if
PAGE SETUP 'Gridlines' and/or 'Black and White' is checked or not.

For example:
If 'Gridlines' is only checked, the PrintPrev shows the following:
- Gridlines do NOT appear,
- A solid border around spreadsheet even though there is no border
line in those cells in edit mode
- Shaded grey cells do appear.

If 'Gridlines' AND 'Black and White' are both checked, PrintPrev
shows:
- Gridlines appear
- Shaded grey cells do NOT appear.


What is happening? How do I get them to print the same time?
Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top