software

If you can already do this please let me know, i get fed up with entering $
each time I want to make it an absolute reference

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...lic.excel.misc


quot;Neilquot; gt; wrote in message
...
gt; If you can already do this please let me know, i get fed up with entering
gt; $
gt; each time I want to make it an absolute reference
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow
gt; this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...lic.excel.misc

Last week, someone posted this suggestion:

quot;You can use F4 to toggle through the different styles of absolute
references. =$A1, =A$1, =$A$1.quot;

Doesn't work in Excel 2000, but it might work if you have a later version.