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 1,651 other followers

Archive for the ‘MacBook Retina’ Category

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 CommandZ or ControlZ to undo the change

This probably is unintended, but works great: all text is now selected, so you can copy/cut with Command-C/CommandX.

Now the “official” way:

  1. Put the focus on the cell (click, use arrow keys, etc)
  2. Press ControlU or F2 to edit the cell (the cursor is now at the end)
  3. Press ShiftAltHome or ShiftControlHome (to select all text)
    note: Home can also be FnLeft.

Other selections you can make while the cell is in edit mode:

  • Press ShiftAltEnd or ShiftControlEnd (to select to the end of the cell)
    note: End can also be FnRight.
  • Press ShiftAltRight or ShiftControlRight (to select one word to the right)
  • Press ShiftAltLeft or ShiftControlLeft (to select one word to the left)
  • Press ShiftAltDown or ShiftControlDown (to select to the same position on the line below)
  • Press ShiftAltUp or ShiftControlUp (to select to the same position on the line up)

Keyboard symbols (more at [WayBackCommand, 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 »

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: [WayBackkeyboard – 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

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 »

Chris Bensen: macOS How to create an ISO from a CD or DVD

Posted by jpluimers on 2019/04/25

Yes, occasionally, people still use DVD or CD disks, so thanks [Archive.isChris Bensen: macOS How to create an ISO from a CD or DVD:

Put in your CD or DVD, Open Terminal, type:

ls /Volumes

Find the volume in the list, then type where /path/to/volume is the CD or DVD you want:

hdiutil makehybrid -iso -joliet -o Image.iso /path/to/volume

–jeroen

Posted in *nix, Apple, Mac, Mac OS X / OS X / MacOS, MacBook, MacBook Retina, MacBook-Pro, macOS 10.12 Sierra, Power User | Leave a Comment »

 
%d bloggers like this: