Archive for the ‘Office’ Category
Posted by jpluimers on 2019/09/30
Since I always forget this: [WayBack] Exceljet: Get day name from date
If you need to get the day name (i.e. Monday, Tuesday, etc.) from a date, there are several options depending on your needs.
Basically there are four ways go get the day of the week; the first three are readable, but when ordered, they are ordered alphabetically. The last one is numeric.
Combining the numeric with the text is easier in for instance Pivot Legend Fields (Series).
So here they go (based on the above link), assuming that B4 contains a timestamp:
=WEEKDAY(B4) gives you the numeric weekday (starting with Sunday=1 to Saturday=7) which allows sorting in a meaningful order=TEXT(B4,"dddd") gives you the full day name of B4 in your locale=TEXT(B4,"ddd") gives you the shortened day name of B4 in your locale=CHOOSE(WEEKDAY(B4),"Sun","Mon","Tue","Wed","Thu","Fri","Sat") gives you a name of your liking from a series of 7 texts
Note that depending on your locale, these formulas might actually need a semicolon:
=WEEKDAY(B4)=TEXT(B4;"dddd")=TEXT(B4;"ddd")=CHOOSE(WEEKDAY(B4);"Sun";"Mon";"Tue";"Wed";"Thu";"Fri";"Sat")
–jeroen
Read the rest of this entry »
Posted in Excel, Office, Power User | Leave a Comment »
Posted by jpluimers on 2019/08/16
Since I always get confused by the differences in Excel versions (not just between Mac OS X and Windows):
In Excel for Mac, you can adjust where automatic page breaks occur, add your own page breaks manually, and remove manual page breaks.
Source: [WayBack] Insert, move, or delete page breaks in a sheet.
–jeroen
Read the rest of this entry »
Posted in Excel, Office, Office 2011 for Mac, Power User | Leave a Comment »
Posted by jpluimers on 2019/06/28
I hardly print with Excel, so I always forget these two:
–jeroen
Posted in Excel, Office, Office 2011 for Mac, Office 2013, Power User | Leave a Comment »
Posted by jpluimers on 2019/06/10
Via [WayBack] ms office – Keyboard shortcut to select all text in a cell in Excel – Ask Different a few keyboard tips.
Lets start with the shortest one:
- Put the focus on the cell (click, use arrow keys, etc)
- Press space
- Press
Command–Z or Control–Z to undo the change
This probably is unintended, but works great: all text is now selected, so you can copy/cut with Command-C/Command–X.
Now the “official” way:
- Put the focus on the cell (click, use arrow keys, etc)
- Press
Control–U or F2 to edit the cell (the cursor is now at the end)
- Press
Shift–Alt–Home or Shift–Control–Home (to select all text)
note: Home can also be Fn–Left.
Other selections you can make while the cell is in edit mode:
- Press
Shift–Alt–End or Shift–Control–End (to select to the end of the cell)
note: End can also be Fn–Right.
- Press
Shift–Alt–Right or Shift–Control–Right (to select one word to the right)
- Press
Shift–Alt–Left or Shift–Control–Left (to select one word to the left)
- Press
Shift–Alt–Down or Shift–Control–Down (to select to the same position on the line below)
- Press
Shift–Alt–Up or Shift–Control–Up (to select to the same position on the line up)
Keyboard symbols (more at [WayBack] Command, Option, & Shift Symbols in Unicode):
⇧ – Shift^ – Control⌥ – Alt which is the same as Option⌘ – CommandFn – Function
–jeroen
Posted in Apple, Excel, Mac, Mac OS X / OS X / MacOS, MacBook, MacBook Retina, MacBook-Air, MacBook-Pro, MacMini, macOS 10.12 Sierra, Office, Office 2011 for Mac, Power User | Leave a Comment »
Posted by jpluimers on 2019/06/03
What key combination do I have to press to create a line break in a cell in Excel for Mac 2011? The Windows combination of Alt+Enter does not work on the Mac.
Source: [WayBack] keyboard – How to add a line break in a cell in Excel for Mac – Ask Different
The answer depends on the Excel for Mac OS X version you are using.
Excel 2015 is simple (thanks esham): use Option+Enter.
In older Excel <= 2011 (thanks nwinkler), use Command+Option+Enter or Control+Option+Enter.
Some users report the also need the Fn key in addition to the above modifiers.
–jeroen
PS: Later I found out that [WayBack] Beckism.com: Use a linebreak in Excel on Mac also shows the Excel <= 2011 solution Control+Option+Return (note that Return is the same key as Enter).
Posted in Apple, Excel, Mac, Mac OS X / OS X / MacOS, MacBook, MacBook Retina, MacBook-Air, MacBook-Pro, macOS 10.12 Sierra, Office, Office 2011 for Mac, Power User | Leave a Comment »
Posted by jpluimers on 2019/04/15
Just when I thought I made a note of a password I hardly ever use, I didn’t, luckily this open source tools understands how to recover many kinds of passwords: AlessandroZ/LaZagne: Credentials recovery project.
–jeroen
Posted in *nix, *nix-tools, Chrome, Development, DVCS - Distributed Version Control, Firefox, git, Internet Explorer, Office, Opera, Outlook, Power User, Python, Scripting, Skype, Software Development, Source Code Management, Web Browsers, WiFi, Windows | Leave a Comment »
Posted by jpluimers on 2018/11/12
For a very long time, gMail did nothing with Outlook Calendar entires.
So I had to view at the message source, then translate them to Google Calendar entries myself.
--_000_430b30b9ffd74d959b74ab7ba778b487ultrawarenl_
Content-Type: text/calendar; charset="utf-8"; method=REQUEST
Content-Transfer-Encoding: base64
...
As of late, they seem to be processed into Google Calendar compatible entries. Nice!
–jeroen
Posted in base64, Development, Encoding, GMail, Google, GoogleCalendar, MIME, Office, Outlook, Power User, Software Development, UTF-8, UTF8 | Leave a Comment »
Posted by jpluimers on 2018/11/05
Both in %TEMP% and %Windir%\TEMP, a lot of log files named %COMPUTERNAME%-yyymmdd-hhnn.loghaving entries named Click-To-Run General Telemetry appear.
Anyone who knows how to disable this logging?
I think they are related to Office 2016 installed through Office 365.
Disabling the Click-To-Run Monitor scheduled task is not a good solution, as it will also Office disable update notification: [WayBack] MS Office 2016 – Click to run logs | MalwareTips Forums
–jeroen
Posted in Office, Office 2016, Power User, Windows | Leave a Comment »
Posted by jpluimers on 2018/10/29
For my link archive: [WayBack] Language Accessory Pack for Office – Office Support (short-link)
All supported languages for Office 2010, 2013 and 2066/newer versions.
–jeroen
Posted in Office, Office 2010, Office 2013, Office 2016, Power User, Windows | Leave a Comment »
Posted by jpluimers on 2018/09/17
Steps to try first:
- Check
%windir%\Windowsupdate.log (on my system, it did not reveal anything special)
- In an administrator command prompt, run
sfc /scannow (which takes a few minutes to run)
- Reboot
- Run Clean Manager
%windir%\System32\cleanmgr.exe (ensure to clean up update files: it can take tens of minutes to run)
- Reboot
- Download the SP1 files (I needed 32-bit x86)
- Install SP1 manually
- If it still hangs:
- In
Appwiz.cpl try a “Repair” of the Office 2013 installation
- If it works: Reboot, otherwise:
- Uninstall Office 2013
- Disable the network adapter
- Reboot
- Check if KB3173424 is installed (check it with
Appwiz.cpl)
- if not: download on a different machine, transfer over USB, install, then reboot
- Check ifKB3172614 is installed (which has a younger Windows Update Client)
- if not: downloadon a different machine, transfer over USB, install, then reboot
- Enable the network adapter
- Let Windows scan for updates and install them
- If you get an error 80070463 or 80070663: just reboot and retry the updates.
- Reboot
- Run Clean Manager
- Install Office 2013
- Reboot
- Let Windows scan for updates and install them
- Reboot
- Run Clean Manager
- Reboot
The KB3172614 should also alleviate long during (dozens of minutes) high CPU usage of svchost.exe and TiWorker.exe when searching for Windows updates.
Read the rest of this entry »
Posted in Office, Office 2013, Power User, Windows, Windows 8.1 | Leave a Comment »
The Wiert Corner - irregular stream of stuff 