|
Related Topics:
| Remapping edit active cell to F2 - I didn't see a way to edit an active cell using the F2 key, since it doesn't have a menu item it does not appear to be remapped. Is there any third party to enable this?
Active Cell - Hi, Running Excel X, Panther 10.3.7 When I filter a database (Not as a list) I need the active cell to show at the first cell of the filtered data. This is needed for my macro's to function. I need to select this cell in my macro. Help!!
active cell in Excel for Mac - The light blue shading of the active cell is difficult to see. Does anyone know how to increase the or contrast of the active cell? thanks
Cell Edit shortcut - In Excel for Windows, if you press F2 the program puts you into cell edit mode. Is there an shortcut in Excel for the I have the latest version. I've tried pressing F2 with no apparent results. JWeinberg
Edit box covers cell above - When I edit a cell in Excel X, a white box comes up and covers up the = cell=20 above the cell I am editing. How do I get rid of that If I = want to=20 put a formula in a cell that contains a reference to the cell above the = one I=20 am..
|
|
|
Next: Excel: Error message on opening Excel workbooks
|
| Author |
Message |
External
Since: Feb 14, 2008
Posts: 3
|
(Msg. 1) Posted: Thu Feb 14, 2008 6:23 am
Post subject: Any way to remap "Edit the active cell" from CONTROL+U to F2?
Archived from groups: microsoft>public>mac>office>excel (more info?)
|
|
|
|
|
| Back to top |
|
 | |
External
Since: Mar 07, 2004
Posts: 3826
|
(Msg. 2) Posted: Thu Feb 14, 2008 9:08 am
Post subject: Re: Any way to remap "Edit the active cell" from CONTROL+U to F2? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
In article <ee8d68c.-1.DeleteThis@webcrossing.caR9absDaxw>,
JerryJ.DeleteThis@officeformac.com wrote:
> I just bought Office 2008, but am still using Excel 2002 (under VMWare) for
> my workbooks that have VB :-( My Excel 2002 brain thinks CONTROL+U means
> underline and F2 means edit a cell. I tried to remap the edit action to F2,
> but couldn't find it listed in Tools->Customize Keyboard->All Commands.
>
> Any suggestions?
AFAIK, F2 is not mappable to Edit Cell. I have provided a VBA solution
for XL04:
http://www.mcgimpsey.com/macoffice/excel/f2.html
I know how difficult it is, because I had to develop a bifurcated
understanding of XL when it was ported from Mac to Windows back in the
late 80's, and the WinXL team changed all the shortcuts. |
|
| Back to top |
|
| |
External
Since: Mar 03, 2008
Posts: 4
|
(Msg. 3) Posted: Mon Mar 03, 2008 2:59 am
Post subject: Re: Any way to remap "Edit the active cell" from CONTROL+U to F2? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Real shame about this.
I fed back to Microsoft after Office X and again in 2004 about this and other shortcuts, but clearly nothing has been done to rectify it. It is a real shame when power users have to learn two sets of shortcuts to work effectively between a PC and Mac. It really slows you down.
Sorry, MS, but this is a big oversight. >> Stay informed about: Any way to remap "Edit the active cell" from CONTROL+U to .. |
|
| Back to top |
|
| |
External
Since: Mar 03, 2008
Posts: 4
|
(Msg. 4) Posted: Mon Mar 03, 2008 5:29 am
Post subject: Re: Any way to remap "Edit the active cell" from CONTROL+U to F2? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Bob, fair point about order of learning, but I point out the following:
1) Microsoft produced both packages. Why couldn't they have the same keys?
2) You cannot fully customize shortcuts on a Mac. i.e. some keys (like F2) are off limits and cannot be assigned a new command.
3) I believe PC keys are fully customizable, therefore PC users must 'conform' to the Mac, not vice versa.
Anyway, having read some these forums, I'm finding little reason to upgrade to 08, especially with the omission of macros/VBA. What is that all about? I thought new releases were about enhancing the product, not taking away highly useful functionality.
Cheers
Jamie >> Stay informed about: Any way to remap "Edit the active cell" from CONTROL+U to .. |
|
| Back to top |
|
| |
External
Since: Feb 11, 2005
Posts: 566
|
(Msg. 5) Posted: Mon Mar 03, 2008 8:01 am
Post subject: Re: Any way to remap "Edit the active cell" from CONTROL+U to F2? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On 3/3/08 5:59 AM, in article ee8d68c.1.TakeThisOut@webcrossing.caR9absDaxw, "Jamie"
<Jamie> wrote:
> Real shame about this.
>
> I fed back to Microsoft after Office X and again in 2004 about this and other
> shortcuts, but clearly nothing has been done to rectify it. It is a real shame
> when power users have to learn two sets of shortcuts to work effectively
> between a PC and Mac. It really slows you down.
>
> Sorry, MS, but this is a big oversight.
Yea, but Jamie, it is the windows version that is the problem by assigning
the "wrong" keys in the first place. You just happened to learn Windows
first, many of us who started on the Mac have a similar gripe about the
windows version. You'll just have to get used to the differences, or
customize your shortcut keys.
--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom >> Stay informed about: Any way to remap "Edit the active cell" from CONTROL+U to .. |
|
| Back to top |
|
| |
External
Since: Mar 24, 2008
Posts: 1
|
(Msg. 6) Posted: Mon Mar 24, 2008 2:20 pm
Post subject: Re: Any way to remap "Edit the active cell" from CONTROL+U to F2? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Feb 11, 2005
Posts: 566
|
(Msg. 7) Posted: Tue Mar 25, 2008 7:27 am
Post subject: Re: Any way to remap "Edit the active cell" from CONTROL+U to F2? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On 3/24/08 6:20 PM, in article ee8d68c.4 RemoveThis @webcrossing.caR9absDaxw,
"Charles@officeformac.com" <Charles RemoveThis @officeformac.com> wrote:
> OK, this makes life hard no F2 to edit in Excel.
>
> So what about others like F4 (absolute in a formula)?
>
> Is there a complete list of CONTROL+ whatever keys?
Search help for shortcut keys.
--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom >> Stay informed about: Any way to remap "Edit the active cell" from CONTROL+U to .. |
|
| Back to top |
|
| |
External
Since: Mar 07, 2004
Posts: 3826
|
(Msg. 8) Posted: Tue Mar 25, 2008 8:01 am
Post subject: Re: Any way to remap "Edit the active cell" from CONTROL+U to F2? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
In article <ee8d68c.4 DeleteThis @webcrossing.caR9absDaxw>,
Charles DeleteThis @officeformac.com wrote:
> OK, this makes life hard no F2 to edit in Excel.
Yup - I was *pissed* when XL was ported from Mac to Windows and they
didn't use the original shortcut. Made life hard then, but I adapted
pretty quickly. Still occasionally use CRTL-u in WinXL - I use an event
macro to remove underlining...
> So what about others like F4 (absolute in a formula)?
This one's easier to remember for me, since CMD-t uses the CMD key. The
"new guy" doesn't have one, and so resorted to the harder-to-type F4.
Of course, for this and most other commands (though unfortunately not
CTRL-u), you can assign whatever shortcut you want using Tools/Customize
Keyboard...
> Is there a complete list of CONTROL+ whatever keys?
Did you try to look in Help (say, for "Excel keyboard shortcuts")? >> Stay informed about: Any way to remap "Edit the active cell" from CONTROL+U to .. |
|
| Back to top |
|
| |
|
FAQ
Search
Profile
Private Messages
Log in/Register/Password
