Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I get relative/absolute reference button (macros)
I am lazy and like to record macros but I lost the little button that
switches from absolute to relative references how do I get it back? |
#2
|
|||
|
|||
Hello "SPBaku",
You can assign a macro to an option button in Excel- see article from microsoft: http://support.microsoft.com/default...b;en-us;141689 If you had customized a toolbar to include an icon that ran the macro, you will have to recreate it by choosing Tools, Customize. On the Commands tab, scroll to and click Macros under categories, then drag the custom button to a toolbar. With the customize box still open, right-click the icon, choose Assign Macro, locate your macro and click it, then choose OK. Close the customize dialog box. Did you ever simply try using the F4 key to switch absolute and relative addresses? After typing the cell address that should have an absolute (or mixed relative and absolute address) within your formula, immediately press the F4 key. Pressing F4 once makes row and column absolute. Press F4 again, and just the row reference becomes absolute. Press F4 again, and just the column reference becomes absolute. Press F4 again, and you return to normal relative reference If you continue to press F4, the reference settings cycle. Hope something here is helpful. Cheers, Annie "SPBaku" wrote: I am lazy and like to record macros but I lost the little button that switches from absolute to relative references how do I get it back? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Command Button anomalies | Excel Discussion (Misc queries) | |||
Explanation Relative/Absolute Cell Reference | Excel Worksheet Functions | |||
RELATIVE REFERENCE BUTTON | Excel Discussion (Misc queries) | |||
Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) |