ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Newbie Date cells so most recent is on top (https://www.excelbanter.com/excel-worksheet-functions/88500-newbie-date-cells-so-most-recent-top.html)

[email protected]

Newbie Date cells so most recent is on top
 
Trying to create a better spreadsheet, is there a way to reverse the
entries so the most recent date or input appears on the top of the page
instead of the bottom. Thank you for any help you can give.


macropod

Newbie Date cells so most recent is on top
 
Hi Mitymack,

If you number the existing rows (eg using autofill) using a temporary
column, then sort the sheet using this column as the sort key, with the sort
order set to 'descending' the data order will be reversed.

Cheers


wrote in message
ps.com...
Trying to create a better spreadsheet, is there a way to reverse the
entries so the most recent date or input appears on the top of the page
instead of the bottom. Thank you for any help you can give.





All times are GMT +1. The time now is 04:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com