#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 272
Default EXCEL

I CANNOT GET MY GRIDLINES TO SHOW ON EXCEL EVER THOUGH I WENT TO PAGE SETUP
AND CHECKED GRID BOX, WHATS WRONG?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 698
Default EXCEL

First: No need to shout (typing in all CAPS means you're shouting)

Second:
Setting gridlines in Page Setup only impacts printed sheets.

Try this:

From the Excel main menu:
<tools<options<view tab
Check: Gridlines......Click [OK]

If that doesn't work, you probably have a background pattern set on the sheet.
So...try this....

Select a range of cells
<format<cells<patterns tab
Click on "No color"
Click on "Pattern" check:Automatic
.......Click [OK]

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"LORI" wrote:

I CANNOT GET MY GRIDLINES TO SHOW ON EXCEL EVER THOUGH I WENT TO PAGE SETUP
AND CHECKED GRID BOX, WHATS WRONG?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default EXCEL

The first thing wrong is that your caps lock key is stuck. Please don't
SHOUT, as many readers will ignore you.

One possibility is that you've set your cell background colour (perhaps to
white) and that is covering the grid lines.
Try Format Cells/ Pattern/ No color, and see what that does for you.

Page setup will tend to affect only what you see in Print, and in Print
Preview. Can you see the grid lines in normal view?
--
David Biddulph

"LORI" wrote in message
...
I CANNOT GET MY GRIDLINES TO SHOW ON EXCEL EVER THOUGH I WENT TO PAGE SETUP
AND CHECKED GRID BOX, WHATS WRONG?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 09:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"