(#Excel #Tips For You)| Day - 11। Topic :Move and scroll on a worksheet or workbook ।Excel

(#Excel #Tips For You)| Day - 11। Topic :Move and scroll on a worksheet or workbook ।Excel #shortcutkeys *----------------------------------------* 📊 *_[ Excel Tips For You ]_* 📈 📍 *DAY - 11* 📍 ************************************ 🌾 *Topic : Move and scroll on a worksheet or workbook by using shortcut keys* *👉👉 To 👉👉 Press* 👉 Move one cell in a given direction Arrow key Move to the edge of the current data region : *CTRL+ arrow key* 👉 Move between unlocked cells on a protected worksheet TAB Move to the beginning of the row : *HOME* 👉 Move to the beginning of the worksheet : *CTRL+HOME* 👉 Move to the last cell on the worksheet, which is the cell at the intersection of the right-most used column and the bottom-most used row (in the lower-right corner); cell opposite the Home cell, which is typically A1 : *CTRL+END* 👉 Move down one screen : *PAGE DOWN* 👉 Move up one screen : *PAGE UP* 👉 Move one screen to the right : *ALT+PAGE DOWN* 👉 Move one screen to the left : *ALT+PAGE UP* 👉 Move to the next sheet in the workbook CTRL+PAGE DOWN 👉 Move to the previous sheet in the workbook : *CTRL+PAGE UP* 👉 Move to the next workbook or window : *CTRL+F6 or CTRL+TAB* 👉 Move to the previous workbook or window : *CTRL+SHIFT+F6 or CTRL+SHIFT+TAB* 👉 Move to the next pane : *F6* 👉 Move to the previous pane : *SHIFT+F6* 👉 Scroll to display the active cell : *CTRL+BACKSPACE* *~≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈~* *Teacher By Passion।।आपको रखे आगे।🎓* *🍁Excel's short tricks,🌺* *(👉🏻EXCEL All Days Video classes👈🏻)* *↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓* *🍁All Days Classes Playlist* *~↓↓↓↓↓↓↓↓↓↓↓↓👇🏻 Series👇🏻↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓~* *🍁EXCEL Tips For You | EXCEL For Accountant: https://www.youtube.com/playlist?list=PLJhUBdmBIuJ1kBtgHX1J21rAbItPROnyP🍭* *~'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''~* *😊सब्सक्राइब करे और UPDATE रहे।* 👇👇👇👇👇 *https://www.youtube.com/c/TeacherByPassion* ☝️☝️👆👆☝️☝️ *"""""""""""""""""""""""""""""""""""""""""""""""""""""""""* Video Gear 👇🏻👇🏻👇🏻👇🏻👇🏻👇🏻👇🏻👇🏻👇🏻👇🏻👇🏻 My mic :- https://amzn.to/2lvwgMA My camera (cheapest price Video quality higher) :- https://amzn.to/2InZypj Lights used in Video :- https://amzn.to/2ImRoh3 Mobile /camera stand :-https://amzn.to/2lvmOJ1 My mobile phone {best camera phone} :- https://amzn.to/2tyWgdv Laptop :- https://amzn.to/2yCY4YW Mobile Telescope:- https://amzn.to/2ziXM9Y _ GST BOOK {FOR PRACTIONER} :- https://amzn.to/2MQWJR8 GST BOOK FOR ALL {BE THE EXPERT IN GST} :- https://amzn.to/2tFkXFx _ CA STUDENTS SPECIAL 💥 IPCC STUDENTS:- 👉🏻 Best book for A/c's subject :- 👉🏻 Self preparation of Law subject :- https://amzn.to/2m27m7P 👉🏻 COSTING & FINANCIAL MANAGEMENT :- refer you past year questions paper Download :- http://bit.ly/2BDMAm4 👉🏻 Taxtion :- please Go through with ICAI MODULE :- http://bit.ly/2QMpVhV 👉🏻 Advance Accounts:- past year questions papers:- http://bit.ly/2BB7jqF 👉🏻 Audit :- https://amzn.to/2KBAW2n /Or/ https://amzn.to/2lYh2jo 👉🏻 ITSM:- https://amzn.to/2lZ1oV6 ___ GST For Professionals & Businessman {हिंदी}: https://www.youtube.com/playlist?list=PLJhUBdmBIuJ2J-QZPa3iboL0MoEwqSAkT GST - AUDIT { Applicability, procedure & rules}: https://www.youtube.com/playlist?list=PLJhUBdmBIuJ2BkQckpHbPGgtRZZmUTgp3 Motivational & Lifestyle special VIDEOS: https://www.youtube.com/playlist?list=PLJhUBdmBIuJ0-i-ATb451D1lGxqbl1lBq Audit Videos (For CA IPCC & B.COM): https://www.youtube.com/playlist?list=PLJhUBdmBIuJ16W6j2T4zvtUL333Dr_smc COMPANY LAW {B.COM & CA,CS AND CMA}: https://www.youtube.com/playlist?list=PLJhUBdmBIuJ1rYwca0kb1Wwr9M1sQo2pv ================================================= Instagram Page :- http://bit.ly/2QJtrcO SUBSCRIBE FOR STAY UPDATED:- https://www.youtube.com/channel/UC-pFA9W0jwf4aHwTJu1aBqg Whatsapp group :- http://bit.ly/2BzNKPt Telegram chat group:- t.me/teacherbypassion Fb page :- http://bit.ly/2QJC4El Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair Use. Music credit:-https://youtu.be/-7YDBIGCXsY