Excel Freeze Panes

In past versions of Excel, I could freeze panes vertically or horizontally by moving my cursor to the edge of the spreadsheet until a small icon like this appeared:

<-||->

I could then drag the icon over (or down) to freeze the pane. After that the symbol would appear when I put my cursor over the pane line and I could always drag it to adjust the location.

Now, in 365, the icon no longer appears on the edge. It seems like the only way to do it is to go to "View-Freeze Panes" on the menu. Was this great feature really removed or was it perhaps an add-on or ...? I still have an old spreadsheet with a frozen pane and I can still move that one around. However, I can't create new ones.

asked Dec 20 '18 at 21:46

Tomas

1

I don't have an answer as I was never aware of the behaviour you describe. However, I have customised the Quick Access Toolbar to include "Freeze Panes" as one of the items, and I find that very useful.
– Blackwood
Dec 20 '18 at 22:07

Thanks for the reply. Upon further inspection, the feature is actually the "split" feature on the menu. However, I have the same issue as I have to highlight a row/column and click on the menu rather than simply moving my cursor to the edge of the screen.
– Tomas
Dec 20 '18 at 23:07

add a comment |

In past versions of Excel, I could freeze panes vertically or horizontally by moving my cursor to the edge of the spreadsheet until a small icon like this appeared:

<-||->

I could then drag the icon over (or down) to freeze the pane. After that the symbol would appear when I put my cursor over the pane line and I could always drag it to adjust the location.

asked Dec 20 '18 at 21:46

Tomas

1

I don't have an answer as I was never aware of the behaviour you describe. However, I have customised the Quick Access Toolbar to include "Freeze Panes" as one of the items, and I find that very useful.
– Blackwood
Dec 20 '18 at 22:07

Thanks for the reply. Upon further inspection, the feature is actually the "split" feature on the menu. However, I have the same issue as I have to highlight a row/column and click on the menu rather than simply moving my cursor to the edge of the screen.
– Tomas
Dec 20 '18 at 23:07

add a comment |

In past versions of Excel, I could freeze panes vertically or horizontally by moving my cursor to the edge of the spreadsheet until a small icon like this appeared:

<-||->

I could then drag the icon over (or down) to freeze the pane. After that the symbol would appear when I put my cursor over the pane line and I could always drag it to adjust the location.

asked Dec 20 '18 at 21:46

Tomas

In past versions of Excel, I could freeze panes vertically or horizontally by moving my cursor to the edge of the spreadsheet until a small icon like this appeared:

<-||->

I could then drag the icon over (or down) to freeze the pane. After that the symbol would appear when I put my cursor over the pane line and I could always drag it to adjust the location.

microsoft-excel freeze

asked Dec 20 '18 at 21:46

Tomas

asked Dec 20 '18 at 21:46

Tomas

asked Dec 20 '18 at 21:46

Tomas

asked Dec 20 '18 at 21:46

Tomas

asked Dec 20 '18 at 21:46

Tomas

1

I don't have an answer as I was never aware of the behaviour you describe. However, I have customised the Quick Access Toolbar to include "Freeze Panes" as one of the items, and I find that very useful.
– Blackwood
Dec 20 '18 at 22:07

Thanks for the reply. Upon further inspection, the feature is actually the "split" feature on the menu. However, I have the same issue as I have to highlight a row/column and click on the menu rather than simply moving my cursor to the edge of the screen.
– Tomas
Dec 20 '18 at 23:07

add a comment |

1

I don't have an answer as I was never aware of the behaviour you describe. However, I have customised the Quick Access Toolbar to include "Freeze Panes" as one of the items, and I find that very useful.
– Blackwood
Dec 20 '18 at 22:07

Thanks for the reply. Upon further inspection, the feature is actually the "split" feature on the menu. However, I have the same issue as I have to highlight a row/column and click on the menu rather than simply moving my cursor to the edge of the screen.
– Tomas
Dec 20 '18 at 23:07

I don't have an answer as I was never aware of the behaviour you describe. However, I have customised the Quick Access Toolbar to include "Freeze Panes" as one of the items, and I find that very useful.
– Blackwood
Dec 20 '18 at 22:07

Thanks for the reply. Upon further inspection, the feature is actually the "split" feature on the menu. However, I have the same issue as I have to highlight a row/column and click on the menu rather than simply moving my cursor to the edge of the screen.
– Tomas
Dec 20 '18 at 23:07

add a comment |

1 Answer
1

active

oldest

votes

Excel 2013 and Excel 2010

When you work with a large Excel worksheet, it's often difficult to remember exactly what kind of data, columns or rows contain once you begin scrolling around the sheet.

To freeze the top row or first column:

From the View tab, Windows Group, click the Freeze Panes drop down arrow

Select either Freeze Top Row or Freeze First Column

Excel inserts a thin line to show you where the frozen pane begins

To freeze several rows:

Select the row that is immediately beneath the last row you want frozen

From the View tab, Windows Group, click the Freeze Panes drop down and select Freeze Panes

Excel inserts a thin line to show you where the frozen pane begins

To freeze several column:

Select the column that's immediately to the right of the last column you want frozen

Select the View tab, Windows Group, click the Freeze Panes drop down and select Freeze Panes

Excel inserts a thin line to show you where the frozen pane begins

To freeze horizontal and vertical headings simultaneously:

Select the cell in the upper-left corner of the range you want to remain scrollable

Select View tab, Windows Group, click Freeze Panes from the menu bar

Excel inserts two lines to indicate where the frozen panes begin

To restore the workbook to its normal view:

Select View tab, Windows Group, click Freeze Panes and select Unfreeze Panes

(Shortcut key of Freeze panes: – Alt+W,F,F)

Freeze panes: Put the active cell in the desired location, and press
Alt+w and then F. To remove the freeze panes, use the same shortcut.

Also, there is a possibility that the freeze panes may have been disabled:

how to enable freeze panes link

The icon also appears, when you do a split on your windows:
enter image description here

link how to split windows: click me

edited Dec 21 '18 at 14:09

answered Dec 20 '18 at 22:42

DeerSpotter

298111

2

This doesn't appear to answer the question. The questioner knows how to freeze pains. The question asks about a shortcut that the questioner believes to have been removed.
– Blackwood
Dec 20 '18 at 23:04

its the only way to do it now
– DeerSpotter
Dec 21 '18 at 13:56

add a comment |

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1386452%2fexcel-freeze-panes%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

Excel 2013 and Excel 2010

When you work with a large Excel worksheet, it's often difficult to remember exactly what kind of data, columns or rows contain once you begin scrolling around the sheet.

To freeze the top row or first column:

From the View tab, Windows Group, click the Freeze Panes drop down arrow

Select either Freeze Top Row or Freeze First Column

Excel inserts a thin line to show you where the frozen pane begins

To freeze several rows:

Select the row that is immediately beneath the last row you want frozen

From the View tab, Windows Group, click the Freeze Panes drop down and select Freeze Panes

Excel inserts a thin line to show you where the frozen pane begins

To freeze several column:

Select the column that's immediately to the right of the last column you want frozen

Select the View tab, Windows Group, click the Freeze Panes drop down and select Freeze Panes

Excel inserts a thin line to show you where the frozen pane begins

To freeze horizontal and vertical headings simultaneously:

Select the cell in the upper-left corner of the range you want to remain scrollable

Select View tab, Windows Group, click Freeze Panes from the menu bar

Excel inserts two lines to indicate where the frozen panes begin

To restore the workbook to its normal view:

Select View tab, Windows Group, click Freeze Panes and select Unfreeze Panes

(Shortcut key of Freeze panes: – Alt+W,F,F)

Freeze panes: Put the active cell in the desired location, and press
Alt+w and then F. To remove the freeze panes, use the same shortcut.

Also, there is a possibility that the freeze panes may have been disabled:

how to enable freeze panes link

The icon also appears, when you do a split on your windows:
enter image description here

link how to split windows: click me

edited Dec 21 '18 at 14:09

answered Dec 20 '18 at 22:42

DeerSpotter

298111

2

This doesn't appear to answer the question. The questioner knows how to freeze pains. The question asks about a shortcut that the questioner believes to have been removed.
– Blackwood
Dec 20 '18 at 23:04

its the only way to do it now
– DeerSpotter
Dec 21 '18 at 13:56

add a comment |

Excel 2013 and Excel 2010

When you work with a large Excel worksheet, it's often difficult to remember exactly what kind of data, columns or rows contain once you begin scrolling around the sheet.

To freeze the top row or first column:

From the View tab, Windows Group, click the Freeze Panes drop down arrow

Select either Freeze Top Row or Freeze First Column

Excel inserts a thin line to show you where the frozen pane begins

To freeze several rows:

Select the row that is immediately beneath the last row you want frozen

From the View tab, Windows Group, click the Freeze Panes drop down and select Freeze Panes

Excel inserts a thin line to show you where the frozen pane begins

To freeze several column:

Select the column that's immediately to the right of the last column you want frozen

Select the View tab, Windows Group, click the Freeze Panes drop down and select Freeze Panes

Excel inserts a thin line to show you where the frozen pane begins

To freeze horizontal and vertical headings simultaneously:

Select the cell in the upper-left corner of the range you want to remain scrollable

Select View tab, Windows Group, click Freeze Panes from the menu bar

Excel inserts two lines to indicate where the frozen panes begin

To restore the workbook to its normal view:

Select View tab, Windows Group, click Freeze Panes and select Unfreeze Panes

(Shortcut key of Freeze panes: – Alt+W,F,F)

Freeze panes: Put the active cell in the desired location, and press
Alt+w and then F. To remove the freeze panes, use the same shortcut.

Also, there is a possibility that the freeze panes may have been disabled:

how to enable freeze panes link

The icon also appears, when you do a split on your windows:
enter image description here

link how to split windows: click me

edited Dec 21 '18 at 14:09

answered Dec 20 '18 at 22:42

DeerSpotter

298111

2

This doesn't appear to answer the question. The questioner knows how to freeze pains. The question asks about a shortcut that the questioner believes to have been removed.
– Blackwood
Dec 20 '18 at 23:04

its the only way to do it now
– DeerSpotter
Dec 21 '18 at 13:56

add a comment |

Excel 2013 and Excel 2010

When you work with a large Excel worksheet, it's often difficult to remember exactly what kind of data, columns or rows contain once you begin scrolling around the sheet.

To freeze the top row or first column:

From the View tab, Windows Group, click the Freeze Panes drop down arrow

Select either Freeze Top Row or Freeze First Column

Excel inserts a thin line to show you where the frozen pane begins

To freeze several rows:

Select the row that is immediately beneath the last row you want frozen

From the View tab, Windows Group, click the Freeze Panes drop down and select Freeze Panes

Excel inserts a thin line to show you where the frozen pane begins

To freeze several column:

Select the column that's immediately to the right of the last column you want frozen

Select the View tab, Windows Group, click the Freeze Panes drop down and select Freeze Panes

Excel inserts a thin line to show you where the frozen pane begins

To freeze horizontal and vertical headings simultaneously:

Select the cell in the upper-left corner of the range you want to remain scrollable

Select View tab, Windows Group, click Freeze Panes from the menu bar

Excel inserts two lines to indicate where the frozen panes begin

To restore the workbook to its normal view:

Select View tab, Windows Group, click Freeze Panes and select Unfreeze Panes

(Shortcut key of Freeze panes: – Alt+W,F,F)

Freeze panes: Put the active cell in the desired location, and press
Alt+w and then F. To remove the freeze panes, use the same shortcut.

Also, there is a possibility that the freeze panes may have been disabled:

how to enable freeze panes link

The icon also appears, when you do a split on your windows:
enter image description here

link how to split windows: click me

edited Dec 21 '18 at 14:09

answered Dec 20 '18 at 22:42

DeerSpotter

298111

Excel 2013 and Excel 2010

When you work with a large Excel worksheet, it's often difficult to remember exactly what kind of data, columns or rows contain once you begin scrolling around the sheet.

To freeze the top row or first column:

From the View tab, Windows Group, click the Freeze Panes drop down arrow

Select either Freeze Top Row or Freeze First Column

Excel inserts a thin line to show you where the frozen pane begins

To freeze several rows:

Select the row that is immediately beneath the last row you want frozen

From the View tab, Windows Group, click the Freeze Panes drop down and select Freeze Panes

Excel inserts a thin line to show you where the frozen pane begins

To freeze several column:

Select the column that's immediately to the right of the last column you want frozen

Select the View tab, Windows Group, click the Freeze Panes drop down and select Freeze Panes

Excel inserts a thin line to show you where the frozen pane begins

To freeze horizontal and vertical headings simultaneously:

Select the cell in the upper-left corner of the range you want to remain scrollable

Select View tab, Windows Group, click Freeze Panes from the menu bar

Excel inserts two lines to indicate where the frozen panes begin

To restore the workbook to its normal view:

Select View tab, Windows Group, click Freeze Panes and select Unfreeze Panes

(Shortcut key of Freeze panes: – Alt+W,F,F)

Freeze panes: Put the active cell in the desired location, and press
Alt+w and then F. To remove the freeze panes, use the same shortcut.

Also, there is a possibility that the freeze panes may have been disabled:

how to enable freeze panes link

The icon also appears, when you do a split on your windows:
enter image description here

link how to split windows: click me

edited Dec 21 '18 at 14:09

answered Dec 20 '18 at 22:42

DeerSpotter

298111

edited Dec 21 '18 at 14:09

answered Dec 20 '18 at 22:42

DeerSpotter

298111

answered Dec 20 '18 at 22:42

DeerSpotter

298111

answered Dec 20 '18 at 22:42

DeerSpotter

298111

2

This doesn't appear to answer the question. The questioner knows how to freeze pains. The question asks about a shortcut that the questioner believes to have been removed.
– Blackwood
Dec 20 '18 at 23:04

its the only way to do it now
– DeerSpotter
Dec 21 '18 at 13:56

add a comment |

2

This doesn't appear to answer the question. The questioner knows how to freeze pains. The question asks about a shortcut that the questioner believes to have been removed.
– Blackwood
Dec 20 '18 at 23:04

its the only way to do it now
– DeerSpotter
Dec 21 '18 at 13:56

This doesn't appear to answer the question. The questioner knows how to freeze pains. The question asks about a shortcut that the questioner believes to have been removed.
– Blackwood
Dec 20 '18 at 23:04

its the only way to do it now
– DeerSpotter
Dec 21 '18 at 13:56

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Super User!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

Some of your past answers have not been well-received, and you're in danger of being blocked from answering.

Please pay close attention to the following guidance:

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1386452%2fexcel-freeze-panes%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Bdtyktl