freeze panes

Hi guys, I have an issue where I froze panes, but when trying to print, the frozen panes do not stay on each page. I can go to: print preview -> page setup -> sheet There's an option there to "repeat rows at top" - but this option is unfortunately grayed out. This only happens for some of my...

I expect someone to come back and just say no, it cannot be done. At least I can stop looking for it. I have to keep row 16 on the screen at all times but I need more real estate on the screen when I scroll down. What I want is to have row 16 scroll up until it gets to the top of the screen as...

I've been working on a Survey template for a project at work. The workbook has multiple worksheets (1 for each question) and a series of repeating List Boxes for responses corresponding to multiple locations. Each list box is populated from a static named range on another worksheet...

hello guys, i wonder how can we lock one entire colum example B and etc after A colum had been freezed-panes?i hope it can make it easier to me when i opened the file, it is straightly appear the colum that had been locked to the following freeze-panes colum.please help.thanks.example file is...

Hi All I am not sure if there is an answer to this question or not but lets give it a shot... I have a sheet that has multiple header rows with data beneath. What I want to do is freeze the header row so that I can scroll down the data keeping the header on top, but then when I get to the next...

Hi, I am dealing with a spreadsheet (Excel 2003) with a lot of assumptions and which has ended up being quite a long one in terms of rows. However, the output of all those assumptions is in the firts few rows of the sheet and it is difficult to follow the overall effect when you change your...

Hi, please see the details below: Background: Excel 2007 Shared workbook with Autofilter and Frozen Panes. Issue: When a user filters the information and then saves the file, excel changes the frozen panes automatically depending on the filtering used (yes, it does it by itself) even when the...

Just got Microsoft Office 2010 and I'm trying to keep things the way they were on 2007. I use Freeze Panes in the top of my sheet and when I go to add page numbers to those pages, on the bottom, it flashes up a warning saying you 'cannot add page numbers with Freeze Panes activated, if you...

Excel 07. We have a workbook with multiple sheets which we are encountering a problem with. The workbook itself is actually in the small to medium size range, having 5 worksheets. It is a shared workbook and is accessible to many people. The problem we are encountering seems to be related to...

Excel 07. We have a workbook with multiple sheets which we are encountering a problem with. The workbook itself is actually in the small to medium size range, having 5 worksheets. It is a shared workbook and is accessible to many people. The problem we are encountering seems to be related to...

Hey Guys, I'm trying to complete a excel workbook for my bosss and would like to freeze the top 2 rows of cells, but it will only allow me to freeze the top row. Is there any way to freeze both? Thanks! Julie

Hi everyone. i have freeze panes in my excel 2007 sheet allowing me to freeze desired top row and left column.... but i have total sum in bottom values of the huge list. So my question is does freeze pane allows me to do a 3-way freeze panes... 1 for top Row, 1 for left Column and 1 for the...

I am really hoping someone can help me with this one! :mad: I have a basic Excel worksheet with comments attached to a number of the column headers. These comments contain criteria relating to information that will be entered below each heading. Since the sheet is fairly long, I want to freeze...

I send out purchase orders via excel every day. I have upwards of 30-50 on any given day. I would like a macro that would subtotal each page before being sent out. The header row is the same on every page (row 8) At each change in "PO#" (column A), use function "sum", add subtotal to "Total"...