Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Joman
 
Posts: n/a
Default Reverse Data from bottom to top

I want to reverse the whole spreadsheet, e.g. data of July at the bottom (1st
July) has to go to the top and August data (31st August) should be at the
bottom, as against what is in my sheet
  #2   Report Post  
JDM
 
Posts: n/a
Default

Select the data you want to sort and then go to the data menu. Select sort
and it will ask you by which column you would like to sort. Select the one
with the date and select ascending or descending. It should automatically
sort it for you correctly.

"Joman" wrote:

I want to reverse the whole spreadsheet, e.g. data of July at the bottom (1st
July) has to go to the top and August data (31st August) should be at the
bottom, as against what is in my sheet

  #3   Report Post  
Biff
 
Posts: n/a
Default

Hi!

If you have a column of true Excel dates just select the data you want
inverted and sort on the date column ascending.

Biff

"Joman" wrote in message
...
I want to reverse the whole spreadsheet, e.g. data of July at the bottom
(1st
July) has to go to the top and August data (31st August) should be at the
bottom, as against what is in my sheet



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
Printing data validation scenarios SJC Excel Worksheet Functions 14 July 24th 05 12:43 AM
Import Data Keeps asking for Password Dominator Excel Discussion (Misc queries) 0 June 5th 05 11:25 PM
How do I quickly reverse the order of a set of data mdaiga Excel Discussion (Misc queries) 3 April 7th 05 10:10 PM
DATA VALIDATION IN REVERSE #2 (FOR JULIE D.) Wayne Excel Discussion (Misc queries) 0 March 22nd 05 06:24 AM
Running Data Table using an input that triggers DDE linked data [email protected] Excel Discussion (Misc queries) 1 December 16th 04 11:56 AM


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

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"