Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

thom612

macrumors newbie
Original poster
I'm all but decided on a Macbook Pro 15 but when I went to the Apple Store to pull the trigger they were too busy and didn't have anybody to help me. While I waited I was playing around with a demo unit and realized that there are two things that really seem to bother me:

1. There is no page-up or page down keys. Is there any way to emulate these?

2. In Excel I can't use the function keys like I do in the PC. (For example, pressing F2 to edit a cell or F4 to switch between relative and absolute references). Is there any way to make Excel operate on the Mac the same way as it does on a PC?

I'm willing to change but some old habits die really hard. In the case of Excel I'm never going to be able to stop using the PC version in the immediate future.

I can't seem to find suitable answers to these questions anywhere, but if this isn't the right forum to ask this question, I'd appreciate a polite nudge in the right direction.

Thanks.
 
1. fn + arrow up/down

2. System Preferences > Keyboard > Check "Use all F1, F2, etc. keys as standard function keys"

Are you using Office for Mac or running Windows in Boot Camp/Parallels? Office for Mac may have different KB shortcuts.
 
Well, my plan was to install MS Office for Mac, but if I couldn't use the same keyboard shortcuts that would be a definite no-go. If I used Parallels would I be able to run the PC version of Excel directly on the Mac desktop? Is there a noticeable performance hit? Does this cost extra?
 
1. There is no page-up or page down keys. Is there any way to emulate these?
fn+up arrow = page up
fn+down arrow = page down
2. In Excel I can't use the function keys like I do in the PC. (For example, pressing F2 to edit a cell or F4 to switch between relative and absolute references). Is there any way to make Excel operate on the Mac the same way as it does on a PC?
Not all keyboard shortcuts will be the same. You can add custom shortcuts, if you wish, for most commands.

Mac OS X keyboard shortcuts from Helpful Information for Any Mac User
Well, my plan was to install MS Office for Mac, but if I couldn't use the same keyboard shortcuts that would be a definite no-go.
I wouldn't let a few differences in keyboard shortcuts prevent me from using the software I need, but that's just me. It's not that tough to learn a few new things.
If I used Parallels would I be able to run the PC version of Excel directly on the Mac desktop?
Yes.
Is there a noticeable performance hit?
Yes.
Does this cost extra?
Yes. http://www.parallels.com/
 
Well, my plan was to install MS Office for Mac, but if I couldn't use the same keyboard shortcuts that would be a definite no-go. If I used Parallels would I be able to run the PC version of Excel directly on the Mac desktop? Is there a noticeable performance hit? Does this cost extra?

Yes, you would be able to use the windows version of office on the mac, but you would need to buy parallels, windows, and office.
 
Would the 4GB that ships with the base model be enough?

It should work but I have 4GB in my iMac and running a VM is not that smooth (though I have crapload of other stuff open too). You can try 4GB first and upgrade to 8GB if needed.
 
Well, I just returned from the Apple store where the salesman assured me, with utmost confidence, that this absolutely would not work. Personally, I think he was kind of an idiot, but I still ended up leaving computerless.

I'm actually a little bewildered. The guy told me I should just learn how to use Excel for Mac and learn new shortcuts. I came in ready to drop two grand on a computer and in the face of pure incompetence I just couldn't justify it.
 
Well, I just returned from the Apple store where the salesman assured me, with utmost confidence, that this absolutely would not work..
That what would not work?
Personally, I think he was kind of an idiot, but I still ended up leaving computerless.
Remember that "Genius" is their job title, not an indication of their education, knowledge or experience.
The guy told me I should just learn how to use Excel for Mac and learn new shortcuts.
You can use Excel for Windows via Parallels, VMware Fusion or Boot Camp. You can also use Excel for Mac and customize keyboard shortcuts or learn the Mac shortcuts. What more do you need?
 
You can use Excel for Windows via Parallels, VMware Fusion or Boot Camp. You can also use Excel for Mac and customize keyboard shortcuts or learn the Mac shortcuts. What more do you need?

I wanted to see it for myself. I pointed out what you're saying here about Parallels but he told me that it wouldn't work. He said there was absolutely no way to run Macintosh for PC on Mac hardware. I couldn't justify dealing with that crap and then giving him my money.

What I was looking for was to have my decision to buy a mac affirmed, but they couldn't do that for me!
 
I pointed out what you're saying here about Parallels but he told me that it wouldn't work.
He's simply wrong. Period. Talk to someone else in the store and they will confirm that he doesn't know what he's talking about.
He said there was absolutely no way to run Macintosh for PC on Mac hardware.
Wait! "to run Macintosh for PC on Mac hardware."??? What does that even mean? You run Excel for Windows on Mac hardware, using Parallels, but not "Macintosh for PC". That doesn't even make sense. There is no such thing as "Macintosh for PC". You need to talk to someone in the store who is sober, or forget the store and know that what I'm telling you is true. Many others in the forum will concur. You can search the forum for threads and posts by those who are already running MS Office for Windows on their Macs, using one of the methods I described.

Don't take my word for it. Read what Apple says here: http://www.apple.com/macosx/compatibility/

It runs Windows, too.
Have a Windows application you need to use once in a while? No problem. Every new Mac lets you install and run Windows at native speeds, using a built-in utility called Boot Camp.

Setup is simple and safe for your Mac files. After you’ve completed the installation, you can boot up your Mac using either Mac OS X or Windows. (That’s why it’s called Boot Camp.) Or if you want to run Windows and Mac applications at the same time — without rebooting — you can install Windows using VMware or Parallels software.
Print out that web page and take it to the idiot at the Apple store and see what he has to say for himself.
 
He's simply wrong. Period. Talk to someone else in the store and they will confirm that he doesn't know what he's talking about.

That was the problem. I'm trying to rationalize a decision to buy something, and it doesn't help instill confidence when I know more about the product than the person ostensibly trying to sell it to me!
 
That was the problem. I'm trying to rationalize a decision to buy something, and it doesn't help instill confidence when I know more about the product than the person ostensibly trying to sell it to me!
To be honest, you're likely to find much more trustworthy advice and knowledge about Macs in this forum than you will find with most Apple store employees, especially from forum members who have been around for a while. You never know if you're talking to a store employee who's only been on the job a few months. We have no motivation to steer you in the wrong direction.
 
There is a possibility that you didn't ask the right questions, referring to your earlier gaff/s above.

In either case, Windows 7 runs exceptionally well with the new Mac's either under bootcamp or Parallel's 6. I'm on a 17" MBP w/8GB of RAM and my Windows Experience Indices are 6.9 and 5.9, respectively, and Office runs very well in either scenario.
 
There is a possibility that you didn't ask the right questions, referring to your earlier gaff/s above.

Possibly. I'm sure I didn't. I've never owned a Mac and I've been using PCs for decades. I'm guessing I'm not alone, and that there might be others who would consider switching if only we knew what questions to ask.
 
I'm guessing I'm not alone, and that there might be others who would consider switching if only we knew what questions to ask.
There's a wealth of information in the Helpful Information for Any Mac User link I posted in post #4. I encourage you to read through that.
 
Possibly. I'm sure I didn't. I've never owned a Mac and I've been using PCs for decades. I'm guessing I'm not alone, and that there might be others who would consider switching if only we knew what questions to ask.

GGJstudios, HellHammer (and all others) are pretty much spot on in their replies so I have nothing much to add other than to say I practically live in Excel. Also:

1.) Long time windows user (20 years). I hate change and was hesitant like you at first.

2.) I use both versions for PC and Mac. Parallels for the PC version of Excel runs fine. I certainly can't tell any difference. (Parallels give you lots of keyboard remapping options).

3.) Excel 2011 for the mac is robust. I'm a keyboard fanatic and don't miss the pageup/down keys. The Fn key on the mac provides most of the equivalents. Your fingers sort of just know where to go after a while (if that makes sense). And... compatibility among Excel for either platform is excellent.

Yes, it's true that OSX is "mouse happy" but honestly, they made the trackpad such a joy to use this is a non-issue (at least for me).

I wouldn't hang the entire company just based on one lone idiot at an Apple store for giving you the wrong info.

Lastly, Get a mac at B&H. $100 cheaper, free shipping, no sales tax (if you're not in NY), free copy of Parallels. (AppleCare is cheaper as well if you want it now).

Just ordered a 2nd MBP this year for one of the kids on Monday - will Arrive Friday. Can't recommend B&H enough - been using them for years.
 
Last edited:
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.