Excel 2013, Freeze Pane/Header Help?

Question

Attached is a picture of the table that I'm creating.

When I try to freeze just the 10 orange blocks at the top, the entire columns are frozen. I only want the 10 orange blocks to repeat between the different days as I scroll left/right/up/down. But all I can seem to do is lock the rows for scrolling down, or lock the columns.

I want these 10 to always be visible during editing. I'd also like to have the month and the days, but I can just add those in individually. Is there a way that I can make it so I can freeze just the 10 blocks that I've selected and not the entire columns or rows?

I'm sorry if this is at all confusing lol. But I'm developing a tracker for work and I need it to be as clean as possible (for a more professional appearance). I'd like to avoid repeating the 10 blocks over and over, throughout the 91 day tracker if possible.

Serious responses only please!

Thank you all in advance!

D.E.B.S. · Accepted Answer

You can freeze entire rows, entire columns, or both.

You can't select say, A1:J1 and hold those while allowing the data below it or to the right of it to scroll.  Excel is not the best for forms.  Often you have to repeat headers to make it work in situations like this.

"I'd also like to have the month and the days, but I can just add those in individually"  << Not sure what this means.  You'd have to give me information on why you can't add them manually and what exactly you'd want them to be.

? · Answer

you can only freeze an entire row or column.
otherwise, the data will not line up properly, causing inconsistencies.

JJ · Answer

Select the cell (just one cell) below the rows and to the right of the columns you want to keep visible when you scroll. Select View > Freeze Panes > Freeze Panes.

Trending News

Excel 2013, Freeze Pane/Header Help?

3 Answers