I'm afraid I can't post the spreadhsheet I'm using but a simple example would be....
Cell A1 to A5
I'm not rejecting the search and replace option I was just wondering .....
1) Is there a shortcut / key press function to copy and paste cells A1 to A5 as they are to a difference range without loosing the cell reference.?
2) Is there a way of being able to highlight cells A1 to A5 and change them from Relative to Absolute without having to highlight individual cell references and pressing <F4>.?
Thanks.
Bookmarks