LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

You can freeze the top and left of a window, but not the bottom.

To freeze the top row:
Select Row 2
Choose WindowFreeze Panes

To simulate freezing the bottom row, you could open a new window
(WindowNew Window).
Choose WindowArrange, and select Horizontal
Resize the windows so the lower one is quite short.
Scroll to the total row in the lower window


Bill wrote:
Id like to be able to freeze the very first row for headers and freeze the
very bottom row for totals only and be able to scroll thru the rows in
between can i do this?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

 
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



All times are GMT +1. The time now is 02:50 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"