training ms excel advanced - Data table, rotate

Resolved · Low Priority · Version Standard

Fri 9 Feb 2007, 17:05 Delegate Adam said...

Adam has attended:
Excel Intermediate course
Excel Advanced course

Data table, rotate

I have a table of data in excel that i effectively need to change to landscape. I need the column headings to instead be down the left handside and the left handside headings accress the top. Is there a quick way of doing this without re entering the data?

Mon 12 Feb 2007, 15:02 Trainer Amanda said...

RE: data table, rotate

Hi Adam

Thanks for your question.

Luckily you don't need to re-enter all your data!

If you select and copy the data you wish to redisplay, then go to a new sheet and select the cell where you want the data to start from.

Go to Edit - Paste Special. Click the Transpose option down the bottom of the dialogue box and click OK.

This should turn columns into rows and rows into columns.

Amanda

Excel tip:

Screen Splitters in Excel

Screen splitter icons can be set from the ribbon bar, or dragged from the scroll bars. The icon just above the up arrow on the right scroll bar controls the horizontal splitter; the icon to the right of the right arrow on the bottom scroll bar controls the vertical splitter.

These icons can be double-clicked to split the screen at the top left of the cell currently in use.

View all Excel hints and tips

training ms excel advanced - Data table, rotate

Data table, rotate

RE: data table, rotate

Excel articles

Excel tip:

Screen Splitters in Excel