XL Spreadsheet Question?

[Deleted account W]

Is there a way of inverting a page so that everything in rows gets placed into columns?

So row 1 becomes column A, row 2 becomes column B and so on.

 

[richie]

Yes

Select, edit copy


Right hand click, paste special transpose....

I would dare say "anybody could do that" before I started building crap kitchens , I used to do crappy IT work

 

[Deleted account W]

Well, that crappy answer worked a treat, thanks

Another string to my bow now, XL Master Craftsman

 

[richie]

Well, that crappy answer worked a treat, thanks

Another string to my bow now, XL Master Craftsman

no problemo

 

[freeloader]

Alternatively, [ctrl][alt] left arrow.

 

[Stonker]

Ctrl A
Ctrl C
Turn the screen on it's side
Ctrl V