Name stays, everything else scrollable.

  • Thread starter Thread starter ruaduck
  • Start date Start date
R

ruaduck

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.
 
Window | freeze panes

Could help you
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"ruaduck" escreveu:
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Formula 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Viewing data in a single column 2
Text to columns 2
scroll automatically as data is imported into a spreadsheet 1
Display index of column headers in column A 9
Finding the next record in a column 2

Back
Top