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,806 other followers

Archive for the ‘Office 2011 for Mac’ Category

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

Posted in Excel, Office, Office 2011 for Mac, Power User | Leave a Comment »

Learned that figuring out Excel formula dependencies has been there since at least Excel 2000 (:

Posted by jpluimers on 2022/03/01

Sometimes, you figure out Excel functionality you have never needed before, but has been there for decades.

A while ago, I had a very complex with formulas referencing full columns back and forth when suddenly I got into something strange: when reloading the spreadsheet, values would not appear because of recursion errors. Before saving this was fine, so it was hard to track back where I want wrong.

So I was happy to find out that Excel has two cool features for this:

  • Trace Precedents
  • Trace Dependents

Heck, looking at the icons I had a feel these features had been there for a long time. Boy, was I surprised to find them in [Wayback] Excel 2000 – Student Edition – Complete (a great book by the way), as you can see in this picture:

Excel 2000 - Student Edition - Complete - Trace precedents, dependents, error

Excel 2000 – Student Edition – Complete – Trace precedents, dependents, error

As others can explain this feature so much better than I can, here are some links:

–jeroen

 

Posted in Excel, Office, Office 2000, Office 2003, Office 2007, Office 2010, Office 2011 for Mac, Office 2013, Office 2016, Power User | Leave a Comment »

Word for Mac 2011: create macro or shortcut to ‘Insert Picture – Microsoft Community

Posted by jpluimers on 2021/11/02

As it combines VBA and AppleScript, I might need the script from this in the future [WayBack] Word for Mac 2011: create macro or shortcut to ‘Insert Picture – Microsoft Community.

–jeroen

Posted in Development, Office, Office 2011 for Mac, Office Automation, Office VBA, Scripting, Software Development | Leave a Comment »

Word: have part of Heading 1/2/3 not show up in the table of contents

Posted by jpluimers on 2021/10/01

Every now and then, for instance with a document including other documents, like in a homework assignment, you might want to exclude part of your Heading 1 (or Heading 2/Heading 3) entries from the table of contents.

Since presence in the Table of Contents is a ToC feature, not a style feature, you have to set the correct options in the ToC.

This is how you do it:

  1. Create new styles for the headings you do not want in the ToC (I call them “Heading 1, no ToC”; “Heading 2, no ToC”; etcetera) and base each on the corresponding style “Heading 1” or “Heading 2”

  2. Modify your Table of Contents to exclude these new styles (as they are automatically included)

This is contrary to many advices to use the “Reference” toolbar, then “Add Text” marked “Do Not Show In Table Of Contents”. That advice will remove the heading formatting completely and remove it from the navigation pane, so do not follow [WayBack] Quick Tip: How to exclude headings from the Table of Contents in Microsoft Word – jeffreykusters.nl.

The above solution both keeps the formatting, and the appearance in the navigation pane. It only disappears from the Table of Contents.

It is based on:

Following the above steps, you get styles like this:

Read the rest of this entry »

Posted in Office, Office 2010, Office 2011 for Mac, Office 2013, Office 2016, Power User, Word | Leave a Comment »

macOS and Windows Excel Shortcut: Toggle absolute and relative references | Exceljet

Posted by jpluimers on 2020/04/20

Since I tend to forget the Mac shortcut (the Windows one feels like it is in my autonomic nervous system):

  • F4    Windows shortcut
  • ⌘T   Mac shortcut 
While editing a formula, this shortcut toggles cell references from relative to absolute, to partially absolute, back to relative again: A1 –> $A$1 –> A$1— > $A1 — > A1 It’s much faster and easier than typing $ characters manually.
To convert an existing formula, enter cell edit mode, place the cursor in or next to the reference you’d like to convert, then use the shortcut.
Note: in Excel 2016 for the Mac, you can also use fn + F4. 

Source: Excel Shortcut: Toggle absolute and relative references | Exceljet

–jeroen

Posted in Excel, Office, Office 2011 for Mac, Power User | Leave a Comment »

 
%d bloggers like this: