Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

John,

You might find it more convenient to just select the cell below the rows you
want frozen, and to the right of any columns you want frozen, then do the
freeze command. Rows above the selected cell are frozen, and columns to the
left also. If you scrolled down one row (maybe it's more for print, but you
don't want to see it on the screen), then row 1 would be off the top, and
remain so during the freeze. Pretty cool.

--
Earl Kiosterud
www.smokeylake.com/
-------------------------------------------

"john85374" wrote in message
...
Select Window-Split. Click and drag the horizontal split line between
rows 1
and 2. Click and drag the vertical split line between columns A and B. Now
select Window-Freeze Panes.

That's it.

"littlestar" wrote:

I'm working on a spreadsheet that has contact information in the farthest
lefthand collumn and collumn headers at the top of the spreadsheet. Is
there
a way that I can freeze both of them so that I always know what I'm
looking
at without having to scroll all the way up or all the way over? Thanks a
bunch! =)



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
generate multiple rows based on cell value Theresa Excel Worksheet Functions 0 May 25th 05 11:18 PM
Deleting multiple rows through a formula mike_vr Excel Discussion (Misc queries) 1 March 15th 05 01:29 PM
Convert multiple columns to rows Lois Lane Excel Worksheet Functions 8 January 10th 05 12:47 AM
Inserting Multiple Rows with Formulas ShineboxNJ Excel Worksheet Functions 2 November 18th 04 02:30 AM
Count rows based on multiple criteria Murph Excel Worksheet Functions 1 October 28th 04 07:13 AM


All times are GMT +1. The time now is 04:27 PM.

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

About Us

"It's about Microsoft Excel"