If you’re a regular Microsoft Excel user who needs to use MS Excel’s ‘Absolute Cell References’ feature on a Mac computer, you’ll notice that the FnF4 key combination doesn’t work as well on OSX as it did on Windows. The question then becomes: What is the equivalent of f4 in Excel on a Mac? STEP 4: You’ll be taken to the cell/range referenced. STEP 3: Press F5 to open the Go To dialog box, then press OK. STEP 2: With your mouse, select the formula argument you want to edit. Pressing?T is the equivalent if you’re using a Mac.Īlso, in Excel, what is the shortcut key for a reference cell? STEP 1: Double-click inside your Excel formula to access a cell reference. You can make an Excel cell reference absolute (or fixed) if you use a PC or Windows-based laptop by pressing the F4 function key after the cell reference on the keyboard. For absolute cell references, Microsoft Excel has a Mac keyboard shortcut.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |