I have a tracker in the making. I need the title rows (1-8) to be frozen, then two equal sized, independently scrollable frozen panes below the title rows...
Is this something that is possible?
I've played around with Freeze Panes and Split Panes, but it's just not doing what I need. Am I fighting a battle that can't be won?!
You need freeze panes + two windows tiled horizontally to do that.
Ben Van Johnson
Oh good, it's a real thing! Which ribon do I find a window option?
Or even just a way to do a regular split screen, but to scroll vertically instead of horizontally?
help file for the freeze panes command, explaining how to set it up so you can scroll vertically, horizontally, or both: http://office.microsoft.com/en-us/ex...490.aspx?CTT=1
This document describes the use of mulitple windows for the same workbook: http://support.microsoft.com/kb/254791
Originally Posted by shg
To split the screen vertically, look just to the right of the right arrow on the bottom scroll bar, you will see a small rectangle. If you hover the mouse over that, it will change to a left=right arrow, click and hold, and drag left as far as you need.
For the horizontAL split, the small rectangle is at the top of teh vertical scroll bar
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
I'm not finding any rectangles that allow any changes. When I hover over what I see there, nothing happens!
I need the tracker to look like a T graph:
_____2014 Tracker_____
Column l Column
to scroll l to scroll
up and .l up and
down . . l down
The 2 columns have different formulas and macro enabled buttons in them, which of course, require more than just 1 REAL column...
The left has a list of weekly stats based on times entered into the right hand list, which is literally just a list of 4 columns: date, start time, end time & total time.
The left has a small graph for each month:
January
(Column A) Week 1 l (column B) 0:00 l (coulmn C) 1/1/14 l (column D) 1/4/14
(Column A) Week 2 l (column B) 0:00 l (coulmn C) 1/5/14 l (column D) 1/11/14
etc...
Where column B has a formula to total the information in the list to the right that falls within those dates and displays it.
The reason I need this division in the page is because there's no way to know how many entries it will take each agent to get through that month.
If I knew that, I could just skip down to that many rows below the starting point & put February's weekly sum graph there...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks