How To Freeze Two Panes In Excel For Mac 2008

How To Freeze Two Panes In Excel For Mac 2008 5,8/10 1750 votes

I have, but the only relevant hit is to show where it appears on the Window menu. It doesn't find any help on using it.

Jul 23, 2010 - Excel 2007 Windows XP Can the first TWO rows be frozen - I only find freeze top row.

The other hits are primarily focused on what to do if the program freezes. 'Bob I' wrote: This is primarily a Windows population here and also, there are several Mac versions. But to answer your question, have you tried looking up 'Freeze Panes' in Help? Curious wrote: I use a Mac but have used Office extensively on DOS & Windows. The 'Freeze Panes' function was always great to use but in the Mac spreadsheet I'm using it is not available as a selection. Is there something wrong with the way I am using it, or is it just not available in the Mac version? If you don't get any additional responses here, you could pose your question over in the microsoft.public.mac.office.excel newsgroup.

They should know. Curious wrote: I have, but the only relevant hit is to show where it appears on the Window menu. It doesn't find any help on using it. Where is the paragraph dialog box in word for machine. The other hits are primarily focused on what to do if the program freezes. 'Bob I' wrote: This is primarily a Windows population here and also, there are several Mac versions. But to answer your question, have you tried looking up 'Freeze Panes' in Help?

Curious wrote: I use a Mac but have used Office extensively on DOS & Windows. The 'Freeze Panes' function was always great to use but in the Mac spreadsheet I'm using it is not available as a selection. Is there something wrong with the way I am using it, or is it just not available in the Mac version? I found the answer. The files opened in Page Layout view and the Freeze Panes feature is only available in Normal view.

'Bob I' wrote: This is primarily a Windows population here and also, there are several Mac versions. But to answer your question, have you tried looking up 'Freeze Panes' in Help? Curious wrote: I use a Mac but have used Office extensively on DOS & Windows. The 'Freeze Panes' function was always great to use but in the Mac spreadsheet I'm using it is not available as a selection. Is there something wrong with the way I am using it, or is it just not available in the Mac version?

Thank you for posting back with your discovery. Curious wrote: I found the answer. The files opened in Page Layout view and the Freeze Panes feature is only available in Normal view.

'Bob I' wrote: This is primarily a Windows population here and also, there are several Mac versions. But to answer your question, have you tried looking up 'Freeze Panes' in Help?

Curious wrote: I use a Mac but have used Office extensively on DOS & Windows. The 'Freeze Panes' function was always great to use but in the Mac spreadsheet I'm using it is not available as a selection. Is there something wrong with the way I am using it, or is it just not available in the Mac version?

Select cell B2 and click 'Freeze Panes' this will freeze Row 1 and Column A. For future reference, selecting Freeze Panes in Excel will freeze the rows above your selected cell and the columns to the left of your selected cell. For example, to freeze rows 1 and 2 and column A, you could select cell B3 and click Freeze Panes. You could also freeze columns A and B and row 1, by selecting cell C2 and clicking 'Freeze Panes'. Visual Aid on Freeze Panes in Excel 2010 - Microsoft Reference Guide (More Complicated, but resourceful none the less).