training ms excel advanced - data table rotate

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » training ms excel advanced - Data table, rotate

training ms excel advanced - Data table, rotate

resolvedResolved · Low Priority · Version Standard

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?

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


Server loaded in 0.09 secs.