The MacMost Question and Answer Forum is a place where you can ask how-to questions about your Mac, iPhone, iPad and other Apple products. MacMost specializes in tutorials, tips and techniques of the “how-to” variety, as opposed to “fix-it” questions that are more about something not working as expected.2/9/23
I would like to use conditional highlighting to highlight cells that are equal to 0 but are not blank. It seems that Number assumes a blank cell that is formatted as a number is equal to 0. I know from your videos that you can use conditional formatting to make a cell that ... (2 Comments)
2/8/23
Is it possible to toggle the “Silence Unknown Callers” setting via a shortcut on y phone?
I figured it would be easy to have a macro for that when you need to turn that shutting on and off to accept the phone call from somebody you don’t know what the number ... (9 Comments)
2/6/23
Gary did a YouTube video a few years ago about ‘Saving and recalling window positions with Automator’. I use an app called ‘Ecamm Live’ which uses 8+ windows and users seem to have them scattered around their screens. I would like the equivalent of ... (1 Comment)
2/5/23
Hi Gary,
I have a daily routine where I open a couple of Web sites and a couple of Numbers spreadsheets… so I created a shortcut that do that and pinned it on the menu bar.
My shortcut looks like this :
– Open URL 1 in Safari
– Open Spreadsheet 1 in ... (6 Comments)
2/1/23
I have a worksheet of text in Numbers where some cells have a blank line between the text. How do I run a routine across the whole worksheet to remove all the blank lines as I can’t seem to make ‘Find/Replace’ achieve this. Thank you.
I am trying to make the ... (5 Comments)
1/31/23
While I am traveling, I would like to access my downloads, recents, and documents folder on my Mac Mini hard drive, and my desktop if that is possible. I am a bookkeeper and I have an external hard drive with sensitive data that I physically take with me. But I do have a lot of ... (7 Comments)
1/30/23
I use iCloud “FILES” folder on both MBP and iPhone.
In this Files folder I have a text.txt file that I can see on both MBP and iPhone
The problem is I can just READ it when I’m on my phone (I cannot WRITE or modify the txt.txt file)
If I make a modification ... (5 Comments)
1/28/23
I would like to archive/export/save one very long text message thread for safekeeping. It can be from my iphone or my mac – both have access to the same thread. Currently all of my messages are saved into iCloud but I do not trust that methodology long term.
I don’t ... (4 Comments)
1/26/23
I have a table with a master list of names. In another table there is a list of absentees. When someone in the master list notifies us they will be absent we put their name is in the absentee list. So, the absentee list is a subset of the master list. I want to highlight the ... (1 Comment)
1/26/23
When there is a blank space in a few different browsers in which an e-mail address is required, I get a pop-up to auto-fill with an email address that is not mine, instead of showing my email, it shows my wife’s email address. She does not have access to my computer, and ... (3 Comments)
1/26/23
I have a reminder set up for the 1st of every month to update my budget which is on Numbers. Does anyone know please how I can add a file link in the notes section so that I can open the file directly from within Reminders?
—–
John Becker
... (7 Comments)
1/26/23
Hi, I have the entire column B, of a document that has a combined phone number and name as such: 786-555-1212angiemore@fir.com I would like to be able to extract the Phone number to column C, and the portion of the email only to column D. All Phone numbers are 12 digits. Can ... (2 Comments)
1/25/23
Is there any way to open 2 Pages documents side by side on my iPad? Please note this question is about the Pages app, not about how to open two word document pages. I can find lots of similar questions online but they’ve all been answered as if the question is about two pages ... (2 Comments)
1/23/23
I have turned off iCloud Photos and now have 30 days to download these. However, I cannot find any way to download them to my iPad. It is more than 5000 images. There is no option to download when I go to my iCloud on my iPad. I took most of the photos with my iPhone. However ... (3 Comments)
1/13/23
Hi Gary,
Every time I create a new folder in the Finder and add files there, by default the contents are “unorganized” (when the view option is set to “as Icons”). I need to right-click and use either “Sort by” or “Clean up by” ... (2 Comments)
1/13/23
Hi Gary,
BACKGROUND:
Am working on a Numbers document where I have to combine ‘Text’ and ‘incremental Numbers’ for 1,000 entries.
EXPECTED OUTPUT:
Row 1, Column 1 – GNK (text)
Row 1, Column 2 – Science (text)
Row 1, Column 3 – ... (4 Comments)
1/11/23
I have a Lacie 4TB external spinning drive which is portable and does not require a separate power source. This is normally connected to my M1 Mac Mini via a USB 3 cable but I do have the option of using one of the Thunderbolt ports.
After buying this a few years ago I decided ... (6 Comments)
1/9/23
I have recently demoted an older iPad for use as a digital photo album. It’s running iPadOS 16.2, and I am using the mac Photos app for storing, cataloging and displaying the photos. I am using the iCloud photos function to keep the library up to date on all my devices, ... (2 Comments)
1/6/23
I want to be able to distinguish between different types of files.
—–
JC
... (4 Comments)
1/4/23
I assume that if I bought a display mount, I could use my iPhone 14 Pro via Continuity Camera. What is worrying me is the question of sound quality.
As the Mac Mini does not appear to have its own microphone, is the one in my iPhone any good for this kind of application or would ... (2 Comments)
