How would I display selected row on a new work sheet? [duplicate]

This question already has answers here: Closed 11 years ago.

Possible Duplicate:

How to edit info in cells displayed via macro code in Excel?

I'm just a bit stumped.

I have a large excel table with quite a few columns. The first column item is a 'company name' and then the other columns contain details such as 'website', 'contact name', 'email address', 'query', 'comments' etc etc.

It's a bit confusing and difficult scrolling all the way to the right to see the info in the columns at the end.

I was wondering if there would be any way I could maybe take all the info from a single row and display it on sheet two? Perhaps displaying it vertically, so that I wouldn't have to scroll to the right to see all the company details.

What I would l开发者_运维知识库ike, is to be able to look through the main spreadsheet to find a 'company name' and then maybe if I click on that company name, all the info from that row would show up in a nice table on sheet two.

---

There are some ways to do it, let's see if one of them fits your needs:

• Freeze pane: Click in cell B1 and then 'view / freeze pane'.
• Split: It will split (duh) your spreadsheet.

I believe one of these might fit your request. hope it helps!

Rgds

Edit: Similar question HERE.