LinkBack URL
About LinkBacks
The method involving selecting all the cells and using the pain bucket to fill a color removes the black cell borders.
Using office 365
The method involving selecting all the cells and using the pain bucket to fill a color removes the black cell borders.
Using office 365
If I understand you then I think this is by design.
What you see by default on a new worksheet are grid lines, not borders. By default, there are no borders set You can verify this on a new worksheet by File > Options > Advanced > Display options for this worksheet > Show grid lines and unchecking this option. You will now see no borders and no grid lines between cells.
Grid lines are obscured by adding fill to cells. Borders are not.
Hopefully I have understood your problem correctly and that this explanation helps.
Geoff
Did I help significantly? If you wish, click on * Add Reputation to say thanks.
If your problem has been resolved please select ?Solved? from the Thread Tools menu
Yes you got it and I was wondering if there is a way to change the color and keep the grid lines.
While you have the cells selected, you could use the Borders button (to the left of the Fill button) to add whatever borders you want. Grid lines are really colorless, so you cant actually change the color of some of them.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
It is actually possible to set grid line color if you wish:
File > Options > Advanced > Display options for this worksheet
rodkman.png
I like the concept of an Excel Pain bucket (Post 1)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
In case my comment was mis-read, I said you cannot change the color of just some of the grid linesOriginally Posted by GeoffW283
Sorry Ford - I didn't read your post carefully enough.
Geoff, no problem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks