LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Can I freeze different rows? Can anyone help?


Hi Everyone, My excel skills are basic so hopefully you'll understand
what I want to do... I have created a sheet with headers/titles at the
top of the columns on a sheet and at the bottom of the sheet (all on
one page) are the totals. I wish to freeze the top 4 rows so they dont
move and the bottom 3 rows so when you use the scroll bar only the
middle part of the sheet moves. This is so you can see the headers for
each column and the totals at the bottom of the screen at all times. Is
this even possible? Hope someone understands what I mean. I have tried
using the freeze pane function but it seems I can only freeze either the
top or the bottom not both.

Any help would be greatly appreciated.

Thanks
Grant


--
starlet
------------------------------------------------------------------------
starlet's Profile: http://www.excelforum.com/member.php...o&userid=36569
View this thread: http://www.excelforum.com/showthread...hreadid=563144

 
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
Copying multiple rows to other worksheets (but amount of rows varies) - How? David Smithz Excel Discussion (Misc queries) 1 June 18th 06 04:31 PM
(Unsuccessfully!) Unhiding Rows in Excel 2003 [email protected] Excel Worksheet Functions 6 May 24th 06 08:17 PM
Rows & Columns in Excel seadragon69 Excel Worksheet Functions 2 December 7th 05 05:54 PM
Hiding Rows if the linked rows are blank KG Excel Discussion (Misc queries) 9 May 18th 05 02:32 AM
Row selections by row # OR by even/odd rows in another spreadsheet Tom Excel Discussion (Misc queries) 0 February 9th 05 04:03 PM


All times are GMT +1. The time now is 06:39 PM.

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"