Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
When I clear all the formatting or delete the borders of certain cells, the
gridlines dissapear as well. I tried to get the gridlines back by marking the cell borders but they don't look the same as the other gridlines (usually those gridlines which appear automatically cannot be deleted by the eraser but those I did manually can be deleted and I don't see any cell borders at all). |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try Cell formatting/Pattern
click on No color and in the same session Pattern-Automatic and click OK only after both action above is done! Regards, Stefi €˛syosset€¯ ezt Ć*rta: When I clear all the formatting or delete the borders of certain cells, the gridlines dissapear as well. I tried to get the gridlines back by marking the cell borders but they don't look the same as the other gridlines (usually those gridlines which appear automatically cannot be deleted by the eraser but those I did manually can be deleted and I don't see any cell borders at all). |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank you Stefi! You*re a star!!!
made my day ;-))) "Stefi" wrote: Try Cell formatting/Pattern click on No color and in the same session Pattern-Automatic and click OK only after both action above is done! Regards, Stefi €˛syosset€¯ ezt Ć*rta: When I clear all the formatting or delete the borders of certain cells, the gridlines dissapear as well. I tried to get the gridlines back by marking the cell borders but they don't look the same as the other gridlines (usually those gridlines which appear automatically cannot be deleted by the eraser but those I did manually can be deleted and I don't see any cell borders at all). |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You are welcome! Thanks for the feedback!
Stefi "syosset" wrote: Thank you Stefi! You*re a star!!! made my day ;-))) "Stefi" wrote: Try Cell formatting/Pattern click on No color and in the same session Pattern-Automatic and click OK only after both action above is done! Regards, Stefi €˛syosset€¯ ezt Ć*rta: When I clear all the formatting or delete the borders of certain cells, the gridlines dissapear as well. I tried to get the gridlines back by marking the cell borders but they don't look the same as the other gridlines (usually those gridlines which appear automatically cannot be deleted by the eraser but those I did manually can be deleted and I don't see any cell borders at all). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I get the gridlines to print OVER colored cells? | New Users to Excel | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |