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 > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
