The Wiert Corner – irregular stream of stuff

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

  • My badges

    Mastodon

  • Twitter Updates

  • Pages

  • All categories

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

    Join 1,839 other subscribers

Archive for the ‘Office 2021’ Category

Updating Microsoft Office on Windows from a batch file

Posted by jpluimers on 2026/04/21

This batch file works for modern Click-to-Run (sometimes called ClickToRun, Click2Run or C2R) based Office installations (note the odd lowercase microsoft shared which indeed is the actual directory name):

if exist "%CommonProgramFiles%\microsoft shared\ClickToRun\OfficeC2RClient.exe" (
  "%CommonProgramFiles%\microsoft shared\ClickToRun\OfficeC2RClient.exe" /update user
) else (
  echo could not find the Office Updater
)

This for sure does not work for MSI based Office 2013 and lower (which are updated through Windows Update anyway). Since I only have 2021 online (Click-to-Run) installs and higher to test with: those work fine.

Read the rest of this entry »

Posted in Batch-Files, Development, Office, Office 2021, Office Development, Power User, Scripting, Software Development, Windows, Windows Development | Leave a Comment »

keyboard – Shortcut to apply header style 4 (and 5, 6…) – Ask Different

Posted by jpluimers on 2026/04/03

[Wayback/Archive] keyboard – Shortcut to apply header style 4 (and 5, 6…) – Ask Different (thanks [Wayback/Archive] bouke!):

Found it, although I did not expect the solution to be this simple. To do this, follow these steps:
  1. Right-click the Heading 4 style in the ribbon and choose ‘Modify’ (Or through Layout > Styles > Heading 4 > Modify
  2. In the left hand bottom corner, select ‘Shortcut’
  3. Assign shortcut ⌘⌥4
  4. Repeat for Heading 5, 6…
  5. Done!

Query: [Wayback/Archive] macos microsoft word shortcut for heading levels – Google Suche

More: [Wayback/Archive] Keyboard shortcuts in Word – Microsoft Support: MacOS

--jeroen

Posted in Apple, Mac OS X / OS X / MacOS, Office, Office 2021, Power User | Leave a Comment »

It might be time for me to upgrade to a newer Excel version because of some new notation and functions like TAKE and TRIMRANGE, or does it?

Posted by jpluimers on 2026/03/23

Over the last decades, I hardly needed to upgrade Excel. For a very long time I stayed at Excel 2003, as the ribbon interface introduced with Office 2007 (version 12) was horrible (it still is, especially since 19:10 monitors are gone and the ribbon takes too much vertical screen estate).

After that, I needed newer features so I upgraded to Excel 2013 (version 15) mainly because it ditched Multiple-document interface (MDI) and I like SDI over MDI a lot, and Office 2013 was largely compatible with Office for Mac 2011 (version 14).

Mostly recovered from my cancer treatments, I noticed that MacOS ditched 32-bit support in MacOS 11 Big Sur, which meant I could not use Office 2011 any more (it was 32-bit x86 only) so in 2022 I upgraded all my office installations to Office 2021 (up in the version 16.* range as starting with Office 2016 the major version number stayed 16.minor).

I might actually upgrade to Office 2024 (version 16.many) soon despite the major version 16, finally Excel has started sped up new development of new functions and features, of which the ones below are very interesting: they will make my largest spreadsheets a lot simpler and therefore easier to maintain:

Read the rest of this entry »

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