Can I save my excel spreadsheet in reverse?

%3CLINGO-SUB%20id%3D%22lingo-sub-2273154%22%20slang%3D%22en-US%22%3ECan%20I%20save%20my%20excel%20spreadsheet%20in%20reverse%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2273154%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20other%20words..%20instead%20of%20my%20excel%20spread%20sheet%20which%20is%20(2278%20lines)%26nbsp%3B%20from%201%20to%202278.%2C%20%26nbsp%3B%20can%20it%20be%20saved%20from%202278%20to%201%26nbsp%3B%20%3F%26nbsp%3B%20Orin%20this%20example%20-%26nbsp%3B%20April%202021%26nbsp%3B%20to%20January%202016%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eas%20it%20is%20now%20I%20can%20open%20the%20spreadsheet%20(%20windows%2010%20)%20to%20my%20first%20page%20of%20April%202021%26nbsp%3B%20but%20when%20I%20save%20it%20to%20drop%20box%20and%20then%20reopen%20on%20dropbox%20from%20another%20computer%26nbsp%3B%20I%20have%20to%20manually%20scroll%20from%20top%20to%20bottom%20to%20get%20to%20April%202021%20..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIdeas%20%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThankyou%20!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2273154%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eoffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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 !

1 Reply

@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)))