Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
General
GeneralPortable MacsHardwareNetworking
Applications
Mac ApplicationsEudoraFirefox / MozillaInternet ExplorerOutlook ExpressMS OfficeEntourageExcelPowerPointWordVirtual PCMedia PlayerOther MS Products
Programming
Mac ProgrammingCodeWarriorPerl
Country Specific
Australian Mac GroupUK Mac Group

Mac Forum / Applications / Excel / July 2008



Tip: Looking for answers? Try searching our database.

Filled cells with color, no grid

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
kevs1@officeformac.com - 26 Jul 2008 22:53 GMT
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
Jim Gordon MVP - 27 Jul 2008 01:16 GMT
> 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

Signature

Jim Gordon
Mac MVP

MVPs are independent experts who are not affiliated with Microsoft.
http://mvp.support.microsoft.com/

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

kevs1@officeformac.com - 27 Jul 2008 04:02 GMT
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!
kevs1@officeformac.com - 27 Jul 2008 18:52 GMT
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?
CyberTaz - 27 Jul 2008 21:39 GMT
Should be no problem - just make sure you select both Outline as well as
Inside to apply the border to all four sides of each of the cells. If you
use the default border weight and use the 25% Gray border color it should be
virtually indistinguishable from the border color of the unfilled cells (in
2004).

Regards |:>)
Bob Jones
[MVP] Office:Mac

On 7/27/08 1:52 PM, in article 59b55415.2@webcrossing.caR9absDaxw,

> 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?
kevs1@officeformac.com - 27 Jul 2008 23:53 GMT
Exellent Bob, thanks.
Actually, the 25% is much darker than the very light grey, not for you?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.