LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default locking multiple rows in excel 03

I am trying to lock two seperate rows in excel 03 so that I can view both the
column titles at the top of work sheet and the column totals at bottom of
work sheet simultaneously. In other words, I'd like to be able to freeze
rows 1-3 at the top of the sheet and row 101 at the bottom of the sheet and
scroll the remaining 97 rows in-between. any help would be appreciated
greatly.
 
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
Locking rows sthomas Excel Discussion (Misc queries) 1 February 20th 07 07:43 PM
Locking rows or Regions in Excel worksheets Pat Dools Excel Worksheet Functions 0 August 11th 06 03:00 PM
Locking rows in Excel 97 KJo Excel Discussion (Misc queries) 3 May 24th 06 08:52 PM
locking rows Charlie Brown Excel Discussion (Misc queries) 1 July 27th 05 10:14 PM
How to view tiled Excel worksheets by locking rows for scrolling . Ralph S Bryant Excel Worksheet Functions 1 November 23rd 04 06:21 PM


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