| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FIX TOP ROW,SO WHEN I SCROLL DOWN IT STAYS AT TOP | Excel Discussion (Misc queries) | |||
| How can I make the top row of my spreadsheet non-scrollable? | Excel Discussion (Misc queries) | |||
| Scrollable x-axis in excel | Charts and Charting in Excel | |||
| Print scrollable user form. | Excel Discussion (Misc queries) | |||
| how to lock a row so that it stays on top when scrolling | Excel Discussion (Misc queries) | |||
Hybrid Mode
