The F2 key isn't used for that in Mac Excel due to OS differentiation. The Mac equivalent of 'edit in cell' is Control+U although my personal preference is to use the Formula Bar in the first place:-). That and most other keyboard shortcuts are defined in Excel Help. HTH :) Bob Jones MVP Office:Mac On 2/6/10 10:19 AM, in article [email protected], '[email protected]' wrote: Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi, I'm a new mac user and I'm using microsoft office for mac, but I'm having some problems using son features that win offices have. FOr example I use F2 in win office to see what cells are in use in a formula, but I couldnt find the same function in mac office.does any one know if there is such function?
Thanks in advance of you cooperation. A different way of seeing visibly which cells are referred to is by double-clicking the cell that contains the formula. When you do this, all the referenced cells become highlighte and can then use the TAB key to toggle through each referenced cell. In order to use this technique you must go into Excel preferences and deselect 'edit directly in cell'. This has always been the most efficient way for my pea-sized brain to see what is going on within the spreadsheet. Just depends how you like to work. This message is in MIME format.
Since your mail reader does not understand this format, some or all of this message may not be legible.B69643 Content-type: text/plain; charset='US-ASCII' Content-transfer-encoding: 7bit On 2/6/10 2:09 PM, in article [email protected], '[email protected]' wrote: A different way of seeing visibly which cells are referred to is by double-clicking the cell that contains the formula. When you do this, all the referenced cells become highlighte and can then use the TAB key to toggle through each referenced cell. In order to use this technique you must go into Excel preferences and deselect 'edit directly in cell'. This has always been the most efficient way for my pea-sized brain to see what is going on within the spreadsheet. Just depends how you like to work.
Function keys. Like their counterparts in the Windows world, Mac keyboards have function keys. These keys sit at the top of the keyboard and are labeled F1 to F12 on standard keyboards and F13, F14 and higher on extended keyboards. Standard Mac keyboard with 12 function keys. As you know, function keys are uses for many shortcuts in Excel. This is especially important with Excel, which uses a number of function keys for shortcuts. Function Keys. Modern Mac computers using an Apple keyboard have icons printed on some of the keys on the top row of the keyboard. These keys (F1 - F12) are called function keys. On a Mac, function keys can be used in two ways.
Bobby This is correct ONLY when the preference Edit directly in cells is OFF. You are correct, it is the best and most efficient way to see what is going on which is why I NEVER use edit directly in cell. Bob Greenblatt MVP, Macintosh bobgreenblattATmsnDOTcom -B69643 Content-type: text/html; charset='US-ASCII' Content-transfer-encoding: quoted-printable Re: F2 function On 2/6/10 2:09 PM, = in article 59bb25a5.1@webcrossi= ng.JaKIaxP2ac0, 'TheRedOak@off= iceformac.com' TheRedOak@o= fficeformac.com wrote: A different way of seeing visibly which cells are referred to is by d= ouble-clicking the cell that contains the formula.
When you do this, all the= referenced cells become highlighte and can then use the TAB key to toggle t= hrough each referenced cell. In order to use this technique you must go into= Excel preferences and deselect 'edit directly in cell'.
![]()
This has always been the most efficient way for my pea-sized brain to see w= hat is going on within the spreadsheet. Just depends how you like to work. Bobby This is correct ONLY when the preference Edit directly in cells is O= FF. You are correct, it is the best and most efficient way to see what is go= ing on which is why I NEVER use edit directly in cell. Bob Greenblatt MVP, Macintosh bobgreenblattATmsnDOTcom -B69643. Hey Bob; I whole-heartedly agree with you about editing directly in cells, but as for the dbl-clk method being. On 2/8/10 4:24 PM, in article C795EB5A.C1CB6%[email protected], 'Bob Greenblatt' wrote: the best and most efficient way to see what is going on I have to disagree a little:-) It may be the most 'convenient' way, but I find the Auditing Toolbar's features to be better, more informative & more efficient.
Especially if dealing with links or remote references because it enables seeing exactly what's being referred to without hopscotching you all over the place unless you choose to go there. If only it offered the additional features supplied on the Dark Side. Regards :) Bob Jones MVP Office:Mac. On 2/8/10 4:48 PM, in article C795F0C4.5B00C%[email protected], 'CyberTaz' wrote: Hey Bob; I whole-heartedly agree with you about editing directly in cells, but as for the dbl-clk method being. On 2/8/10 4:24 PM, in article C795EB5A.C1CB6%[email protected], 'Bob Greenblatt' wrote: the best and most efficient way to see what is going on I have to disagree a little:-) It may be the most 'convenient' way, but I find the Auditing Toolbar's features to be better, more informative & more efficient. Especially if dealing with links or remote references because it enables seeing exactly what's being referred to without hopscotching you all over the place unless you choose to go there.
If only it offered the additional features supplied on the Dark Side. Regards :) Bob Jones MVP Office:Mac I agree with you about the auditing tool bar. However, I rarely use it and rely instead on double clicking. It usually gets me what I'm looking for. Bob Greenblatt MVP, Macintosh bobgreenblattATmsnDOTcom.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |