Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I combine spreadsheets and documents in one file? | Excel Discussion (Misc queries) | |||
seperate first 2 lines of column in seperate columns in same row | Excel Discussion (Misc queries) | |||
How to Delete Rows in Excel In a Do Loop | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |