Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default getting rid of a hidden column behind the front column

I created columns and rows; however, the 4th column has a column that I had
created earlier but couldn't find so I created another one.....Now, I'm
positive that I have one on top of the other......how can I see the one in
the back so that I can get rid of it (delete it, etc.)?.....thank you so very
much......
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default getting rid of a hidden column behind the front column

You'll be able to see if there is a hidden column, because the column
letters which you can see will not be consecutive, so you would see A B C E
F or something similar in the column headings.

Select the whole sheet by clicking the square at the top left, above row 1
and to the left of column A. Then Format/ Column/ Unhide.

If the column is still not visible, it may have been set to zero width, so
then Format/ Column/ Width and set to a non-zero value (the standard width
may be 8.43).
--
David Biddulph

mamie1159 wrote:
I created columns and rows; however, the 4th column has a column that
I had created earlier but couldn't find so I created another
one.....Now, I'm positive that I have one on top of the
other......how can I see the one in the back so that I can get rid of
it (delete it, etc.)?.....thank you so very much......




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
2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da Tammy Excel Discussion (Misc queries) 3 April 2nd 09 11:40 PM
need help in adding a ' in front of a column of numbers noreaster New Users to Excel 4 September 14th 08 03:54 PM
Hidden Column A ebf kentucky Excel Discussion (Misc queries) 3 June 12th 08 06:34 PM
hidden column oldLearner57 Excel Discussion (Misc queries) 1 March 27th 08 01:40 PM
How do I add an apostrophe in front of existing column in Excel? Carlah2 Excel Discussion (Misc queries) 2 December 7th 05 03:56 PM


All times are GMT +1. The time now is 03:34 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"