I was wondering if there is way to have the $ sign added as I pick cells to make a formula without having to edit the formula after I pick the cells. Here's an example: the formula in D1 = A1-B1-$C$1. I started by entering = in D1 then picked A1, hit - key, picked B1, hit - key, then picked C1. When I pick C1 is there something I can do to have excel add the $ signs for me? I have excell 2003.
Last edited by gibbsmachine; 08-12-2010 at 10:55 AM.
Yes, Hit F4 after you pick the cell.
Everytime you hit F4, it toggles the $ around.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thanks. I looked in the help pages and my Microsoft Excell 2003 book and could not find anything on this topic.
You can find it in various locations on the web:
Google Short Cut keys and Excel
Example:
http://www.mvps.org/dmcritchie/excel/shortx2k.htm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks