how do you freeze panes in excel for mac

How Do You Ze Panes In Excel How To Control Cookies
How Do You Ze Panes In Excel Mac Will Apply

I love Excel 2008 and its other versions, though I always am aware of ways that things can be improved.

How Do You Ze Panes In Excel Mac Will Apply

Im sure the tip in this article for Excel 2008 for the Mac will apply to other versions as well.

The reason would be that youre in the Page View mode, rather than the Normal View modewhich can be selected from the View Menu.

This experience with not being able to freeze panes in Microsoft Excel 2008 for the Mac left me with this thought: in other words: one practical reason I started this blog was to rememberrecord ways of helping keep track of vital things Id learned in an easy-to-find place, while sharing them with other people.

Maybe composing in Google docs or the like would be a better idea.

Search terms: freeze panes in excel, excel freeze panes, etc.

Optimized Probably not optimizedone good note is that I made sure to include in the title and meta-keyword tags the version and operating environment so that people would be more likely to find this if it was exactly what they were looking for.).

How Do You Ze Panes In Excel How To Control Cookies

To find out more, including how to control cookies, see here.

That was driving me crazy and to think the simple fix was to just get off of Cell A1,smh Who would have thunk it.

For example, has your screen ever had crosshairs in the middle of the worksheet If youre not sure what Im talking about, please click this link to open an Excel 2007 file (zipped, no macros) named Freeze-Panes-Problems-1.xlsx to view the problem.

Or, have you ever opened a spreadsheet and tried to move down the spreadsheet using either the scroll bar or keyboard down arrow but nothing seemed to happen Please click this link to open an Excel 2007 file (zipped, no macros) named Freeze-Panes-Problems-2.xlsx to view this situation.

In the first case, the crosshairs in the middle are a result of someone applying the Freeze Panes feature while Cell A1 is the active cell.

In the second case, this can happen if someone applies the Freeze Panes feature while the data is filtered.

To fix the problem in the second case, Unfreeze the Panes, make sure the data is not filtered, and reapply the Freeze Panes feature.

On the Home tab on the Ribbon, in the Editing group, click the icon labeled Sort Filter.

Moreover, be sure to remove any splitting before freezing panes again.

I cant seem to get it to freeze the titles and first column together so I can scroll the data.any other suggestions.

To be sure I understand, after you were sure the panes were not frozen, you clicked Cell B2, froze the panes (View Freeze Panes dropdown Freeze Panes (NOT freeze top row)), and when you scrolled to the right, the first column did not stay visible.

It doesnt matter what cell I have selected it still gives me the crosshair in the middle of the sheet.

After you do that, you should be able to select Cell B3, and freeze the panes as I described in my response to Scott.

I had highlighted the first 3 rows, but the first 10 rows were frozen.

So in this case I click on cell A4, and the top 3 rows are now included in the freeze pane.

Also, Im not sure why it works this way, but the method hasnt changed for quite some time.

I read your suggested solution and thought NO WAY But indeed 2013 works like you said.

Once I unfroze the panes, clicked on cell C3, then selected Freeze Panes, it worked.

I have frozen the first row and column by making cell B2 active and then freezing panes.

I can even save and close the file, and the panes are still frozen when I reopen the file.

However, if I open a new window for this file (ViewWindowNew Window), the new window does NOT have frozen panes.

As I have frozen panes on many tabs in this spreadsheet I have to be VERY careful about which file I close first.

Is there a way to get the new window to retain the frozen panes settings.

Perhaps youve investigated this already, but Im wondering if there is another way of accomplishing your task(s) without creating a new window.

In all the years Ive used Excel, the only time I created a new window was related to training on Excel.

How Do You Freeze Panes In Excel For Mac