如何在新工作表上显示选定的行？
我只是有点困惑。
我有一个很大的 Excel 表格，其中有很多列。第一列项目是“公司名称”，然后其他列包含“网站”、“联系人姓名”、“电子邮件地址”、“查询”、“评论”等详细信息。
滚动有点混乱和困难一直向右查看最后列中的信息。
我想知道是否有任何方法可以从单行中获取所有信息并将其显示在第二张纸上？也许垂直显示它，这样我就不必滚动到右侧来查看所有公司详细信息。
我想要的是能够浏览主电子表格以找到“公司名称”，然后也许如果我单击该公司名称，该行中的所有信息都会显示在第二张纸上的一个漂亮表格中。
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 like, 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.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
有几种方法可以做到这一点，让我们看看其中一种是否满足您的需求：
我相信其中之一可能符合您的要求。希望有帮助！
Rgds
编辑：类似的问题此处。
There are some ways to do it, let's see if one of them fits your needs:
I believe one of these might fit your request. hope it helps!
Rgds
Edit: Similar question HERE.