|
|
#3
07-23-2015, 12:23 AM
|
||||
|
||||
Just for info here is another way to Paste values only ( on the same sheet) than using the right click menu
Long explanation, rapidly done Select the range containing the formulas of which you want to keep the values Put your cursor against the upper boundary of the selected zone -A cross appears - Press right button of your mouse and WHILE KEEPING THE BUTTON PRESSED move the selected range to where you need the values. ( It can be the same place you started from but you have to move a little). Release the button and a menu will pop up. Select " Copy Here as Values Only" - Done There are also some other interesting items in this menu
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Propagating a formula which references a named cell | Splint | Excel | 4 | 06-15-2015 04:55 AM |
| Updating document causes change lines on all cross references. :( | garybeck | Word | 2 | 05-08-2015 09:15 PM |
| Macro to change cell references | SaneMan | Excel Programming | 6 | 10-01-2013 02:49 PM |
| Formula that references cell with text in different workbook | no1texan | Excel | 3 | 07-17-2012 05:58 AM |
| quick replace, sort, change columns | userman | Excel | 1 | 05-01-2012 06:24 AM |
Cell references don't change on sort
Windows 7 64bit 
Office 2010 64bit
Threaded Mode