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

    20140508-Delphi-2007--Project-Options--Cannot-Edit-Application-Title-HelpFile-Icon-Theming20140430-Fiddler-Filter-Actions-Button-Run-Filterset-now20140424-VMware-Fusion-6.0.3.-no-reclaimable
    More Photos

  • Pages

  • All categories

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

    Join 1,617 other followers

Archive for the ‘Mac OS X / OS X / MacOS’ Category

« Previous Entries

ms office – Keyboard shortcut to select all text in a cell in Excel – Ask Different

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:

  1. Put the focus on the cell (click, use arrow keys, etc)
  2. Press space
  3. 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:

  1. Put the focus on the cell (click, use arrow keys, etc)
  2. Press Control–U or F2 to edit the cell (the cursor is now at the end)
  3. 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
  • ⌘ – Command
  • Fn – 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 »

Did Apple remove dashboard in MacOS Catalina? – Appleosophy

Posted by jpluimers on 2019/06/10

It was fun while it lasted: [WayBack] Did Apple remove dashboard in MacOS Catalina? – Appleosophy

I especially like the iStat Pro (though unsupported) widget, and that you can have a dashboard without the need to go on-line.

Related: [WayBack] Dashboard (macOS) – Wikipedia

Via: [WayBack] Apple verwijdert dashboard met widgets uit macOS Catalina – Computer – Nieuws – Tweakers

If might be that Übersicht can help me, but I am not sure yet if there is a good iStat Pro equivalent for it.

Future links to investigate:

–jeroen

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

macos – User account no longer in ‘admin’, how to recover? – Ask Different

Posted by jpluimers on 2019/06/07

For my link archive:

–jeroen

Posted in Apple, iMac, Mac, Mac OS X / OS X / MacOS, MacBook, MacBook Retina, MacBook-Air, MacBook-Pro, MacMini, macOS 10.12 Sierra, macOS 10.13 High Sierra, OS X 10.11 El Capitan, Power User | Leave a Comment »

keyboard – How to add a line break in a cell in Excel for Mac – Ask Different

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 »

osx lion – osx change printer ip address without adding new printer – Super User

Posted by jpluimers on 2019/04/29

From [WayBack] osx lion – osx change printer ip address without adding new printer – Super User:

Q

Is there a way to change a printer’s IP address in OSX (Lion) without having to add a new printer? I did find Printer IP Remedy, but was curious if there was an ‘official’ method.

A

You can do this in the CUPS web interface with the following steps:

  1. Open Terminal.app and run cupsctl WebInterface=yes. This enables the CUPS web interface
  2. Open http://127.0.0.1:631/printers in your web browser
  3. Click on the printer you want to change. From the “Administration” drop down, select “Modify Printer”.
  4. Log in with your local admin account
  5. Select the new printer IP either from “Discovered Network Printers” or add it manually with “Other Network Printers”. Make sure that you keep the same connection protocol as it says in “Current Connection” (for me, this was LPD).

Once you’re done with this, Mac OS X will directly print to the new IP address. There is no need to reboot or so. If you want to disable the CUPS web interface again, run cupsctl WebInterface=no.

The CUPS solution works splendid in MacOS as well, so there was no need for [Archive.is] Printer IP Remedy 1.3 free download for Mac | MacUpdate.

Without the CUPS web interface enabled, the web-interface at http://127.0.0.1:631/printers looks like this:

Web Interface is Disabled

The web interface is currently disabled. Run “cupsctl WebInterface=yes” to enable it.

After enabling it like the CUPS web interface wit cupsctl WebInterface=yes, you can see I have the same printer configured multiple times with different communication protocols and output languages:

Printers

Search in Printers:

Showing 6 of 6 printers.

Queue Name Description Location Make and Model Status
OKI_MC342_36855D OKI-MC342-PSO-36855D Office MC342-AirPrint Idle
OKI_MC342_36855D_PCL OKI-MC342-36855D PCL 1060NP-Office Generic PCL Laser Printer Idle
OKI_MC342_IPP OKI-MC342-IPP Office Generic PostScript Printer Idle
OKI_MC342_LPR OKI-MC342-LPR Office Generic PostScript Printer Idle
CUPS and the CUPS logo are trademarks of Apple Inc. Copyright © 2007-2015 Apple Inc. All rights reserved.

The first two printers were mapped by DNS, but the last two were mapped by IP address.

Changing the IP address was simple:

  1. Click on each link
  2. Select “Modify printer”
  3. Authenticate (only needed for the first printer change)
  4. For IPP: note the current address (like ipp://192.168.71.52/), then
    1. Choose “Internet Printing Protocol (ipp) “
    2. Click “Continue”
    3. Enter the correct ipp://…./ address (help is at http://127.0.0.1:631/help/network.html or http://127.0.0.1:631/help/network.html?PRINTABLE=YES)
    4. Click “Continue”
    5. Check the modifications (optionally change Description/Location)
    6. Click “Continue”
    7. Keep the driver
    8. Click “Modify printer”
  5. For LPD, note the current address (like lpd://192.168.71.52/), then follow the IPP steps, but choose “LPD/LPR Host or Printer” and enter a valid lpd address.

This is also the place where you can change “Default options”, like paper size (which – for all but the first – somehow defaulted to US Letter 11 inch, while it is actually filled with A4 paper).

At the end, disable the web interface: cupsctl WebInterface=no.

Related:

–jeroen

Read the rest of this entry »

Posted in *nix, *nix-tools, Apple, iMac, Mac, MacBook, MacBook Retina, MacBook-Air, MacBook-Pro, MacMini, macOS 10.12 Sierra, macOS 10.13 High Sierra, Power User | Leave a Comment »

« Previous Entries
 
%d bloggers like this: