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

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

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

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 Dionne wrote:

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

--

Dave Peterson

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

ctrl+z

"Donna Dionne" wrote:

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

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

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.

-----------------------------------------------------------------------
"Donna Dionne" <Donna wrote in message
...
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