Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Paul B
 
Posts: n/a
Default restoring column labels Excel 2002

After shifting some of the columns to the left, I have lost some of the
column labels;
my worksheet begins with column A, then C,D....,M,R,S, etc. I.e., I've lost
column labels B, N, O, and so on. Is there an easy way to restore all of the
column labels in their correct alphabetical sequence?

Thank you for any help you can provide
  #2   Report Post  
Dave O
 
Posts: n/a
Default

Most likely you've inadvertenly hidden columns, rather than lost them.
When you look at the visible columns, say A and C, is the vertical line
between A and C heavier than the separator between C and D?

Try this: highlight columns A through C by left-clicking on A and
dragging over to C. Then right-click the selection and select UnHide
from the menu. B should then appear.

  #3   Report Post  
Paul B
 
Posts: n/a
Default

Thank you, Dave!

That did the trick.

"Dave O" wrote:

Most likely you've inadvertenly hidden columns, rather than lost them.
When you look at the visible columns, say A and C, is the vertical line
between A and C heavier than the separator between C and D?

Try this: highlight columns A through C by left-clicking on A and
dragging over to C. Then right-click the selection and select UnHide
from the menu. B should then appear.


  #4   Report Post  
Dave O
 
Posts: n/a
Default

Glad to help!

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
How do I reference every "n" cell in a column in Excel? Alma Excel Worksheet Functions 2 March 22nd 05 06:19 PM
how do I enable "import text file" excel 2002? jw_schmid Excel Discussion (Misc queries) 2 February 9th 05 10:39 PM
In MS Excel, how do I fill in a column with the same cell from se. krempin Excel Worksheet Functions 2 February 9th 05 08:43 PM
sharing/using/saving Excel 2002 files in Excel 2003 maze2009 Excel Discussion (Misc queries) 0 January 20th 05 07:27 PM
Column A is Town, Column B is names. How can Excel add & tell how. Cindy Charts and Charting in Excel 3 January 13th 05 07:27 PM


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

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

About Us

"It's about Microsoft Excel"