(#Excel #Tips For You)| Day - 10|Topic :Select cells with special characteristics by using shortcuts

(#Excel #Tips For You)| Day - 10|Topic :Select cells with special characteristics by using shortcuts Excel Tips For You)| Day - 8|Topic:Move within a selection by using shortcutkeys #Excel, Short, Shortcut keys, #Keysforaccountant, Accounting keys, Excel accountant, Excel formula,#Allformula, For excel, Enter Data By Using Shortcut Keys, Entering, Data, Excel tips, Tally tips, Tally tricks, Excel super, H look up, V look up, All shortcut keys, All magic formula, Taly, Ms office, Sheet,gst excel,ca sakshi sharma,ca excel keys,keys for accountant, accountant keys excel,excel classes day 5,daily updates,excel tips by CA (Excel Tips For You)| Day - 7|Topic : Insert, delete, and copy a selection,(#Excel #Tips For You)| Day - 9| Topic : Select chart items by using #shortcutkeys *Teacher By Passion।।आपको रखे आगे।🎓* 📊 *_[ Excel Tips For You ]_* 📈 📍 *DAY - 10* 📍 ************************************ 🌾 *Topic :Select cells with special characteristics by using shortcut keys* *👉👉 To 👉👉 Press* 👉 Select the current region around the active cell (the current region is an area enclosed by blank rows and blank columns) *: CTRL+SHIFT+** *(ASTERISK)* 👉 Select the current array, which is the array that the active cell belongs to : *CTRL+/* 👉 Select all cells with comments : *CTRL+SHIFT+O (the letter O)* 👉 Select cells whose contents are different from the comparison cell in each row (for each row, the comparison cell is in the same column as the active cell) : *CTRL+\* 👉 Select cells whose contents are different from the comparison cell in each column (for each column, the comparison cell is in the same row as the active cell) : *CTRL+SHIFT+|* 👉 Select only cells that are directly referred to by formulas in the selection : *CTRL+[* 👉 Select all cells that are directly or indirectly referred to by formulas in the selection : *CTRL+SHIFT+{* 👉 Select only cells with formulas that refer directly to the active cell : *CTRL+]* 👉 Select all cells with formulas that refer directly or indirectly to the active cell : *CTRL+SHIFT+}* 👉 Select only visible cells in the current selection : *ALT+* 🌺🌺🌺🌺🌺🌺🌺🌺🌺🌺🌺🌺🌺🌺 *~''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''~* *Teacher By Passion।।आपको रखे आगे।🎓* *😊सब्सक्राइब करे और 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