MacMost: Question and Answer Forum

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.


Have a how-to question? Ask it here in the MacMost Forum.
Have a fix-it question? Here is where you can get some help.

2/21/13
I have a pricing spreadsheet that includes lots of different sizes of air conditioner systems. What I do is to enter a quantity, and that generates a price. At the bottom is a total of just the items I priced out. I want to find a way to copy only the lines with a quantity value ... (1 Comment)
2/18/13
I have been working for 12 hours trying to rank a column of numbers and listing that SPECIFIC ranking in a different column. Say I have column “E” with different rows listed as 2,6,8,10. In column “F” I want to assign/show the numerical ranking number of ... (1 Comment)
2/16/13
Does iWork have the same capabilities as Office 2011 for Mac when I need to create documents? I ask because I am thinking of ditching Office for Mac and purchasing the 3 iWork applications, but have been discouraged by Mac users across the board. They say it doesn’t have ... (8 Comments)
2/16/13
When I make multiple screenshots for a project such as a Keynote presentation they collect all over the desktop. I would like to save them to a file for four reasons. 1) they would be in date/time order. 2) when in ‘preview’ the picture size would be larger than it is ... (7 Comments)
2/13/13
Hello I am having trouble working out how to save a .pdf file to open as a double page spread in pages. I want the file to open this way by default instead of people having t o change their settings once open. Any help would be much appreciated! —– Dan ... (2 Comments)
2/12/13
when I type a fraction in mail or text edit such as 1/2″, it automatically converts it into a properly formatted fraction number. It’s a great feature, but in Pages it doesn’t do it. I don’t even know how it does it in mail or text edit. I never changed ... (2 Comments)
2/11/13
I prefer the old way of viewing albums, artists and genres in LIST format in iTunes. But, the latest iTunes seems to only show “Songs” in list format. Is there a way to do this? —– Arthur Carter ... (3 Comments)
2/11/13
I am trying to use numbers with checkboxes showing a percentage of how may checkboxes are marked.I have watched your tutorial on if statements and checkboxes but Im missing something. (besides not being confident with formulas). I am using the formula =IF(R5,1/26*100%,R5)in cell ... (2 Comments)
2/11/13
I got locked out of disk I encrypted via OS X cause I forgot the password. I don’t care about the contents, I simply want to use the disk again and I know there is a command line via terminal to do this but don’t know what it is. —– Bryan ... (8 Comments)
2/8/13
Just got myself a new Time Capsule which I am planning to set up as a WiFi router for my broadband connection. Given that it comes with a 2TB hard drive that works with Time Machine for backups I was trying to figure out a way of using that 2TB drive as a NAS. Is that possible ... (8 Comments)
2/6/13
I am using numbers 09. I have two columns with dates in them. They are named date issued and expected completion date. The first column on the left is date issued where I insert a date the next column I use the formula =EDATE(F5,3)this gives me a date in 3 months time,this work ... (3 Comments)
2/5/13
My iPad is holding the Christmas videos I took and I want to edit them on my iPad. Holding them there is preventing me from doing a Cloud backup because it exceeds the total of my storage. Why are videos backing up to the cloud and how can I prevent this from happening? Is my ... (8 Comments)
2/5/13
how do I connect with a video camera recently installed in my elderly mom’s home? The website is: [*] and the installer at my mom’s gave me a tutorial today over the phone, but said I had to activate X controls to get the video connected with my Mac. I am currently in ... (3 Comments)
2/5/13
Can you please tell me how to disable or turn off the autocomplete/autofill function in numbers? I am creating a spreadsheet with a column for First Name, Middle Initial, and this feature is driving me crazy. Thanks, in advance for your assistance. —– Joseph ... (9 Comments)
2/4/13
I want to be able to let Pages for example keep running while I go to desktop for something else. My Mac OS X Keyboard Shortcuts says F11 but that key just increases the volume on my MacBook Pro OS X 10.8.2 MacBook Pro 13 inch Early 2011 Thank you for any ... (4 Comments)
2/1/13
Its easy to do this from my iMac to someone using an iPhone but what about people that don’t have an iPhone? Is there a way to send them a SMS/text message from my iMac using OS X Messages? Thanks in advance for your help! Kendall —– Kendall ... (8 Comments)
2/1/13
I regularly hear about the imminent technological merger of a person’s computer and television. Is it too soon to cancel my cable-tv subscription and subscribe to the few cable-tv programs I like (only two of them) via the Internet and watch these tv programs on my iMac ... (5 Comments)
1/31/13
I hope to switch to Mac mid year, I think I will need access to some Windows programs and am thinking of parallels as well Considering the iMac would now have “Windows”, would I now be exposed to virus? Regards, Gary W —– Gary ... (6 Comments)
1/31/13
Since the upgrade to Mountain Lion, there is an autocomplete function for the location when creating iCal events. If the word “at” appears in the event description, iCal automatically takes the text following that word and plugs it in to the location field. Also, for ... (1 Comment)
1/26/13
I recently purchased an MacAir a little apprehensive that it does not have a cd drive. I love making pic DVDs and messing with music. Thinking maybe I should go back and get the pro. I surf the Internet edit pictures and mess with music. Sometimes I have to write a paper for a ... (7 Comments)