자료실

Global It Leader!!


유용한 TIP

엑셀 숨겨진 행 또는 열을 제외하고 복사하기

페이지 정보

작성자 no_profile 오원장 쪽지보내기 메일보내기 자기소개 아이디로 검색 전체게시물 댓글 1건 조회 6,754회 작성일 13-07-18 15:45

본문

 숨기기 한 데이터를 제외하고 현재 화면에 보이는 셀만 손쉽게 복사하려면
영역을 선택한 후 Alt+;를 누르고, Ctrl+C(복사)를 누른 후 새로운 시트에서 Ctrl+V(붙여넣기)를 누르면 현재 화면에 보이는 셀만 복사할 수 있습니다.
<1> 데이터 영역을 선택한 후 Alt+;를 누른 후 Ctrl+C(복사)를 눌러줍니다.
111.jpg

<2>
새로운 시트를 선택한 후 Ctrl+V(붙여넣기)를 누르면 숨기기 한 데이터를 제외하고 현재 화면에 보이는 셀만 복사된 것을 확인할 수 있습니다.
222.jpg

출처 : http://www.officetutor.co.kr/board/faq_lib/frm_vba_content.asp?page=3&idx=777

댓글목록

yanmaneee님의 댓글

yanmaneee 이름으로 검색 작성일

http://www.goyardsoutlet.com
http://www.supremenewyork.us.com
http://www.offwhite-shoes.us.org
http://www.goyardbags.us.com
http://www.paulgeorgeshoes.us.com
http://www.jordanstoreonline.com
http://www.gaps.us.com
http://www.jordantravisscott.com
http://www.jordanshoesstore.us.com
http://www.supreme.com.co
http://www.supremesoutlet.us.com
http://www.hermesbagsonline.com
http://www.bapesoutlet.com
http://www.kyrie6.org
http://www.golden-gooses.com
http://www.kyrieirvingshoes.us
http://www.kd13shoes.us
http://www.cheapjordanss.us.com
http://www.jordan11retro.us.com
http://www.abathingapeofficial.com
http://www.supremenewyork.us.org
http://www.offwhitehoodies.us
http://www.kyrie-7.com
http://www.off-whiteclothing.us.com
http://www.offwhite.us.org
http://www.yeezyboost.us
http://www.goyardshandbag.us
http://www.supremeclothingstore.com
http://www.palmangels-hoodie.com
http://www.bape-shoes.com
http://www.kd15shoes.com
http://www.chromeheartstoreonline.com
http://www.kd12.org
http://www.goldengoosedeluxebrand.us.com
http://www.yeezyboost380.us.com
http://www.kyrie-8.com
http://www.goldengoosesstore.com
http://www.kyrie7.us
http://www.palmangels.us.com
http://www.palmangelsoutlet.us.com
http://www.air-jordan.us.com
http://www.jordan12.us.com
http://www.goldengoose.us.org
https://www.kyrieirving-shoes.us.com
http://www.offwhiteoutlet.us.org
http://www.travisscotjordan.us
http://www.supremes-clothing.us.com
https://www.off-whites.us
http://www.jordan4.us.com
http://www.off-whiteclothing.us.org
http://www.hermesbelts.us.org
http://www.fearofgodhoodie.com
http://www.off---whiteshoes.com
http://www.gapyeezy.org
http://www.jordansshoes.us.com
http://www.curry-8.us
http://www.shoesjordan.us.com
http://www.cheapjordanshoes.us.com
http://www.bapesonline.com
https://www.air-jordanoutlet.com
http://www.jordan-retro.us.com
http://www.goldengooseshoes.us.org
http://www.hermes-outlets.com
http://www.cheapjordan.us
http://www.goyardsstoreonline.com
http://www.bape-hoodie.com
http://www.russellwestbrookshoes.us
http://www.offwhitexjordan1.com
http://www.curry9shoes.com
http://www.supreme-clothings.us.com
http://www.curry9.us
http://www.fearofgod-clothing.com
http://www.paulgeorge.us.com
http://www.kyrie9.com
http://www.golden-goosesoutlet.com
http://www.kd12.us.com
http://www.off-whiteshoes.us.com
http://www.goldengooseofficial.com
http://www.offwhitexnike.com
http://www.bapehoodie.us
https://www.goldengoosessale.com
https://www.hermesonlineshop.com
http://www.kd14shoes.com
http://www.adidasyeezyboost350.us.com
http://www.goldengooseoutletus.com
https://www.supremeoutlet.us.com
http://www.bape-clothing.us
http://www.bapeshoodie.com
http://www.kd15.us
http://www.supremes.us.org
http://www.giannisantetokounmposhoes.us
http://www.kd14.org
http://www.bapesta.us.com
http://www.kyrie8shoes.com
http://www.bapes.us.org
http://www.bape.us.org
https://www.palmangelsonline.com
http://www.fearofgod.us.com
http://www.yeezy350boost.us.com
http://www.supremeclothings.com
http://www.bape-shirt.us.com
http://www.ggdb.us.com
http://www.supremesonline.com
http://www.bape-stas.com
http://www.supremeclothing.us.org
http://www.yeezysneakers.us.org
http://www.off-whitehoodie.com
http://www.travisscotjordan.com
http://www.goyardshandbags.us.org
http://www.kyrie5spongebob.us
https://www.fearofgodoutlet.com
http://www.off--white.us.com
http://www.goldengooseonlinestore.com
http://www.jordansshoes.us.org
http://www.yeezy-500.us.com
http://www.offwhitetshirt.us.com
http://www.offwhitexjordan.com
http://www.kyrie9.us
http://www.supreme-clothing.us.org
http://www.off--whiteoutlet.com
http://www.curry6.net
http://www.shoes-yeezy.us
http://www.goyard-outlet.com
http://www.hermes-handbags.us.com
http://www.hermesoutletsonline.com
http://www.kobe-shoes.us.com
http://www.bapesclothing.com
http://www.fearofgodoutlet.us.com
http://www.jordanxtravisscott.com
http://www.birkinbag.us.com
http://www.jordan1shoes.us
https://www.hermesoutlets.com
http://www.goldengooseoutletstore.com
http://www.goldengoosesneakerssale.us.com
http://www.kyrie8.us
http://www.supremeshirt.us.com
http://www.palmangels-clothing.com
http://www.bape-clothing.com
http://www.jordan13.us.com
http://www.kobe.us.com
http://www.supremeclothings.us.com
http://www.supreme-newyork.us.org
http://www.off--whiteclothing.com
http://www.goyardhandbag.us.org
http://www.goyardoutlets.us
http://www.jordansforcheap.us.com
https://www.offwhitesoutlet.com
http://www.stephcurry.us
http://www.fearofgodessential.com
http://www.kevindurantshoes.us.com
http://www.sbdunk.us
http://www.bathing-ape.us
http://www.goyardshandbag.com
http://www.yeezy-shoes.us.org
http://www.offwhitesonline.com
http://www.kyrie7shoes.us
http://www.hermesbirkins.com
http://www.jordanssneakers.us.com
http://www.yeezy700.us.com
http://www.yeezy-350.us.com
http://www.supreme.us.org
http://www.off-whiteoutlet.us.com
http://www.jordans-shoes.us.org
http://www.adidasyeezyuk.com
https://www.off-whiteonline.com
http://www.kd-shoes.us
http://www.goldengoosesale.us.org
http://www.michaeljordanshoes.us.com
http://www.goldengoosesonline.com

전체 0
게시물 검색
유용한 TIP 목록
번호 제목 글쓴이 조회 날짜
게시물이 없습니다.