how can I blank out columns that are not being used

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
You can hide them by selecting the columns and clicking on FORMAT ...
COLUMNS ... HIDE.
 
is this the only way. I have seen worksheets where what you wasn't using was
blanked out and not hid
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Networkdays and misleading results from blank column 3
#value error for sumproduct using RIGHT cmd 0
Excel Concatenate with line breaks but ignore blank cells 3
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Excel Add 60 days to column 1 or column 2 based on whether column 2 has data 1
Use formula to remove blank entries from a column 6
sorting column with blanks 1
Counting NON-Blank fields 2

Back
Top