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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
training ms excel advanced - data table rotate

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

ResolvedVersion 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:

Select only cell that contain text to lock format

For selecting cells that only contain Text in Excel

By selecting cells that only contain text, you can delete, fill or protect cells of this type.

Use short cut to Go to box (F5) or Edit, Go to
In the dialog box, click special button & select Constants and only check text or any other desired type.

Click OK.

And text cells will all be highlighted for you to apply format. Please note only works on one sheet at a time.

View all Excel hints and tips

TrustPilot
TrustScore 4.9 / 5       2394 reviews

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

STL training logo

Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Verified by Visa
Security verified
Microsoft Partner
Terms & Conditions Privacy & Cookie Policy Consent preferences
Server loaded in 0.11 secs.