Can I make "Row 1" "Always on Top?"

  • Thread starter Thread starter wockachucka
  • Start date Start date
W

wockachucka

That would be incredibly convenient when scrolling down a (500 row)
spreadsheet that I've put together. The only alternative seems to be
copying Row 1 and pasting it in every thirty rows or so, which
(frankly) sucks.

I ask because I'm doing reasearch and have put together a long list of
busninesses to call and a set of questions for all of them. Excel seems
to be the best tool I have for sorting the data.

Sorry if this question is really basic, I just learned how to do math
with Excel last week!

I've looked through the properties, help files, searched these forums
and the web to no avail.

Anyone know? Or know of a workaround? TIA.
 
Wochachucka, select B2 then windows, freeze panes

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Select cell A2 and choose Freeze Panes from the Window menu.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
You could use the Windows/Freeze Pains to accomplish this.

Charlie O'Neill
 
Thanks, A2 and B2 worked! Much appreciated.

Any idea on why choosing all of Row 1 freezes panes 1-7? Not ver
intuitive. Just trying to understand the program better.

Thanks again, Chip and Paul
 
Choosing B2 will also freeze column 1

I guess choosing all of row1 is ambiguous.

Choose all of row 2 and it will work.
 
Can the above be done to two or more sheets of a workboo
simultaneously
 
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

Sort by Every Other Row? 0
Row 1 HEADERS on EVERY printed page 2
Keep Headers at top of page 5
locked rows on top and bottom 6
Change scroll rows from 1 to 3 with mouse wheel 1
How do I keep rows a1-a2 always at top of screen when on row 50 1
Move data from every other row to columns 0
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1

Back
Top