Preskoči na glavno vsebino

Hitro kopirajte podatke in jih prilepite v vidne celice samo v Excelu

Avtor: Xiaoyang Zadnja sprememba: 2023-02-03

Kutools za Excel

Izboljša Excel s 300+
Zmogljive lastnosti

Ko v Excelu kopirate in prilepite nekaj podatkov v obseg, ki je bil filtriran ali vsebuje skrite vrstice, bodo podatki prilepljeni tudi v te filtrirane ali skrite celice. Ali lahko le prilepimo podatke v vidne celice samo v Excelu? da Kutools za Excel's Prilepite v Vidno funkcija vam bo pomagala hitro opraviti.

Kako prilepiti samo v vidne celice

Prilepi v predstavitev vidnega obsega


Lokacija Prilepi na vidno: Kutools> Prilepi na vidno

strelna pasta v vidne celice 01


Kako prilepiti samo v vidne celice

Recimo, da imamo filtrirano tabelo, kot je prikazano na spodnjem posnetku zaslona; če želite nadomestiti vidne vrednosti količine v stolpcu C z novimi vrednostmi količine v stolpcu D, naredite naslednje:

shot-paste-to-visible-cells-2

1. Izberite podatke, ki jih želite kopirati in prilepiti na filtriran seznam.

2. Na Kutools zavihek, v Razpon in celice skupina, kliknite Prilepite v Vidno.

strelna pasta v vidne celice 02

3. v Prilepite v vidni obseg v pozivnem polju izberite prvo celico obsega, kamor želite prilepiti izbrane podatke, in nato kliknite OK gumb.

Rezultat: izbrani podatki se takoj prilepijo v filtrirane vrstice.


Opomba:
  • Če želite samo kopirati in prilepiti vrednosti (brez oblikovanja in ne formul), kliknite Prilepite v Vidno > Samo prilepi vrednosti in korak 2.

  • Ta pripomoček podpira razveljavite (Ctrl + Z).
  • Funkcija vam pomaga prilepiti podatke samo v vidne celice, tako da deluje ne glede na to, da so v vaših podatkih filtrirane ali skrite vrstice.

Predstavitev: kopirajte podatke in jih prilepite v samo vidne celice / filtriran seznam v Excelu



Kutools za Excel: z več kot 300 priročnimi funkcijami, brezplačno poskusite brez omejitev v 30 dneh. Prenesite in brezplačno preskusite zdaj!


Priporočena orodja za produktivnost
Naslednja orodja vam lahko v veliki meri prihranijo čas in denar, katero je najbolj primerno za vas?
Zavihek Office: Uporaba priročnih zavihkov v pisarni, kot način Chrome, Firefox in New Internet Explorer.
Kutools za Excel: Več kot 300 naprednih funkcij za Excel 2021, 2019, 2016, 2013, 2010, 2007 in Office 365.

Kutools za Excel

Zgoraj opisana funkcionalnost je le ena izmed 300 zmogljivih funkcij Kutools za Excel.

Zasnovan za Excel(Office) 2021, 2019, 2016, 2013, 2010, 2007 in Office 365. Brezplačen prenos in uporaba 30 dni.

Posnetek zaslona Kutools za Excel

btn preberi več      btn prenos     btn nakup

 

Comments (10)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
How dynamically i paste values in another sheet without vba?
This comment was minimized by the moderator on the site
What if you have one value want to paste into multiple cells?
This comment was minimized by the moderator on the site
Then you can use the traditional copy and paste: Press Ctrl + C to copy the value, and then hold Ctrl to select multiple cell ranges, at last, press Ctrl + V to paste the value to the selected cells.

Amanda
This comment was minimized by the moderator on the site
This didn't work for me at first either. I was trying to copy and paste. But you don't copy anything. You just select the values that you want to copy - don't actually copy them and then click over to where you want them to be pasted to and click Paste Visible and then tell it what range you want it to be pasted into and and click ok. No copy paste required.
This comment was minimized by the moderator on the site
Why the kutools is not working for the paste value to visible cells?
This comment was minimized by the moderator on the site
Hi there,

Sorry for the late reply. Are you still experiencing the problem? If yes, please follow the modified tutorial.

Amanda
This comment was minimized by the moderator on the site
This isn't working for me - am I missing a trick?
This comment was minimized by the moderator on the site
This particular function is not working for me either. And this was the one I really needed...
This comment was minimized by the moderator on the site
me either, the paste visible has no video to demonstrate now.
This comment was minimized by the moderator on the site
Hi there,

There is a demonstration video at the end of the page. Please follow it. If there is any problem, don't hesitate to ask me.

Amanda
There are no comments posted here yet
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations