Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
steveparker
 
Posts: n/a
Default New User Question


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
"sticky" - 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 "header")?

Steve.



*
- If I open many Excel documents at once, I only see the "incorrect
format" 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: http://www.excelforum.com/member.php...o&userid=30918
View this thread: http://www.excelforum.com/showthread...hreadid=505937

  #2   Report Post  
Posted to microsoft.public.excel.newusers
daddylonglegs
 
Posts: n/a
Default New User Question


If you want row 1 to be a header select cell A2 and use

Window Freeze Panes

If you select B2 then you'd freeze both the top row and left column
etc.


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=505937

  #3   Report Post  
Posted to microsoft.public.excel.newusers
steveparker
 
Posts: n/a
Default New User Question


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 "Window" menu, as well as the person who called it "Freeze Frames"
:-)

Cheers,

Steve.


--
steveparker
------------------------------------------------------------------------
steveparker's Profile: http://www.excelforum.com/member.php...o&userid=30918
View this thread: http://www.excelforum.com/showthread...hreadid=505937

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
user input question BLW Excel Discussion (Misc queries) 2 May 23rd 05 08:41 PM
Hints And Tips For New Posters In The Excel Newsgroups Gary Brown Excel Worksheet Functions 0 April 15th 05 05:47 PM
Data Entry Alert in User Form Kev Excel Discussion (Misc queries) 6 January 8th 05 04:01 PM
File is locked for Editing by user problem Mirth Excel Discussion (Misc queries) 1 December 3rd 04 05:45 PM
find and match the max buffyslay Excel Worksheet Functions 0 November 2nd 04 02:57 PM


All times are GMT +1. The time now is 02:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"