|
|
#1
01-23-2019, 03:50 PM
|
|||
|
|||
easiest way of turning a sheet into values only ?
Hi, Excel 2010, I need to convert sheets to values only, what is the quickest way of doing that retaining the formatting ? At the moment I am creating a new sheet beside a source sheet then name it with suffix nf then select corner of source , select copy, then corner of new and copy paste >values to it then format it same as previous sheet. There has to be an easier way I hope. DBenz 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Multiple found values from five sheets, multiple returned values in sheet six? | irisha | Excel Programming | 26 | 09-30-2016 01:20 AM |
| How to convert VLOOKUP values to text on another sheet AUTOMATICALLY | Lady18 | Excel | 5 | 09-10-2016 03:12 AM |
 How to convert VLOOKUP values to text on another sheet AUTOMATICALLY
|
Lady18 | Excel | 1 | 09-10-2016 12:15 AM |
| Reading Values from another sheet | Raabi | Excel | 2 | 05-20-2011 02:14 AM |
| Word - Calculate and paste values from Excel sheet | Augf87 | Word | 1 | 07-06-2009 10:26 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode