No problem, follow these steps: 1) Create a new blank sheet 2) Go to the source sheet 3) Select the block you wish to transpose 4) Edit|Copy 5) Select the new blank sheet 6) Select Cell A1 7) Edit|Paste Special 8) Click the transpose checkbox 9) OK This will copy your data into a new sheet with columns and rows transposed. Josef Lowder wrote: > Is there any way to change a horizontal oocalc spreadsheet > to a vertical layout -- i.e. so that all existing horizontal columns > would be converted to become vertical rows, and all data > in each column and row is rearranged accordingly? > > > > ------------------------------------------------------------------------ > > --------------------------------------------------- > PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us > To subscribe, unsubscribe, or to change your mail settings: > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss