Hi, is there a way to reverse the order of all the rows in a spreadsheet in Excel 2003? By this, I mean I have rows 1 to 50, and I want row 50 to move to become the new row 1, row 49 to become row 2, etc. Thanks.

What version of Excel? What data is in the cells? If they are alphabetical or numerical, you could do a sort from Z to A or 50 to 1. "So won’t you give this man his wings What a shame To have to beg you to see We’re not all the same What a shame" - Shinedown

Hi, When you ask "What version of Excel" I presume you mean more than just the "Excel 2003" that I mentioned already? When I do "Help->About" I get "Microsoft(R) Office Excel 2003 (11.8237.8221) SP3". The data in the cells is almost random. It's actually my bank statement, but in reverse date order and I want it in the correct date order, but I can't simply sort on the date column as I also need to reverse all the rows that have the same date. I can add a new column and put the numbers 1,2,3, etc identifying each row, and then sort on that column in descending order. However, that seems a little too much trouble and I was wondering whether there was a simple Excel command to reverse the rows in one go. I googled and found this: http://excel.tips.net/Pages/T002653... That URL has a neat macro for reversing the rows. I tried it and it works. However, I'm not sure exactly how to use it multiple times. I defined the macro in the spreadsheet, but how can I save in such a way that I can use it again and again in multiple spreadsheets?

When you add a new column and then enter numbers into that column such as 1,2,3 etc... Excel conveniently knows it as a list. So, type 1, 2 and 3; highlight/select the same three cells containing those three numbers and then place your cursor over the bottom right hand corner of the bottom selected cell causing the cursor to change to a + symbol and then left click and hold it while dragging it down the column (or double click it to make it go down the entire column until there is nothing in an adjacent cell). It will create the numbered list for you. To use a macro in all spreadsheets save it to your Personal file or save to another and simply have that workbook open when wantign to use it's macro in another workbook/spreadsheet. HTH Bryan P.S. (Started writing this about an hour ago but got interupted by work while composing it)

Thanks Bryan, one more question: when you say "To use a macro in all spreadsheets save it to your Personal file" - what's a Personal file?

DAGS on: create personal.xls Lots of hits and tips

Thanks, got it now.