|
|
#8
01-27-2019, 05:54 AM
|
|||
|
|||
The quickest way I've found is to use the Find and replace option under the Home tab.
First select the cells you want to copy over and use Find and replace to change the = to a '= the copy your cells and paste them in your new sheet and then use find and replace to change the '= back to = 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How can I copy a worksheet and paste values to another new workbook ? | DBenz | Excel | 1 | 01-26-2019 07:03 AM |
| Looking to copy select cells in table using dropdown list to paste to new table in another worksheet | CaptainRetired | Excel Programming | 18 | 01-04-2018 07:22 PM |
 Get multiple cells in separate worksheet
|
kerkstrt | Excel | 1 | 10-26-2014 11:20 PM |
| Can you copy & paste cells across worksheets and preserve reference to worksheet? | New Daddy | Excel | 2 | 11-27-2013 07:19 AM |
|
Insert/Paste Picture into Protected Worksheet
|
udea | Excel | 1 | 02-06-2012 07:43 PM |
Windows 7 64bit 
Office 2016
Threaded Mode