Please or to access all these features

Chat

Join the discussion and chat with other Mumsnetters about everyday life, relationships and parenting.

I have forgotten how to do a simple basic MS spreadsheet

6 replies

twoandcooplease · 03/12/2022 12:34

I have a bunch of receipts not yet in date order

Can I fill out an excel cells with date, amount, name etc then at the end do something techy that puts all rows into date order for me?

OP posts:
carefulcalculator · 03/12/2022 12:35

Yes, just select the rows you want to sort and use the sort function (can't remember which menu!)

twoandcooplease · 03/12/2022 12:38

I have an A-Z or Z-A option
I thought it was as easy as that too but I may need to highlight each filled row and lock them first?

OP posts:
Twyler · 03/12/2022 12:39

Yes, very simple. Once data entered (presumably with date in first column) just highlight the lot, right click the mouse, select 'sort oldest to newest and 'enter'. Job done.

NannyGythaOgg · 03/12/2022 12:41

Select all the cells in yourtable, go to custom sort, in there Select the column with the dates and sort oldest to newest.

twoandcooplease · 03/12/2022 13:00

Thank you all - I've got it now!

OP posts:
declutteringmymind · 03/12/2022 13:06

I did not knowthis. I always added an extra row. Thank you OP!

New posts on this thread. Refresh page
Swipe left for the next trending thread