Switching from collumns to rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

One of my work collegues created a spreadsheet for us to input records. she
set the days up in the collumns and now we have run out of collumns is there
any way of easily transposing the information to rows without having to type
it all in again (we work with Excel 2000)
 
Shazza,

Select all your data and click Copy
Select the top left cell where you want to past it but note this mustn't
overlap the copied data so it may be best to paste it to another sheet.

Click paste special and check the transpose box and your done.

Mike
 
You can very easily switch from collumns to rows or viceversa by selecting a
rows area with the same or more cells than the columns, and then insert the
TRANSPOSE formula, selecting the array of cells, in the first row, and press
CTRL+ShIFT+ENTER.
You will get values and formulas, though not formats transposed.

i.e..- you have data in the columns A1 to J1. Then you select 10 or more
rows, and insert in the 1st row: =TRANSPOSE(A1:J1) and so press
[CTRL+ShIFT+ENTER]

BR
 
Back
Top