Excel absolute reference keyboard shortcut mac

Cmd+T does not work for toggling absolute/relative in Excel Mac 2008

You can enter nonrelative references absolute or mixed manually by inserting dollar signs in the appropriate positions, or you can use a handy shortcut - F4 key. Ask Question. We use your email only for the communication between you and our team. Failed to send the question. Please try again. Images larger than px wide or px tall will be reduced.

Up to three images may be included in a comment.


  • All replies.
  • Cmd+T does not work for toggling absolute/relative in Excel Mac 2008!
  • Shortcut Keys for Spreadsheets - LibreOffice Help!
  • free alternative to microsoft publisher for mac;

All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted. The F4 key applies the same formatting that was previously applied to another cell so if I change the back fill colour to yellow, move to another cell and press F4, the current cell back fill is also changed to yellow.

Excel Keyboard Shortcuts - Excel How To

Note that this does not apply multiple formats so if I set backfill to yellow, font style to italic and font colour to red in that order , F4 on another cell just changes the font to red. You just saved me another hour of trying to figure out how this keyboard works!

Thank you good sir. Problem F4: I had the same problem during a trainin where one of the participants had a HP laptop. In the setup of the laptop he could change this: so now F4 is F4 again. When i click mojilafirefox, open my compute. I face this poblm. When click f4 then infront project link second displa. Then click second display i solve my poblm. But again and again faceing this ponlm. How to solve this ponlm. You are a magician - thank you! F4 was my go to key for "repeat last action" action and it drove me nuts that I couldn't use it. Now I can! Thanks so much; this has been driving me crazy since i recently got a new work computer Dell Inspiron.

My keyboard has a function lock that was on, I pressed the function lock key that looks like an F in a square box followed by the word lock, and then F4 worked for changing cell references. Adolfo Gonzalez, that did the trick for me! That explains why it used to work and then quit. I didn't know what that key did.

Move around within a spreadsheet

Hi Wyatt, I ran into this in class the other day. Apparently you can also use the Windows button instead of FN. However, the point is, MS has ruined a perfectly normal shortcut that has been with us for about two decades. Who the hell decides these things??? Certainly not us. Nice one. Pressing the FN and F4 key simultaneously solved the trick.

I kept searching after my last post 03 Oct and found a solution. The setting is not Windows related, it is PC related. Need to update BIOS. Just bought a new HP running Windows 10 and Office I have the same problem as the original article.

The same with F2 - instead of editing, my screen dims. By holding the Fn key before pressing the keys, returns to the expected functionality, which is a part solution. I use these functions all the time.

Question Info

I'd rather hold down Fn if I want to switch display like almost never! Anyone have any idea?


  • virtualbox screen resolution mac os x!
  • mac and cheese substitute for butter!
  • Use the keyboard for formula entry in Numbers ’09.
  • Footer Resource links.
  • how to extract a rar file on mac without password?
  • Excel shortcut keys.
  • A handy shortcut that switches between relative and absolute references - TechRepublic!

I've searched extensively and this is the closest I've come, without solution. Hi, I do indeed have a Toshiba Laptop with Windows 8. If I try to use F2 first, it indeed allows only to readjust brightness.


  • mac sjr machinery co ltd?
  • Shortcut Keys for Spreadsheets;
  • Shortcuts for the Visual Basic Editor!
  • Table of contents?

And if I try to do again in an other cell, the same procedure affects nothing whatsoever. Weird, isn't it? So I am stuck with my original problem! You can hold the windows key down and then press the F4 key as you did before and it will lock your formula I was not able to use f4 keys in excel Thanks again sir.

After pressing Return, move selection, select the direction you want to move in. Use charts F11 Insert a new chart sheet. Excel Shortcuts Comments Perform the action assigned to the default command button the button with the bold outline, often the OK button. Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents. Apply the currency format with two decimal places negative numbers appear in red with parentheses.