Forum Discussion

ttodd0450740's avatar
ttodd0450740
Copper Contributor
Apr 14, 2021

Can I save my excel spreadsheet in reverse?

In other words.. instead of my excel spread sheet which is (2278 lines)  from 1 to 2278.,   can it be saved from 2278 to 1  ?  Orin this example -  April 2021  to January 2016 .

 

as it is now I can open the spreadsheet ( windows 10 ) to my first page of April 2021  but when I save it to drop box and then reopen on dropbox from another computer  I have to manually scroll from top to bottom to get to April 2021 ..

 

Ideas ??

 

Thankyou !

office 365

1 Reply

  • mtarler's avatar
    mtarler
    Silver Contributor
    Apr 14, 2021

    ttodd0450740  if you are on 365 then you can put this formula on a new sheet and substitute the array Sheet1!A1:D7 with the area on the sheet you want to reverse:

    =LET(in,Sheet1!A1:D7, r,ROWS(in),c,COLUMNS(in),INDEX(in,SEQUENCE(r,,r,-1),SEQUENCE(,c,1,1)))

Resources