close

About BiteSize and what we can do for you

...all about working smarter, not harder

Register Now!Computer Training and Personal Development - What BiteSize can do for you, ensuring your workforce are fully skilled appropriately to do their job is a powerful asset for any organisation.

BiteSize can help you achieve this quickly and cost effectively. We can help you maximise your IT competence on common every day used desktop applications by using our winning learning formula. This will help you retain your competitive advantage by raising productivity faster than you ever thought possible.

A fast, efficient way of learning using a variety of methods tailored to suit your employees' needs Keeping your skills up to date is crucial. That's what BiteSize will do for you.
Top Panel
About BiteSize...
Top Panel
Microsoft Excel : Transposing Cells Print

Introduce Me

mouseonchair.jpgTransposing Cells in Microsoft Excel

DID YOU KNOW that one of the most over-looked but extremely useful features in Excel is the Transpose option, which helps you re-orientate the contents of the copied range when you paste it back - entries in rows appear in columns

 

 

 

 

 

Tell Me

The Transpose function changes the horizontal or vertical arrangement of a range of cells.  

To transpose your data, simply

  1. Copy the data and then move to the cell where you would like the new data to be entered and
  2. Choose Edit
  3. Paste Special and tick Transpose. The data you copied is now transposed from a row to a column or a column to a row.   That quick and easy

Show Me


Tip

If you transpose cells containing formulas make sure the references in the formulas are absolute before you copy them.  If you want to learn more about Absolute References refer to that lesson


Let Me


Here is an exercise for you to try out transposing for yourself.

Transposing Cells Transposing Cells

TIP

If the "OPEN" option does not show you all icons you'd expect in the application, use the "SAVE" option.

openclose.jpg

Help Me

mouse_head3.jpgRemember to put your new skills into practice as soon as possible.  Learn a little each day to improve your knowledge and skills

 

 

 

 
Back to previous page