Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,718
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 611
Default 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



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
Automate Excel report to place certain data into existing report? Craig Harrison Excel Worksheet Functions 3 July 25th 06 01:54 PM
On an Excel Worksheet I want to view column headings as I scroll . sharon Excel Discussion (Misc queries) 1 March 14th 05 11:39 PM
Excel worksheet column headings in backwards alphabetical order? normanok89 Excel Discussion (Misc queries) 1 March 4th 05 03:23 PM
Can I invert a table so row headings are now column headings etc Sharon Excel Worksheet Functions 3 February 10th 05 07:28 PM
copy excel worksheet into msword with row, column headings and gr. eleda Excel Discussion (Misc queries) 0 January 19th 05 01:31 AM


All times are GMT +1. The time now is 01:09 AM.

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

About Us

"It's about Microsoft Excel"