Filled cells with color, no grid

K

kevs1

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

I filled cells of row with Yellow, But now not grid, borders are showing. anyway to see them? thanks
 
J

Jim Gordon MVP

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

I filled cells of row with Yellow, But now not grid, borders are showing. anyway to see them? thanks

Hi Kevs,

When you add a fill color to a cell, the border will disappear.

Select the Cell(s), the use the Format menu Format > Cells
It's in there that you can control the border of the cells that have fills.

-Jim

--
Jim Gordon
Mac MVP

MVPs are independent experts who are not affiliated with Microsoft.


Visit my blog
http://blog.360.yahoo.com/blog-i7JMeio7cqvhotIUwCzaJWq9
 
K

kevs1

thanks Jim, couple of points:
The borders offered, even the thinnest one seems to be a lot darker than the simple grid border.

I guess I would have to write that into the Macro that I wrote filling the row.

Finally, it only seems to border the row, and the column lines are still not showing. thanks!
 
K

kevs1

Also, seems you have to do one Row at a time? If select 50 rows and want to border them all does not seems to work?
 
K

kevs1

Exellent Bob, thanks.
Actually, the 25% is much darker than the very light grey, not for you?
 

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

Similar Threads

Can Sort by a Color 7
Pasted text going into other cells 7
Spreadsheet dimensions 2
insert row 9
No new file please 12
cell display 2
Trend Lines 2
HIDING INDIVIDUAL CELLS IN PRINTOUT 4

Top