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

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.
 
P

Paul B

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 **
 
C

Chip Pearson

Select cell A2 and choose Freeze Panes from the Window menu.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
W

wockachucka

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
 
T

Tom Ogilvy

Choosing B2 will also freeze column 1

I guess choosing all of row1 is ambiguous.

Choose all of row 2 and it will work.
 
Top