Scrolling

mtagliaferri

Board Regular
Joined
Oct 27, 2004
Messages
127
Hi,
I am creating a monthly planner as per screenshot where every cell has a conditional formatting which allocates colours in accordance to a letter entered I have frozen the pane where the names and descriptions sits to be able to see the entire month depending on the zooming the individual uses.
I want to create some kind of dashboard (Blue section in the screenshot) where I want to enter some information such a a count of individual duties entered in that particular month and possibly a YTD.
My issue is the Freeze pane which is great to keep the names visible as you scroll but of course it impacts also the dashboard below, I been checking out some post and I thought I could solve the issue by placing a horizontal scroll bar below the monthly table but my understanding is that this function only works for displaying data from another tab

Any ideas on how I can achieve this without the dashboard scrolling away?
 

Attachments

  • C1.PNG
    C1.PNG
    78 KB · Views: 6

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Watch MrExcel Video

Forum statistics

Threads
1,118,750
Messages
5,574,013
Members
412,562
Latest member
woodportaj
Top