software

It has been a decade since I last used MS Windows. I am a UNIX/Linux
systems designer, but am now forced to use Windows and MS Office. I
find these applications (and the OS iteself, but that's another matter)
totally counter-intuitive*

However, I've got to work with it, and what I would like to learn is
how the (common) trick is done of making certain columns / rows
quot;stickyquot; - that is, they are displayed as you scroll around the
spreadsheet. exceltip.com seems to assume that readers will know such
basic things, but with a 20 year career in IT, I have never needed to
know how to use MS Office (I work with SF25K and similar systems, not
office-based PCs).

Any idea how a novice like myself can make a certain row/column not
scroll (so as to become a quot;headerquot;)?

Steve.
*
- If I open many Excel documents at once, I only see the quot;incorrect
formatquot; error one has when I go to that document ... I'd have expected
it to Excel to highlight the error to me.
- If I hit the top-right Cross in Excel, it closes all spreadsheets;
hit it in Word, and it closes only that document.
- WTF?!
- Oh, well.--
steveparker
------------------------------------------------------------------------
steveparker's Profile: www.excelforum.com/member.php...oamp;userid=30918
View this thread: www.excelforum.com/showthread...hreadid=505937
If you want row 1 to be a header select cell A2 and use

Window gt; Freeze Panes

If you select B2 then you'd freeze both the top row and left column
etc.--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=505937
Thanks, DaddyLongLegs.

I would never have thought of looking under the Window menu, so your
reply is invaluable to me. I'd like to meet the person who put it under
the quot;Windowquot; menu, as well as the person who called it quot;Freeze Framesquot;
:-)

Cheers,

Steve.--
steveparker
------------------------------------------------------------------------
steveparker's Profile: www.excelforum.com/member.php...oamp;userid=30918
View this thread: www.excelforum.com/showthread...hreadid=505937