Comments To use these shortcuts, you may have to change your Mac keyboard settings to change the Show Desktop shortcut for the key. You must select the row starting with the active cell.
After pressing Return, move selection, select the direction you want to move in. Platinum Product Expert KarlS. Recommended Answer. I will mention this to a couple Mac users and see if they know a work-around that is easier than manual typing.
It might be keyboard specific though, so can you share the model information? Original Poster. Daniel Fhima. Yeah, I know I could do it manually but when working in large sheets this is extremely tedious. I'm using a Logitech K wireless for Mac. I had the same issue with an Anker one I was using previously. It sounds like none of the Mac using PEs use the hot key either.
Also, check with Logitech to see if they have a utility for your keyboard. Per Apple's help page:. If you don't see 'Use F1, F2, etc. These keyboards might need a utility to change the keyboard functions.
Check with your keyboard manufacturer for more information. This question is locked and replying has been disabled. Discard post? You will lose what you have written so far. Subscribe to updates.
Failed to attach file, click here to try again. Edit link. Text to display: Link to:. Cancel OK. Please follow our content policy when creating your post. Keep editing Discard. Personal information found. We found the following personal information in your message: This information will be visible to anyone who visits or subscribes to notifications for this post. Question: Q: F4 key as an "absolute" function key in excel More Less. Communities Contact Support. Sign in Sign in Sign in corporate.
Browse Search. Ask a question. User profile for user: lindasc lindasc. I need my F4 key to be the absolute function in excel.
Not working! I have a new imac 3.
More Less. Helpful answers Drop Down menu. View answer in context.
Loading page content. User profile for user: Badunit Badunit.
While editing a formula, this shortcut toggles cell references from relative to absolute, to partially Note: in Excel for the Mac, you can also use fn + F4. Most Excel users are familiar with absolute cell references. In a formula or function, if you type a $ sign In Excel for Mac, pressing F4 does not make a cell reference absolute. However, there is a shortcut key Command + T.
Desktops Speciality level out of ten: 0. Apr 8, PM in response to lindasc In response to lindasc What do you mean by "be the absolute function"? Does this mean it inserts the ABS function into the selected cell, changes the selected cell reference from relative to absolute, or what? F4 in Excel for Mac is "Paste text into active cell", which is not really necessary as it is duplicated by cmd-V.