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
The Formula Builder is a great place to find any formula you may need in Microsoft Excel for Mac. The shortcut to pop up this Formula Builder is a simple, one modifier key shortcut utilized to improve efficiency in MS Excel. Microsoft Excel is one of the most popular applications from Microsoft Office. With the advent and popularity of Mac, Microsoft Excel for Mac was introduced to help manage, analyze and organize data as well as other Microsoft Excel information.
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…
- 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 setup the Mac function keys normally)
- Click Add
- Click OK to reassign the Paste command to the Redo command.
The Excel F4 button will now work with the Redo command, which is similar to how Excel for Windows is setup.
Note: You have to make this change to each version of Excel for Mac. For instance the above procedure was done in Excel 2011, but my Excel 2008 version of Excel for Mac wasn’t affected and has to be done separately.
This Excel tutorial explains how to use the Excel ADDRESS function with syntax and examples.
Description
The Microsoft Excel ADDRESS function returns a text representation of a cell address.
![Excel Excel](/uploads/1/2/6/3/126301137/202959604.png)
The ADDRESS function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the ADDRESS function can be entered as part of a formula in a cell of a worksheet.
Syntax
The syntax for the ADDRESS function in Microsoft Excel is:
![Free excel for mac Free excel for mac](/uploads/1/2/6/3/126301137/720579677.jpg)
Parameters or Arguments
Optional. It is the type of reference to use. If this parameter is omitted, it assumes that the ref_type is set to 1. It can be any of the following values:
Value | Explanation |
---|---|
1 | Absolute referencing. For example: $A$1 |
2 | Relative column; absolute row For example: A$1 |
3 | Absolute column; relative row For example: $A1 |
4 | Relative referencing. For example: A1 |
Optional. It is the reference style to use: either A1 or R1C1. If this parameter is omitted, it assumes that the ref_style is set to TRUE. It can be any of the following values:
Value | Explanation |
---|---|
TRUE | A1 style referencing |
FALSE | R1C1 style referencing |
Returns
The ADDRESS function returns a string/text value.
Applies To
- Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000
Example (as Worksheet Function)
Let's look at some Excel ADDRESS function examples and explore how to use the ADDRESS function as a worksheet function in Microsoft Excel: