create array in Excel using mac keyboard

Question

I am teaching a statistics course in an adult ed. program.  The school computers have XP Prfessional running on macs, with mac keyboards. I need to use the LINEST function in excel, which requires an array for the full statistics to be displayed.  When I try the normal method of creating an array (F2 followed by Ctrl+Shift+enter) on the mac keyboard it doesn't work.  How do I create an array with this combination of software and hardware?

Answer 1

I was using a desktop, not a laptop.  However, holding down the fn key while hitting F2 and then doing CTL+Shft+Ent worked.  Thanks to all.

Answer 2

Well, MacXL's array formulae are entered using CMD-Return.

However, if the computers are running Windows XP, that implies that they're also running a version of WinXL (despite the OP indicating that he's using XL2011), in which case CSE should work.

Are you sure you're typing CTRL rather than CMD?

Answer 3

Would they need to hold the FN (Function Key) down if they are using Mac Laptops?

Even if the are using Bootcamp, or Parallels, or Fusion to run XP and Office2010.

Not unless they've remapped their keyboard...

Answer 4

Would they need to hold the FN (Function Key) down if they are using Mac Laptops?

Even if the are using Bootcamp, or Parallels, or Fusion to run XP and Office2010.

Answer 5

... I try the normal method of creating an array (F2 followed by Ctrl+Shift+enter) on the mac keyboard it doesn't work ...

Excel's Array formulas are entered with Command+Return on the Mac