On Wed, Jan 15, 2014 at 5:13 PM, Jim Plante <jimpla...@me.com> wrote: > Add a column in front of Column A. Enter in the cell "=ROW()"; If the sheet > contains a header row in Row 1, then make that formula "=ROW()-1". Copy that > formula all the way down. > > Now, select the entire table and sort descending on Column 1. You can retain > or delete the extra column when you've finished. > > Jim > > On Jan 15, 2014, at 4:45 PM, Wade Smart wrote: > >> In my calc sheet I have a need to flip the >> entire sheet. So Column 1A would be 450A? >> Ive found several macros but Ive not been >> able to get them to work. Does anyone know >> if this can be done? >> >> Wade >> -- >> Registered Linux User: #480675 >> Registered Linux Machine: #408606 >> Linux since June 2005
I figured out the same thing just as you were posting. I went to A450 and put 1 and just drug backwards creating negative numbers and then hit Z-A function and it flipped all the columns involved. I had A - AB so it was a lot of data to flip. Im glad it turned out to be very easy. Thanks Jim. -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
