rotating a spreadsheet

W

whunter3333

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

I'd like to switch my rows to columns and my columns to rows in an existing spreadsheet. Can someone tell me how to do this?

WH
 
B

Bob Greenblatt

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

I'd like to switch my rows to columns and my columns to rows in an existing
spreadsheet. Can someone tell me how to do this?

WH
Click to expand...
Sure,

Copy the area you wish to switch. Select the single cell to be the upper
left corner of the new area. Then choose Edit-paste Special, and choose
transpose.
 
Top