ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   restoring column labels Excel 2002 (https://www.excelbanter.com/excel-discussion-misc-queries/20855-restoring-column-labels-excel-2002-a.html)

Paul B

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

Dave O

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.


Paul B

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.



Dave O

Glad to help!



All times are GMT +1. The time now is 10:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com