Scrolling within a spreadsheet

**Airsoul** · 12-04-2012, 05:27 AM

Hi All,

Firstly, thanks in advance to anyone that can help me out here. I have attached a sample spreadsheet to show exactly what i am trying to do, hopefully a picture paints a 1000 words.

On the attached spreadsheet i want to have an area dedicated to the dates in a year, called PLAN, you can see it in the middle of the spreadsheet rows 9 - 12.

The function will be a calendar but i want to be able to scroll along the dates, January 1st to December 31st without moving the rest of the spreadsheet.

Is it possible.

C 10, 11 and 12 through AN 10 11 and 12 would be the only cells that scroll?

Once again, thanks.

**JBeaucaire** · 12-04-2012, 08:53 AM

You can use the FREEZE PANES feature to freeze rows at the top and/or the left of the spreadsheet. You cannot freeze rows above AND below, just above.

1) Click on C10
2) Select View > Freeze Panes > Freeze Panes

Now you can scroll to the right.

Based on your question, I do not believe you will satisified as you scroll to the right, the upper rows will scroll as well.

Perhaps you can employ the CAMERA tool to place a live "picture" at the top and bottom of your screen showing the two sections of cells, this live picture would not scroll.

http://blogs.mccombs.utexas.edu/the-...tool-in-excel/
http://chandoo.org/wp/2008/12/02/exc...era-tool-help/
http://www.addictivetips.com/microso...in-excel-2010/

**Airsoul** · 12-05-2012, 02:13 AM

Hi JB,

Looks like live pictures (new tool for me) is about the best solution i can hope for.

Thanks for your help, it really is appreciated.

Cheers
Airsoul