Is it possible to eliminate gridlines from only certain rows, columns and or cells? Specifically, I would like to eliminate the gridlines from the frozen columns and rows.
Thanks for your help.
Last edited by KevinSpy; 01-28-2010 at 03:40 PM.
Fill the cell colour (columns/rows) you want with the same colour as your background... (e.g white)
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
That's what I get for upgrading from Lotus products. EVERY time I upgrade or change software I lose things that are very useful and can never get back.
Thanks for the "work around" as it really isn't a good solution.
How was it done in Lotus? Out of curiosity.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
In Lotus 123, the gridlines were eliminated from the rows or columns that were frozen. Lotus called them appropriately Titles.
Oh.. cool.. that would be neat, yes. It's been a long time since I touched Lotus and forget some of those differences... I guess Microsoft thought it not useful when you can just select the columns or rows and background paint...
The gridlines are meant as a guide anyways... you can background paint the whole sheet and then set borders around the area you want to see a grid around... I guess... if that is feasible...
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks