|
OAK's Copy Address command copies the address of the current selection to the clipboard, using a variety of formatting options.
Why would you want to use it?
Someone checking a spreadsheet may wish to include in a written report the location of issues that have come to light in the course of a review. Where the cells involved are numerous, and widely scattered over a worksheet, writing out the location can be tedious and hard to achieve with accuracy, particularly if there is quite a number of issues to report.
How to use it
| 1. | Select the cell(s) for which you want to copy the addresses. |
| 2. | Go to OAK Development | Cells | Copy Address |
| 3. | The Copy Address dialog appears. Use this to select the formatting options. Click OK to place the text in the clipboard. |
| 4. | Paste the text into the target document. |
FORMATTING OPTIONS
| • | Include Workbook Name: Includes the workbook name in the prefix. Cannot be used without inclusion of the worksheet name. |
| • | Include Worksheet Name: Includes the worksheet name in the prefix. |
| • | Prefix all regions: Prefix all the regions listed, rather than just the first. Prefixes on every listed region can appear superfluous in natural language documents. |
| • | Notation: Select between A1, $A$1 and RC notation. |
| • | Delimiter: Select the character used to delimit the listed regions, optionally with an additional space. |
What you could do if you didn't have OAK
One can achieve an approximation to the Copy Address operation without using OAK, by invoking Excel's Insert | Name | Define command to bring up the Define Name dialog. The bottom field of that will contain a text representation of the selected cells. Press Tab twice to move the cursor into this field, and the text will become highlighted. Now press Ctrl-C to copy it onto the clipboard, and Esc to dismiss the dialog.
|