The F4 key in Excel for Windows is normally a shortcut key to Repeat the last command. In Excel for Mac the F4 key is assigned to the Pastecommand, which is driving me crazy so I decided to do something about it. Default Excel F4 Keyboard Assignment in Excel for Mac There are four keyboard shortcuts assigned to the Paste command in Excel for Mac — Shift+Del, Control+V, F4, and Command+V. Overkill, don’t you think?
So I’m thinking the F4 button can be reassigned with no problems, unless, of course, you’re in the habit of using the F4 key for the Paste command. Reassign the F4 button in Excel for Mac. Select the Tools menu, and click Customize Keyboard.
The EXP function syntax has the following arguments: Number Required. The exponent applied to the base e. To calculate powers of other bases, use the exponentiation operator (^). EXP is the inverse of LN, the natural logarithm of number. Copy the example data in the following table, and paste it in cell A1 of a new Excel.
In the Categories: box select Edit. In the Edit box, select Redo. Select the Press new shortcut key: box.
Press the keyboard combination fn+F4 key (or just F4 key if you’ve ). Click Add. Click OK to reassign the Paste command to the Redo command.
To hide cells in Excel for Mac, first create your table, making sure to leave room for expansion if necessary. Next, select the first column to the right of your data. Now we need to select all columns from this starting point to the end of the spreadsheet. Because Excel gives users spreadsheets with tens of thousands of rows and columns, we’ll use keyboard shortcuts to quickly jump to the end. With the rightmost empty column selected, press and hold the Shift key and then press Command + Right Arrow.
This will jump you to the end of the spreadsheet while the Shift key automatically selects every cell in between. Now we have to tell Excel to hide these cells. With your cells still selected, go to Excel’s Menu Bar and choose Format Column Hide. You’ll now see all the cells to the right of your data disappear. Next, we need to deal with the cells below your data.
Similar to the steps above, this time select the first row beneath your data. With the bottommost cell selected, press and hold Shift and then press Command + Down Arrow.
This will jump you to the very bottom of the spreadsheet and select all the rows in between. Finally, head back up to Excel’s Menu Bar and choose Format Row Hide. You’re now left with a spreadsheet that features only cells containing your data, resulting in a much cleaner look. If you need to expand your table, or simply don’t like the new look, you can easily unhide the cells. First, click the top-left heading cell that looks like a white arrow pointing to the bottom-right corner. Clicking this cell will select all cells in your spreadsheet, both hidden and not. Once selected, go to Excel’s Menu Bar and choose both Format Column Unhide and Format Row Unhide.
Your spreadsheet will now be restored to the default look. In our example the hidden cells were empty, but these steps can also be used to hide cells that contain data. This can be useful for quickly hiding irrelevant or sensitive data during a presentation, for example. In either case, note that hiding data in this manner is not a secure solution, and these steps should only be used to hide data for purposes of convenience.