Need to Freeze mutiple rows - (TOP ROW NOT ONE)
How can I freeze multiple rows? I need to freeze row 5, and then again at 83?
The only thing I have found/figured out is that with multiple row freezes, one has to the be top row.
I need the top 5 rows. Very frustrating. Tried playing with the Split and freeze function - no luck, no luck searching google.
HELP!! Tired but determined to do this.
Only one Vertical/Horizontal Split / Freeze Pane is possible in excel, not more than that
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi, ajsantry,
Not at all with what Excel offers. Maybe try and use pictures instead (photograph) to do whatever you think you would need this for (or maybe have a look at grouping). Or sinply hide the other rows (but I doubt that you might need some of the contents of these rows).Tired but determined to do this.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Or
Make use of Camera option which will display the source range(s) data
Any ideas on how to accomplish this.
Top Five rows are my formula totals.
The spreadsheet is being build upon month after month - vertically. I need access to all the data but not all the time. Is there any way to basically bookmark or stop from scrolling everything above.
Sorry if that doesn't make sense.
Check the below link...
http://www.addictivetips.com/microso...in-excel-2010/
I think you have already been given the only options that will help you on this
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks