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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Select row 245 (click on 245 in the row header to the left of the data).
Edit|Cut
select row 1
Insert|Cut cells
 
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.
 
Back
Top