Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
rnooner
 
Posts: n/a
Default how can I blank out columns that are not being used

how can I blank out columns that are not being used
  #2   Report Post  
Paul B
 
Posts: n/a
Default

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   Report Post  
rnooner
 
Posts: n/a
Default

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   Report Post  
Paul B
 
Posts: n/a
Default

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   Report Post  
Lewis Clark
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CONCATENATE problem with blank cells roger_home Excel Discussion (Misc queries) 1 August 17th 05 09:18 PM
how to combine several columns into a single column jims Excel Discussion (Misc queries) 9 August 15th 05 12:00 PM
When sorting info in columns, can I make it insert blank line bet. nanalehew Excel Worksheet Functions 2 March 12th 05 04:36 PM
Convert multiple columns to rows Lois Lane Excel Worksheet Functions 8 January 10th 05 12:47 AM
Counting the Contents of Two Columns Molochi Excel Discussion (Misc queries) 6 December 22nd 04 08:13 PM


All times are GMT +1. The time now is 05:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"