Forum home » Delegate support and help forum » Microsoft Excel Training and help » Exel

Exel

ResolvedVersion 2003

Wed 2 Sep 2009, 16:24 Delegate Flavio said...

Flavio has attended:
Excel Advanced course
Effective Communication Skills course
Presentation Skills course
Organisational Skills course

Exel

is there a short cut that displays the values from a columm into rows. all the values that are displayed vertically to be displayed horizontally?
kind regards

Flavs

Wed 2 Sep 2009, 17:03 Trainer Amanda said...

RE: exel

Hello

Thank you for your question and welcome to the forum.

You can use transpose to change column oriented data to display across rows and vice versa.

Select the data, cut or copy it, then go to Edit - Paste Special and click Transpose.

Kind regards
Amanda

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Generate randon numbers

Some types of analysis require you to use randomly generated numbers. You can also use randomly generated numbers to quickly populate an Excel spreadsheet. There's an easy function you can use to do this automatically. Here are a few of the ways you can use it:

Type =RAND() in a cell to generate a number between 0 and 1.
Type =RAND()*100 to generate a number between 1 and 100.

View all Excel hints and tips

Exel

Exel

RE: exel

Excel articles

Excel tip:

Generate randon numbers