Excel:Mac 2011 Keyboard Shortcuts

[eschacha]

Hi Guys

I apologise first of all - I'm a mac user and using the mac version of excel which frankly I will openly admit is no competition for the pc version.

I'm dealing with lots of data information on massive spreadsheets and constantly using the search facility. On the mac version of excel for some reason - I can't use the Find dialogue box - using Ctrl & F - and edit the information at the same time - I have to keep closing the dialogue window first - which is really frustrating! There is a perfectly good "search in sheet" field in the top right hand corner - which does let me search and edit data at the same time - however i have to keep moving the mouse over to the top corner which is nearly as time consuming as opening and closing the find dialogue. Does anyone know of a keyboard shortcut to jump to this search box? This is driving me demented - almost enough to go back to PCs!

Cheers in advance

Ewan

 

[Sal Paradise]

Not a solution, but if you still have a copy of PC Windows and Office lying around, you can spend $80 for a copy of VMWare Fusion and run the PC version to save you some headaches. That's what I did when I came across the "quirks" of the Mac version.