In Excel 2007 is it possible to freeze the top row (where I have column headings) and at the same time freeze a row at the bottom of my data that has totals? This would enable me to scroll through the data in the middle without losing the totals or the headings.
I could put the totals at the top with the headings but the sheet takes the info from somewhere else and that would make matters harder.
Any thoughts please?
AFAIK, you can only freeze the top row(s). You could split the screen though and just show the bottom row in the bottom "window".
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There is a describtion of the workaround here.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks