switching rows & collumns

  • Thread starter Thread starter littlewaywelt
  • Start date Start date
L

littlewaywelt

I have an excel file that I have imported from an access database.
I am wondering if I can reverse the rows and collumns.
I have 215 rows (5 are headsers), but 257 collumns (excels max). If I
can reverse the two I'd be able to combine two spreadsheets into one.
Any way to do this?
 
Select the cells you want to switch
Edit menu | Copy
Edit menu | Paste Special
Use the transpose option.

Try that out.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting sets of cells based on two parameters 4
Problem with collumns and pages... 2
Duplicate Name Rows 1
Collumns 1
Counting rows based on the contents of multiple cells 2
code 'summing' - access query creating an excel-sheet 1
Filling in cells (or not) based on the entry in a specific collumn 3
Switching from collumns to rows 3

Back
Top