![]() |
Name stays, everything else scrollable.
I have a speadsheet document that has a list of names on it that go in
column. Each name has specific data to it that goes in the row. However there is alot of data to each name and so when i scroll to the right i no longer can see the name. I would like to keep the names there at all times and have just the data scroll left and right. |
Name stays, everything else scrollable.
Window | freeze panes
Could help you -- regards from Brazil Thanks in advance for your feedback. Marcelo "ruaduck" escreveu: I have a speadsheet document that has a list of names on it that go in column. Each name has specific data to it that goes in the row. However there is alot of data to each name and so when i scroll to the right i no longer can see the name. I would like to keep the names there at all times and have just the data scroll left and right. |
Name stays, everything else scrollable.
hi
if your names are in the a column then place your cursor at B1. then on the menu bar... Window Freeze panes. you can freeze vertically and horizontally. depend on where the cursor is when you freeze panes. Regards FSt1 "ruaduck" wrote: I have a speadsheet document that has a list of names on it that go in column. Each name has specific data to it that goes in the row. However there is alot of data to each name and so when i scroll to the right i no longer can see the name. I would like to keep the names there at all times and have just the data scroll left and right. |
Name stays, everything else scrollable.
use window | freeze panes
On May 28, 10:13*pm, ruaduck wrote: I have a speadsheet document that has a list of names on it that go in column. Each name has specific data to it that goes in the row. *However there is alot of data to each name and so when i scroll to the right i no longer can see the name. I would like to keep the names there at all times and have just the data scroll left and right. |
All times are GMT +1. The time now is 08:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com