How do I place column headings in an existing worksheet in Excel?

D

Donna Dionne

Accidently my column headings got moved to line 245 within my excel
worksheet. How can I either re-enter them or retype them where they belong
(at the top)?

I cannot do a datasort without column headings!(am using Excel 2003)

Thank you.
Donna
 
D

Dave Peterson

Select row 245 (click on 245 in the row header to the left of the data).
Edit|Cut
select row 1
Insert|Cut cells
 
E

Earl Kiosterud

Donna,

The most likely thing that moved your headings row was a sort. Do be careful with Excel
sorts -- it's the only application I've seen that will shamelessly ruin a table beyond
repair if you accidentally sort improperly. For more, read "Sorting in Excel" at
http://www.smokeylake.com/excel/excel_truths.htm

--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting. But if you bottom-post to a reply that's already
top-posted, the thread gets messy. When in Rome.
 

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

VBA Copy multiple columns with the same heading from one sheet to another 0
How do I combine these columns into one? 2
How to make each column of data a new worksheet? 5
EXCEL ALPHABETICAL COLUMN HEADINGS 2
How do I sort a database without also sorting the column heading? 1
how to select contents from a col which lies in between other columns 2
Column headings - urgent help needed please 3
how do I sort data excluidng headings? 2

Top