I have a spreadsheet whose main body consists of one column of date data (mm/dd/yy), and six columns of numerical data. There are approximately 1,675 rows. The later dates are at the top. I need to reverse the order so that the new data is entered at the bottom, while maintaining the integrity of the data (obviously). Can you help me out? Thanks!
Tony Answer from Richard Rost:
You should just be able to select all of the data, and then SORT based on date, ascending. Correct? That should keep all of your data together and just reverse the order.
Keep in mind that you're starting to get to the point where it makes sense to move up to a DATABASE program like MS Access. Excel starts to get clumsy when you're dealing with thousands of records.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.
