Is there a keyboard shortcut that can change the formula in a given cell from relative to absolute, or do I need to manually put $ marks in each formula?
I think I saw lately that a combination of an "F#" key and some other key would do this.
Is there a keyboard shortcut that can change the formula in a given cell from relative to absolute, or do I need to manually put $ marks in each formula?
I think I saw lately that a combination of an "F#" key and some other key would do this.
In the formula bar press F4.
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Thank you for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks