How paste non blank source range into range target without interupting formula in target range
- Thread starter tiong999
- Start date
Chihiro
Excel Ninja
First, select H41:H68, then "Go to Special" and select blanks.
You'll notice some of the cells are not true blanks. You'll have to select those ranges and hit Delete to clean it up.
Then select H41:H68 copy. Right click on I41. Hit s then s again.
This will open paste special menu.
Hit v then b. Paste.
You'll notice some of the cells are not true blanks. You'll have to select those ranges and hit Delete to clean it up.
Then select H41:H68 copy. Right click on I41. Hit s then s again.
This will open paste special menu.
Hit v then b. Paste.
Hi Chichiro,
Im glad for your reply.
"You'll notice some of the cells are not true blanks. You'll have to select those ranges and hit Delete to clean it up."
Im noticed your statement but i dont quite understand.
Im experimenting this way:
* Select G3:G31
* "Go to Special" and
* Check circle option "CONSTANTS" and keep "Numbers" still check and uncheck others
* Hit Ctrl+C to Copy
* Right click G41 and go to paste special
* Click Paste "Values" hit V and B
But i still have no expected results.
Please review what is lack so i able have G41:G68 the same result as I41:I68.
Regards,
Tiong
Im glad for your reply.
"You'll notice some of the cells are not true blanks. You'll have to select those ranges and hit Delete to clean it up."
Im noticed your statement but i dont quite understand.
Im experimenting this way:
* Select G3:G31
* "Go to Special" and
* Check circle option "CONSTANTS" and keep "Numbers" still check and uncheck others
* Hit Ctrl+C to Copy
* Right click G41 and go to paste special
* Click Paste "Values" hit V and B
But i still have no expected results.
Please review what is lack so i able have G41:G68 the same result as I41:I68.
Regards,
Tiong
Last edited by a moderator:
Maybe,
1st step, to clear cells that are not true blanks
* Select G4:G31
* Ctrl+G >> click "Special" >> check "Constants" and uncheck "Numbers" >> OK
* Hit "Delete"
Then,
* Select G4:G31 again
* Ctrl+G >> click "Special" >> check "Blanks" >> OK
* In the formula bar enter: =E5 and Ctrl+Enter
* Finish
Regards
Bosco
1st step, to clear cells that are not true blanks
* Select G4:G31
* Ctrl+G >> click "Special" >> check "Constants" and uncheck "Numbers" >> OK
* Hit "Delete"
Then,
* Select G4:G31 again
* Ctrl+G >> click "Special" >> check "Blanks" >> OK
* In the formula bar enter: =E5 and Ctrl+Enter
* Finish
Regards
Bosco
Hello Bosco,
Interesting of your way to paste it in similar result as i expected.
It work perfectly, only if i paste it special into the same G4:G31.
But, unfortunately G4:G31 is source range to copy, and i will paste special to G41:G68.
Notes: Example Range I41:I68, is expected result im looking for.
Regards,
Tiong
Interesting of your way to paste it in similar result as i expected.
It work perfectly, only if i paste it special into the same G4:G31.
But, unfortunately G4:G31 is source range to copy, and i will paste special to G41:G68.
Notes: Example Range I41:I68, is expected result im looking for.
Regards,
Tiong
Last edited by a moderator:
Chihiro
Excel Ninja
If you paste special values, along with "Skip blanks" checked, it will only copy cells with values in them. However, if you use your source range of "G4:G31", you'll notice seemingly blank cells overwriting existing values.
This means these cells are not truly blank and may contain some invisible character in them. Hence, select those cells and hit delete to clear those cells.
After that, copy the range. Then right click on G41, s, s, then v, b. Ok. Done.
This means these cells are not truly blank and may contain some invisible character in them. Hence, select those cells and hit delete to clear those cells.
After that, copy the range. Then right click on G41, s, s, then v, b. Ok. Done.