ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Name stays, everything else scrollable. (https://www.excelbanter.com/excel-discussion-misc-queries/189116-name-stays-everything-else-scrollable.html)

ruaduck

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.

Marcelo

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.


FSt1

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.


muddan madhu

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