bjbk
  • Member for 6 years, 10 months
  • Last seen this week
  • United States
Can I force AirDrop to work on High Sierra without WiFi hardware?
2 votes

EDIT: Below was in answer to the original High Sierra question, but it appears that the original question has changed when the hardware issue came to light. I am leaving the answer below posted in ...

View answer
Text in cell with URL hidden
2 votes

Use the HYPERLINK() function. HYPERLINK(url,link-text) The first parameter is the URL as a string in quotes, the second is the tracking number as a string also in quotes. From the documentation: ...

View answer
How to stop Connection Line from snapping to object in Keynote
2 votes

As noted in the comments, to control the endpoints in the connecting line hold down the ⌘ while dragging the endpoint to the desired position on the object.

View answer
iPhone 4 iOS 7 with no iCloud backup. Is there way to access data?
2 votes

Without any kind of backup there is no way to get the data unless you find the iPhone. If you remember your Apple ID and password, you can login to appleid.apple.com and set the device as lost. ...

View answer
General Autocompletion
Accepted answer
2 votes

Basic autocompletion is built into macOS. For example, you can type bjbk@ to get bjbk@example.com or similar. Go to System Preferences... (From  Menu or your Dock or Spotlight) Go to Keyboard ...

View answer
On iOS11, can I highlight PDFs and make notes with my finger?
Accepted answer
2 votes

Yes. iOS 11 allows markup with finger of PDF’s opened in the Files App or previewed. Works on iPad and iPhone. No need for a pencil unless one needs finer control of drawing. The example below is a ...

View answer
Can you disable HOTSPOT on Mac OSX
2 votes

As long as the students don't have admin rights on the Macs: Try this... Go to System Preferences Network Advanced.. button Select the WiFi tab Require administrator authorization to: [✓] Change ...

View answer
How do I disable the Apple ID sign in when logging into my Mac?
2 votes

You could try this to disassociate your Apple ID password from login: To Stop Using an iCloud Password to Login to a Mac: Go to the  Menu and choose System Preferences (alternatively use LaunchPad ...

View answer
How can I display iPad content fullscreen with HDMI on a TV?
Accepted answer
2 votes

There are apps that detect if your iPad is mirrored to an external device via HDMI and adjust to fit accordingly. For example, the official Netflix app outputs the original aspect ratio to the ...

View answer
How can I abort a calculation that is hanging in Numbers for Mac?
2 votes

If you have a Time Machine backup, you can get the file from an earlier state. From Apple Support: Restore from a Time Machine backup Restore specific files: Choose Enter Time Machine from the ...

View answer
Numbers for OS X Yosemite 10.10.5
2 votes

Searching Apple Support for iWork for OS X 10.10 turned up a download link for iWork 9.3 however, from what I can tell, it may just be an update installer. But searching Apple Support is a good place ...

View answer
macOS numbers formula range problem
2 votes

As of version version 4.1.1 (4338), unfortunately with Numbers one can define the entire row, but not from a specific column forward. So, while COUNTIF(I3:3, 0) will resolve to an error, COUNTIF(3:3, ...

View answer
How to partially uncover bullet points in Keynote
2 votes

Another solution that does not require using masks: Create the bullet list Before applying the transitions, duplicate the text box containing your list. [Select the text box and then ⌘+D] Change the ...

View answer
Free viewer for Excel files other than OpenOffice
2 votes

Quick Look can be set to allow copying of text. Launch Terminal and type the following command: defaults write com.apple.finder QLEnableTextSelection -bool true Then restart the Finder with the ...

View answer
Can I create a formula to provide a value depending on when a timestamp falls in the day?
Accepted answer
2 votes

Assuming you have a normal Numbers Date/Time 2/11/2016 12:00:00 AM, then a simple IF() statement can be used combined with the HOUR function. =IF( HOUR ( A2 ) < 12, "Good Morning", "Good Afternoon"...

View answer
How to arrange two windows easily to left and right side?
2 votes

I just discovered Magnet available on the App store for $1.99 (current price as of posting) that provides the ability to "snap" windows to corners, right, left, etc. So far, it works as advertised. I ...

View answer
how can I search for folders ending in certain characters in Finder?
Accepted answer
2 votes

In Finder try using this: Kind is Folder Name ends with son This should display all folders ending with "son". Try also, begins with and contains for similar searches.

View answer
Is there a formula or function for Numbers that returns the number of days or weeks for a given year
2 votes

Try using the DATEDIF(start-date,end-date,calc-method) divided by 7 to determine number of weeks. For example: DATEDIF returns the number of days between to dates. Dividing that by 7 should result ...

View answer
revoke ipad access to my wireless network
2 votes

The simplest solution would be to change the network password. This can be done from the Airport Utility application found in your Applications > Utilities folder. This will disconnect all devices, ...

View answer
How to convert WMV to QuickTime MOV?
Accepted answer
2 votes

As for recommended way that is subject to opinion. As for doing it with installed applications, this is one way to do it. This requires 2 applications. If you really need a MOV file this is how I ...

View answer
How to create Table of Contents in Keynote?
2 votes

Assuming one is using Keynote 6 (OP did not state version used.), one way to create a Table of Contents or Handout is to use the Print dialog. This can be printed to PDF for handouts. One way to ...

View answer
Display blank on formula error
2 votes

Use the IFERROR() function. IFERROR(SUM(A2-A1),"") If the cell calculation is valid, the calculation is displayed. If there is an error in the cell, then this just returns "". (blank)

View answer
How do I stop my iMessages appearing on my MacBook Air?
2 votes

The best practice would be to have other users set up with their own logins on your Mac or to use the Guest account. They would never see your messages in that case. But, if you really wish to ...

View answer
Open last used folder in finder
2 votes

Additionally, if one wants to map a specific folder to a Keyboard Shortcut, this can also be done. From System Preferences Select Keyboard Select the Shortcuts tab In the Left Pane select App ...

View answer
Keynote no longer goes into Presenter Notes mode automatically
Accepted answer
2 votes

In Keynote version 6.6: Keynote > Preferences... ⌘+, Slideshow tab Tick the Enable Presenter Display check box Then go to Play > Customize Presenter Display... to be sure the output is as you expect....

View answer
How to type a capital letter from the extended Latin alphabet in OS X
2 votes

Hold the shift key then the number corresponding. It works just fine. I think you are forgetting to let go of the shift before hitting the number. Hence the unexpected output. Hold shift+U then, ...

View answer
Shortcut - El Capitan Dialog Box switch between option
Accepted answer
2 votes

Go to System Preferences then select Keyboard. In the Shortcuts tab you will find an option for "Full Keyboard Access". Set the radio button for All Controls. When confronted with a dialog box with ...

View answer
I how to do I keep my Apple Watch's screen on longer?
2 votes

Watch OS 2.x allows two options. (Perhaps in future this can be a single dynamic option with a min-max setting.) Go to Watch App on iPhone Tap General Tap Wake Screen Select the ON TAP Wake setting ...

View answer
Numbers: how do I create a column with a sequence of times?
Accepted answer
2 votes

In addition to njboot's answer, If you wish to drag and apply the ½ hour increments without entering a formula, be sure to select Both cells before dragging down the yellow dot. This will copy the ...

View answer
"Breaking News" feature for OS X Yosemite
2 votes

In answer to your questions: How did I turn this on? You may have hit the return key when seeing this dialog at your first visit to The New York Times: How do I turn this off? Follow RedEagle2000's ...

View answer
1 2 3
4
5
10