Single-Window Mode for multiple worksheets
Is it possible in Microsoft Excel 2013+ (the plus currently means 2016 too) to open multiple sheets in the very same work space? Basically View=>Split but for different worksheets.
The reason I ask is because when I put multiple sheets besides each other I can't use alt+tab to see both windows. I have to re-arrange them every time I go to a non Excel window and then go back.
microsoft-excel microsoft-excel-2013 single-instance
asked Feb 26 '16 at 17:19
LWCLWC
146115
add a comment |
Is it possible in Microsoft Excel 2013+ (the plus currently means 2016 too) to open multiple sheets in the very same work space? Basically View=>Split but for different worksheets.
The reason I ask is because when I put multiple sheets besides each other I can't use alt+tab to see both windows. I have to re-arrange them every time I go to a non Excel window and then go back.
microsoft-excel microsoft-excel-2013 single-instance
asked Feb 26 '16 at 17:19
LWCLWC
146115
Yes, they each have a set of icons on the top right, below the application's. Just use those to resize them each in the workspace.
– Raystafarian
Feb 26 '16 at 17:28
add a comment |
Is it possible in Microsoft Excel 2013+ (the plus currently means 2016 too) to open multiple sheets in the very same work space? Basically View=>Split but for different worksheets.
The reason I ask is because when I put multiple sheets besides each other I can't use alt+tab to see both windows. I have to re-arrange them every time I go to a non Excel window and then go back.
microsoft-excel microsoft-excel-2013 single-instance
asked Feb 26 '16 at 17:19
LWCLWC
146115
Is it possible in Microsoft Excel 2013+ (the plus currently means 2016 too) to open multiple sheets in the very same work space? Basically View=>Split but for different worksheets.
The reason I ask is because when I put multiple sheets besides each other I can't use alt+tab to see both windows. I have to re-arrange them every time I go to a non Excel window and then go back.
microsoft-excel microsoft-excel-2013 single-instance
microsoft-excel microsoft-excel-2013 single-instance
asked Feb 26 '16 at 17:19
LWCLWC
146115
asked Feb 26 '16 at 17:19
LWCLWC
146115
edited Feb 26 '16 at 20:53
LWC
asked Feb 26 '16 at 17:19
LWCLWC
146115
asked Feb 26 '16 at 17:19
LWCLWC
146115
asked Feb 26 '16 at 17:19
LWCLWC
146115
146115
Yes, they each have a set of icons on the top right, below the application's. Just use those to resize them each in the workspace.
– Raystafarian
Feb 26 '16 at 17:28
add a comment |
Yes, they each have a set of icons on the top right, below the application's. Just use those to resize them each in the workspace.
– Raystafarian
Feb 26 '16 at 17:28
Yes, they each have a set of icons on the top right, below the application's. Just use those to resize them each in the workspace.
– Raystafarian
Feb 26 '16 at 17:28
Yes, they each have a set of icons on the top right, below the application's. Just use those to resize them each in the workspace.
– Raystafarian
Feb 26 '16 at 17:28
add a comment |
1 Answer
1
active
oldest
votes
Is it possible open multiple worksheets in the same workspace?
You can view multiple worksheets using the instructions below.
View two or more worksheets at the same time
View two worksheets in the same workbook side by side
On the View tab, in the Window group, click New Window.
On the View tab, in the Window group, click View Side by Side
.
In the workbook window, click the worksheets that you want to compare.
To scroll both worksheets at the same time, click Synchronous Scrolling
in the Window group on the View tab.
Note: This option is available only when View Side by Side is turned
on.
Tips
If you resize the workbook windows for optimal viewing, you can click Reset Window Position Button image to return to the original
settings.
To restore a workbook window to full size, click Maximize
at the upper-right corner of the workbook window.
View multiple worksheets at the same time
Open the workbook or workbooks that contain the worksheets that you want to view at the same time.
Do one of the following:
If the worksheets that you want to view are in the same workbook, do
the following:
Click a worksheet that you want to view.
On the View tab, in the Window group, click New Window.
Repeat steps 1 and 2 for each sheet that you want to view.
If the worksheets that you want to view are in different workbooks,
continue with step 3.
On the View tab, in the Window group, click Arrange All.
Under Arrange, click the option that you want.
To view sheets only in the active workbook, select the Windows of active workbook check box.
Tip
- To restore a workbook window to full size, click Maximize
at the upper-right corner of the workbook window.
Source View two or more worksheets at the same time
answered Feb 26 '16 at 23:26
DavidPostill♦DavidPostill
105k25227262
Yes, but like I wrote "when I put multiple sheets besides each other I can't use alt+tab to see both windows. I have to re-arrange them every time I go to a non Excel window and then go back."
– LWC
Feb 27 '16 at 8:07
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
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1045881%2fsingle-window-mode-for-multiple-worksheets%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Is it possible open multiple worksheets in the same workspace?
You can view multiple worksheets using the instructions below.
View two or more worksheets at the same time
View two worksheets in the same workbook side by side
On the View tab, in the Window group, click New Window.
On the View tab, in the Window group, click View Side by Side
In the workbook window, click the worksheets that you want to compare.
To scroll both worksheets at the same time, click Synchronous Scrolling
Note: This option is available only when View Side by Side is turned
on.
Tips
If you resize the workbook windows for optimal viewing, you can click Reset Window Position Button image to return to the original
settings.
To restore a workbook window to full size, click Maximize
View multiple worksheets at the same time
Open the workbook or workbooks that contain the worksheets that you want to view at the same time.
Do one of the following:
If the worksheets that you want to view are in the same workbook, do
the following:
Click a worksheet that you want to view.
On the View tab, in the Window group, click New Window.
Repeat steps 1 and 2 for each sheet that you want to view.
If the worksheets that you want to view are in different workbooks,
continue with step 3.
On the View tab, in the Window group, click Arrange All.
Under Arrange, click the option that you want.
To view sheets only in the active workbook, select the Windows of active workbook check box.
Tip
- To restore a workbook window to full size, click Maximize
Source View two or more worksheets at the same time
answered Feb 26 '16 at 23:26
DavidPostill♦DavidPostill
105k25227262
Yes, but like I wrote "when I put multiple sheets besides each other I can't use alt+tab to see both windows. I have to re-arrange them every time I go to a non Excel window and then go back."
– LWC
Feb 27 '16 at 8:07
add a comment |
Is it possible open multiple worksheets in the same workspace?
You can view multiple worksheets using the instructions below.
View two or more worksheets at the same time
View two worksheets in the same workbook side by side
On the View tab, in the Window group, click New Window.
On the View tab, in the Window group, click View Side by Side
In the workbook window, click the worksheets that you want to compare.
To scroll both worksheets at the same time, click Synchronous Scrolling
Note: This option is available only when View Side by Side is turned
on.
Tips
If you resize the workbook windows for optimal viewing, you can click Reset Window Position Button image to return to the original
settings.
To restore a workbook window to full size, click Maximize
View multiple worksheets at the same time
Open the workbook or workbooks that contain the worksheets that you want to view at the same time.
Do one of the following:
If the worksheets that you want to view are in the same workbook, do
the following:
Click a worksheet that you want to view.
On the View tab, in the Window group, click New Window.
Repeat steps 1 and 2 for each sheet that you want to view.
If the worksheets that you want to view are in different workbooks,
continue with step 3.
On the View tab, in the Window group, click Arrange All.
Under Arrange, click the option that you want.
To view sheets only in the active workbook, select the Windows of active workbook check box.
Tip
- To restore a workbook window to full size, click Maximize
Source View two or more worksheets at the same time
answered Feb 26 '16 at 23:26
DavidPostill♦DavidPostill
105k25227262
Yes, but like I wrote "when I put multiple sheets besides each other I can't use alt+tab to see both windows. I have to re-arrange them every time I go to a non Excel window and then go back."
– LWC
Feb 27 '16 at 8:07
add a comment |
Is it possible open multiple worksheets in the same workspace?
You can view multiple worksheets using the instructions below.
View two or more worksheets at the same time
View two worksheets in the same workbook side by side
On the View tab, in the Window group, click New Window.
On the View tab, in the Window group, click View Side by Side
In the workbook window, click the worksheets that you want to compare.
To scroll both worksheets at the same time, click Synchronous Scrolling
Note: This option is available only when View Side by Side is turned
on.
Tips
If you resize the workbook windows for optimal viewing, you can click Reset Window Position Button image to return to the original
settings.
To restore a workbook window to full size, click Maximize
View multiple worksheets at the same time
Open the workbook or workbooks that contain the worksheets that you want to view at the same time.
Do one of the following:
If the worksheets that you want to view are in the same workbook, do
the following:
Click a worksheet that you want to view.
On the View tab, in the Window group, click New Window.
Repeat steps 1 and 2 for each sheet that you want to view.
If the worksheets that you want to view are in different workbooks,
continue with step 3.
On the View tab, in the Window group, click Arrange All.
Under Arrange, click the option that you want.
To view sheets only in the active workbook, select the Windows of active workbook check box.
Tip
- To restore a workbook window to full size, click Maximize
Source View two or more worksheets at the same time
answered Feb 26 '16 at 23:26
DavidPostill♦DavidPostill
105k25227262
Is it possible open multiple worksheets in the same workspace?
You can view multiple worksheets using the instructions below.
View two or more worksheets at the same time
View two worksheets in the same workbook side by side
On the View tab, in the Window group, click New Window.
On the View tab, in the Window group, click View Side by Side
In the workbook window, click the worksheets that you want to compare.
To scroll both worksheets at the same time, click Synchronous Scrolling
Note: This option is available only when View Side by Side is turned
on.
Tips
If you resize the workbook windows for optimal viewing, you can click Reset Window Position Button image to return to the original
settings.
To restore a workbook window to full size, click Maximize
View multiple worksheets at the same time
Open the workbook or workbooks that contain the worksheets that you want to view at the same time.
Do one of the following:
If the worksheets that you want to view are in the same workbook, do
the following:
Click a worksheet that you want to view.
On the View tab, in the Window group, click New Window.
Repeat steps 1 and 2 for each sheet that you want to view.
If the worksheets that you want to view are in different workbooks,
continue with step 3.
On the View tab, in the Window group, click Arrange All.
Under Arrange, click the option that you want.
To view sheets only in the active workbook, select the Windows of active workbook check box.
Tip
- To restore a workbook window to full size, click Maximize
Source View two or more worksheets at the same time
answered Feb 26 '16 at 23:26
DavidPostill♦DavidPostill
105k25227262
answered Feb 26 '16 at 23:26
DavidPostill♦DavidPostill
105k25227262
answered Feb 26 '16 at 23:26
DavidPostill♦DavidPostill
105k25227262
answered Feb 26 '16 at 23:26
DavidPostill♦DavidPostill
105k25227262
105k25227262
Yes, but like I wrote "when I put multiple sheets besides each other I can't use alt+tab to see both windows. I have to re-arrange them every time I go to a non Excel window and then go back."
– LWC
Feb 27 '16 at 8:07
add a comment |
Yes, but like I wrote "when I put multiple sheets besides each other I can't use alt+tab to see both windows. I have to re-arrange them every time I go to a non Excel window and then go back."
– LWC
Feb 27 '16 at 8:07
Yes, but like I wrote "when I put multiple sheets besides each other I can't use alt+tab to see both windows. I have to re-arrange them every time I go to a non Excel window and then go back."
– LWC
Feb 27 '16 at 8:07
Yes, but like I wrote "when I put multiple sheets besides each other I can't use alt+tab to see both windows. I have to re-arrange them every time I go to a non Excel window and then go back."
– LWC
Feb 27 '16 at 8:07
add a comment |
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1045881%2fsingle-window-mode-for-multiple-worksheets%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Yes, they each have a set of icons on the top right, below the application's. Just use those to resize them each in the workspace.
– Raystafarian
Feb 26 '16 at 17:28