ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i delete grid lines from one column (https://www.excelbanter.com/excel-discussion-misc-queries/122902-how-do-i-delete-grid-lines-one-column.html)

tareco

how do i delete grid lines from one column
 
I'm terrible at Excel and I am using the format of a worksheet that I have
from someone else. is there a way I can delete the gridlines from one row
instead of the entire worksheet? it's the last column and i want to be able
to use it as a 'comments" section. Please help!!! thank you!

FSt1

how do i delete grid lines from one column
 
hi,
I don't think you can delete them but you can hide them.
High lite the grid lines you want to hide. then...
FormatcellsBordersstyle=thincolor=white(or whatever your background
color is)

Regards
FSt1

"tareco" wrote:

I'm terrible at Excel and I am using the format of a worksheet that I have
from someone else. is there a way I can delete the gridlines from one row
instead of the entire worksheet? it's the last column and i want to be able
to use it as a 'comments" section. Please help!!! thank you!


Gary''s Student

how do i delete grid lines from one column
 
Another approach is to set the background colour of the cells to white.
--
Gary's Student


"tareco" wrote:

I'm terrible at Excel and I am using the format of a worksheet that I have
from someone else. is there a way I can delete the gridlines from one row
instead of the entire worksheet? it's the last column and i want to be able
to use it as a 'comments" section. Please help!!! thank you!


Mickey Mouse

how do i delete grid lines from one column
 
And yet another way is to turn off the grid in Tools Options.
Then highlight the range of cells you want to display with a grid appearance
and border them.

Mickey






"tareco" wrote in message
...
I'm terrible at Excel and I am using the format of a worksheet that I have
from someone else. is there a way I can delete the gridlines from one row
instead of the entire worksheet? it's the last column and i want to be
able
to use it as a 'comments" section. Please help!!! thank you!




All times are GMT +1. The time now is 05:42 AM.

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