The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 2,731 other followers

View multiple panes, sheets, or workbooks – Excel for Mac

Posted by jpluimers on 2022/03/31

Usually, I work in a single worsheet and workbook at a time.

Sometimes I use multiple worksheets or workbooks, and I never knew about the below feature.

The really cool aspect which is not in the below documentation: if you re-open a worksheet, it remembers the views and positions!

Learned a new thing and discovered a new thing (:

[WayBack] View multiple panes, sheets, or workbooks – Excel for Mac:

In Excel for Mac, you can split a sheet in to panes, view multiple sheets in one workbook, or view multiple workbooks at a time.

View multiple sheets in one workbook

  1. Open the workbook that you want to view.
  2. On the Window menu, click New Window.
  3. Switch to the new window, and then click the tab for the sheet that you want to view.Repeat steps 2 and 3 for each sheet that you want to view.
  4. On the Window menu, click Arrange.
  5. Do one of the following:
    To arrange windows So that they appear like this Click
    As equally sized, tiled squares Tiled windows Tiled
    Horizontally from top to bottom Horizontal windows Horizontal
    Vertically from right to left Vertical windows Vertical
    In an overlapping cascade from top to bottom Cascading windows Cascade
  6. Select the Windows of active workbook check box.

View multiple workbooks

  1. Open all the workbooks that you want to view.
  2. On the Window menu, click Arrange.
  3. Do one of the following:
    To arrange windows So that they appear like this Click
    As equally sized, tiled squares Tiled windows Tiled
    Horizontally from top to bottom Horizontal windows Horizontal
    Vertically from right to left Vertical windows Vertical
    In an overlapping cascade from top to bottom Cascading windows Cascade

–jeroen

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

 
%d bloggers like this: