Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automate Excel report to place certain data into existing report? | Excel Worksheet Functions | |||
On an Excel Worksheet I want to view column headings as I scroll . | Excel Discussion (Misc queries) | |||
Excel worksheet column headings in backwards alphabetical order? | Excel Discussion (Misc queries) | |||
Can I invert a table so row headings are now column headings etc | Excel Worksheet Functions | |||
copy excel worksheet into msword with row, column headings and gr. | Excel Discussion (Misc queries) |