Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Millie Irene
 
Posts: n/a
Default How do I fix my excel data base?

How do I undo specific colums in an excel data base?
  #2   Report Post  
Gordon
 
Posts: n/a
Default

Millie Irene wrote:
How do I undo specific colums in an excel data base?


How do you mean "undo"? What did you "do" in the first place?

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk
  #3   Report Post  
Ken Wright
 
Posts: n/a
Default

Just a tad more detail here would not go amiss :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Millie Irene" wrote in message
...
How do I undo specific colums in an excel data base?



  #4   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

If you select one column in a table, then click the A-A or Z-A button,
it may result in that column being sorted but not the other columns in
the table.

If you notice the problem immediately, click the Undo button, and the
column should go back to its original order.

If some time has passed, you won't be able to undo the sort. Perhaps you
have a backup copy of the file, with most of the data intact, and you
can copy from that. If not, you'll have to reenter the data in that column.

Millie Irene wrote:
How do I undo specific colums in an excel data base?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

  #5   Report Post  
Gordon
 
Posts: n/a
Default

Debra Dalgleish wrote:
If you select one column in a table, then click the A-A or Z-A button,
it may result in that column being sorted but not the other columns in
the table.


I'm amazed as to how you deduced that from :

How do I undo specific colums in an excel data base?


--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk


  #6   Report Post  
Ken Wright
 
Posts: n/a
Default

LOL - Sat here thinking *exactly* the same thing and then saw your note :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Gordon" wrote in message
...
Debra Dalgleish wrote:
If you select one column in a table, then click the A-A or Z-A button,
it may result in that column being sorted but not the other columns in
the table.


I'm amazed as to how you deduced that from :

How do I undo specific colums in an excel data base?


--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk



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
Copy data between 2 instances of Excel Boba Excel Discussion (Misc queries) 5 February 17th 05 11:46 PM
Data Base Link Trying Hard Excel Discussion (Misc queries) 1 January 16th 05 11:35 AM
Charting Data from Excel DavidM Charts and Charting in Excel 4 December 30th 04 02:31 PM
Layout/Formatting problems of Data Queries in Excel? Andrew Harding Excel Discussion (Misc queries) 0 December 23rd 04 03:51 AM
insert data from one excel file into another Leonard Excel Discussion (Misc queries) 1 December 2nd 04 12:35 PM


All times are GMT +1. The time now is 06:10 PM.

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

About Us

"It's about Microsoft Excel"