locking multiple rows in excel 03

P

pitt99

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.
 
O

Otto Moehrbach

Place your column totals formulas at the top of the sheet under the header
row, then freeze the header and totals rows. HTH Otto
 
A

Ashish Mathur

Hi,

You could use the Windows > Split feature. After you split the windows
horizontally, scroll to row 101 in the lower window and in the upper window
you could scroll between row 3 and 100

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match and delete rows on two different sheets from reference numbers 4
Excel 2007 Is it possible to vary the column width between rows? 3
Freezing multiple rows/columns in Excel 2007 Pro 3
Excel Cannot delete empty cells/rows 4
Freeze /Split frames 4
Lookup & return multiple rows based on cell value 3
Freezing top and bottom rows 5
Hide Rows based on value, but not using autofilter 2

Top