ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I mark certains cells with gridlines? (https://www.excelbanter.com/excel-discussion-misc-queries/112759-how-do-i-mark-certains-cells-gridlines.html)

syosset

How do I mark certains cells with gridlines?
 
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).

Stefi

How do I mark certains cells with gridlines?
 
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).


syosset

How do I mark certains cells with gridlines?
 
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).


Stefi

How do I mark certains cells with gridlines?
 
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).



All times are GMT +1. The time now is 10:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com