엑셀 필수 단축키 모음, 이 영상 하나로 총정리 하세요! | 진짜쓰는 실무엑셀 1-5-1
오빠두엑셀 l 엑셀 강의 대표채널
View ChannelAbout
오빠두엑셀은 직장인을 위한 엑셀 강의 유튜브 채널입니다. 영상을 보시면서 부족한 부분이나 개선사항이 있을경우 언제든지 편하게 연락을 남겨주세요. 항상 실무에서 필요하고 도움이되는 유익한 정보로 여러분께 인사드리겠습니다. 감사합니다. 🡻 오빠두 공식 홈페이지 🡻 http://www.oppadu.com
Latest Posts
Video Description
✅ 예제파일 다운로드 & 셀프 점검 Quiz https://www.oppadu.com/%ec%a7%84%ec%a7%9c%ec%93%b0%eb%8a%94-%ec%8b%a4%eb%ac%b4%ec%97%91%ec%85%80-1-5-1/ 👇 실무에 꼭 필요한 엑셀의 거의 모든 것을 담았습니다! "진짜 쓰는 실무 엑셀" 교재 구매하기 - 교보문고 https://bit.ly/excel_kyobo - 예스24 https://bit.ly/excel_yes - 알라딘 https://bit.ly/excel_aladin ⭐오빠두엑셀 위캔두 멤버쉽 채널 가입하기 https://www.youtube.com/channel/UCZ6UHYBQFBe14WUgxlgmYfg/join Pro: 라이브강의 풀영상 다시보기 제공 Premium : 프리미엄 전용 워크샵 및 다시보기 영상 제공 00:00 강의 시작 00:48 빠른실행도구모음 (Alt + 숫자) 03:15 ALT 단축키 04:28 이전작업반복 (F4) 05:04 실행취소/다시실행 (Ctrl + Z) 05:30 저장/다른이름으로저장 (F12) 06:26 범위 이동/선택 (Ctrl + 방향키) 08:00 셀 편집 (F2) 08:38 전체 행/열 선택 (Shift + Space) 09:14 셀 삽입/삭제 (Ctrl + +/-) 09:48 범위 밀어서 붙여넣기 (Shift + 드래그) 10:30 좌우스크롤 (Ctrl + Shift + 휠) 10:46 화면배율변경 (Ctrl + 휠) 11:12 메뉴 숨기기/전체화면 (Ctrl + F1) 11:49 틀고정 (Alt - W - F - F) 12:47 자동필터 (Ctrl + Shift + L) 13:47 선택하여붙여넣기 (Ctrl + Alt + V) 14:39 찾기/바꾸기 (Ctrl + F) 15:31 빠른채우기 (Ctrl + E) 16:20 셀서식관련 (Ctrl + Shift + 숫자) 17:39 보고서정리 (Ctrl + PgUp/Home)
Upgrade Your Tech Now
AI-recommended products based on this video
![VANMASS [85+LBS Strongest Suction & Clip] 2025 Upgrade Car Phone Holder [Patent & Safety Certs] Cell Phone Mount Truck Stand for Dashboard Windshield Vent for iPhone 16 Pro Max 15 14 13 12 Samsung](https://m.media-amazon.com/images/I/71bHSP1cRkL._AC_UL960_FMwebp_QL65_.jpg)
VANMASS [85+LBS Strongest Suction & Clip] 2025 Upgrade Car Phone Holder [Patent & Safety Certs] Cell Phone Mount Truck Stand for Dashboard Windshield Vent for iPhone 16 Pro Max 15 14 13 12 Samsung
![iPhone Charger Fast Charging [Apple MFi Certified] USB C to Lightning Cable 6FT USBC to Lightning Cable Nylon Braided Type C Cord for iPhone 14 13 12 11 Pro Max XR XS X 8 7 6 Plus SE, iPad](https://m.media-amazon.com/images/I/517jTqwo1nL._AC_UL960_FMwebp_QL65_.jpg)
iPhone Charger Fast Charging [Apple MFi Certified] USB C to Lightning Cable 6FT USBC to Lightning Cable Nylon Braided Type C Cord for iPhone 14 13 12 11 Pro Max XR XS X 8 7 6 Plus SE, iPad
![iPhone Charger [Apple MFi Certified] 3FT, 3Pack USB A to Lightning Cable Braided Fast Charging Apple Cord Compatible with iPhone 14 13 12 11 Pro Max XS XR X 8 7 6 5 Plus iPad/iPod/AirPods](https://m.media-amazon.com/images/I/71xZOlUELbL._AC_UL960_FMwebp_QL65_.jpg)
iPhone Charger [Apple MFi Certified] 3FT, 3Pack USB A to Lightning Cable Braided Fast Charging Apple Cord Compatible with iPhone 14 13 12 11 Pro Max XS XR X 8 7 6 5 Plus iPad/iPod/AirPods

2Pack 10ft iPhone Charger 90 Degree Lightning Cable Right Angle Long USB Charging Cord Compatible with Apple iPhone 14 13 12 11 Pro Max XS XR X 8 7 6 5 Plus iPad iPod

Spigen Case for iPhone 15, iPhone 14, and iPhone 13, Ultra Hybrid MagFit Designed for Apple iPhone 15/14/13 - Crystal Clear

Wireless Charging Case for AirPods Pro 1st / 2nd Gen with Type-C Charging Port, Compatible with AirPod Pro 2nd Generation Replacement Case, with Blue-Tooth Sync Button, No Earbuds

Cleaner Kit for Airpods Pro 1 2 3 Multi-Function Cleaning Pen with Soft Brush Flocking Sponge for Bluetooth Earphones Case Cleaning Tools White

Apple AirPods Pro 2 Wireless Earbuds, Bluetooth Headphones, Active Noise Cancellation, Transparency, Personalized Spatial Audio, High-Fidelity Sound, H2 Chip, USB-C Charging

Wireless Charger, 3 in 1 Charging Station, Fast Charging Station Foldable Charging Stand, Wireless Charging Station for Multiple Devices, Compatible with lPhone 17/16/15/14/13 Pro Max Airpods Watch

Magnetic Wireless Charger for iPhone: Fodable 3 in 1 Charging Station for Multiple Apple Devices - Travel Charging Pad Dock for Apple Watch iPhone 16 15 14 13 12 Pro Max Plus & Airpod Global Recycled Standard

2 Pack Magnetic Wireless Charger 15W Fast Mag-Safe Charger Stand Compatible with iPhone 16/15/14/13/12 Series Wireless Charging Pad for AirPods 3/2/Pro 2/Pro White Portable Mag Safe Kickstand

Wireless Earbuds, 2025 Bluetooth 5.4 Bass Stereo Headphones with 4 ENC Mic, 48H Playback Ear Buds with Charging Case LED Display,Sport Earphones IPX7 Waterproof for Phone, Android, Pad, White
![Spigen Spigen Tempered Glass Screen Protector [GlasTR EZ FIT] designed for Nintendo Switch 2 (2025) - 2 Pack](https://m.media-amazon.com/images/I/61L0hIGSbYL._AC_UL1500_FMwebp_QL65_.jpg)
Spigen Spigen Tempered Glass Screen Protector [GlasTR EZ FIT] designed for Nintendo Switch 2 (2025) - 2 Pack

Anker USB C Charger Cable (6ft 100W, 2Pack), USB 2.0 Type C Fast Charging Cable for iPhone 15 / 15Pro / 15Plus / 15ProMax MacBook Pro 2020, iPad Pro 2020, iPad Air 4, Samsung Galaxy S23+/S23 Ultra ClimatePartner certified
![Anker USB C Cable, [2-Pack, 6 ft] Type C Charger Premium Nylon USB Cable, USB A to Type C Charging Cable Fast Charge for Samsung Galaxy S10 S10+ / Note 8, LG V20 and Other USB C Charger (Black)](https://m.media-amazon.com/images/I/71N7xhCJnoL._AC_UL960_FMwebp_QL65_.jpg)
Anker USB C Cable, [2-Pack, 6 ft] Type C Charger Premium Nylon USB Cable, USB A to Type C Charging Cable Fast Charge for Samsung Galaxy S10 S10+ / Note 8, LG V20 and Other USB C Charger (Black)

SanDisk 256GB Ultra microSDXC UHS-I Memory Card with Adapter - Up to 150MB/s, C10, U1, Full HD, A1, MicroSD Card - SDSQUAC-256G-GN6MA

SanDisk Ultra Flair USB 3.0 64GB Flash Drive High Performance up to 150MB/s (SDCZ73-064G-G46)

SanDisk Ultra 3D NAND 4TB Internal SSD - SATA III 6 Gb/s, 2.5 Inch /7 mm, Up to 560 MB/s - SDSSDH3-4T00-G26

SanDisk Ultra Dual Drive Luxe USB 3.1 Type-C 32GB Flash Drive for Acer Convertible 2-in-1 Laptops Aspire 1, Chromebook Spin 713 (SDDDC4-032G-G46) Gen1 Bundle with (1) Everything But Stromboli Lanyard

Wireless Charging Case for AirPods Pro 1st / 2nd Gen with Type-C Charging Port, Compatible with AirPod Pro 2nd Generation Replacement Case, with Blue-Tooth Sync Button, No Earbuds

Cleaner Kit for Airpods Pro 1 2 3 Multi-Function Cleaning Pen with Soft Brush Flocking Sponge for Bluetooth Earphones Case Cleaning Tools White

Magnetic Wireless Charger for iPhone - 3 in 1 Mag-Safe Charging Station for Multiple Devices Apple - Charger Stand Dock for Apple Watch iPhone 16 15 14 13 12 Pro Max Plus Airpods

4-in-1 Wireless Magnetic Power Bank 10800mAh Portable Charger with iWatch Charger, QC4.0+20W PD Fast Charging USB C Battery Pack for Magsafe, iPhone 16/15/14/13/12 Series, Apple Watch etc. (White)




