Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
how can I blank out columns that are not being used
|
#2
![]() |
|||
|
|||
![]()
rnooner, one way, select the columns you don't want to see and then format
columns hide -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "rnooner" wrote in message ... how can I blank out columns that are not being used |
#3
![]() |
|||
|
|||
![]()
is this the only way. I have seen worksheets where what you wasn't using was
blanked out and not hid "Paul B" wrote: rnooner, one way, select the columns you don't want to see and then format columns hide -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "rnooner" wrote in message ... how can I blank out columns that are not being used |
#4
![]() |
|||
|
|||
![]()
rnooner, what do you mean by "blanked out" if you have data in columns A:D
and hide columns E:IV you will only see columns A:D and the rest of the screen will be gray -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "rnooner" wrote in message ... is this the only way. I have seen worksheets where what you wasn't using was blanked out and not hid "Paul B" wrote: rnooner, one way, select the columns you don't want to see and then format columns hide -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "rnooner" wrote in message ... how can I blank out columns that are not being used |
#5
![]() |
|||
|
|||
![]()
You can hide them by selecting the columns and clicking on FORMAT ...
COLUMNS ... HIDE. "rnooner" wrote in message ... how can I blank out columns that are not being used |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CONCATENATE problem with blank cells | Excel Discussion (Misc queries) | |||
how to combine several columns into a single column | Excel Discussion (Misc queries) | |||
When sorting info in columns, can I make it insert blank line bet. | Excel Worksheet Functions | |||
Convert multiple columns to rows | Excel Worksheet Functions | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) |