How to find format in Excel | Excel Practice Case #16 إتعلم حيل إكسل مع دكسلو 🇹🇳

How to find format in Excel | Excel Practice Case #16 إتعلم حيل إكسل مع دكسلو 🇹🇳
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Excel’s Find and Replace features can find and/or replace formatting in addition to text and information. Use the Find and Replace Formatting option when you want to change all instances of a particular formatting choice at once.

In this video we explore how to use this feature.

The following steps help you make understand how this works:

Step 1: Go to Home Tab then Editing group then Find and select then Find or simply hit shortcut combo Ctrl+F

Step 2: In the dialogue box click options button and additional options will be enabled.

Step 3: Just at the right of Find what field you have preview box and on the right of it you can find format button. Click on the downward pointing arrow

Step 4: If you already have a cell that contains the format that you want to include in find results then click choose format from cell. The dialogue box will disappear and cursor will change to dropper. Click on the cell from which you want to inherit the formatting. Once clicked, find dialogue reappears with preview box displaying the formatting inherited.

In case if you do not have formatting in any cell then you can specify your own by clicking format button itself instead of clicking drop down arrow.

Step 5: Add in the text, number or value you want to find within those cells that has format specified and click find all or find next button. If you left find what field empty then excel will find all such boxes that has specified formatting.

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗
║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣
╠╗║╚╝║║╠╗║╚╣║║║║║═╣
╚═╩══╩═╩═╩═╩╝╚╩═╩═╝
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🙋🏼‍♂️ PLEASE SUBSCRIBE
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✅ SUBSCRIBE HERE 👉 https://bit.ly/3cQUVZZ
🆓 DOWNLOAD the Exercise file and solution for this video here 👉

SUPPORT THE CHANNEL
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
👉Teespring Merch&Books 👉 https://bit.ly/3S1fa7n

Social Media / Contact us
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🤳Dexcelo on TikTok 👉 https://bit.ly/3JgslNU
📥 Business Inquiries 👉 [email protected]

📊 In this course you will learn how to:
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
- Use CTRL + F to open the find dialog box
- Use the option button to find formatting
- Find the cells that contains the formatting and select them all with the shortcut CTRL + A
- Find the SUMIF Function using the the find option
- Find the COUNTIF Function using the the find option

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✏️ Course developed by Dexcelo.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
0:00:00 - 0:01:23 Intro & Objectives
0:01:23 - 0:07:00 Using the find format option
0:07:00 - 0:11:30 Finding SUMIF and COUNTIF Functions
0:11:30 - 0:12:46 Objectives Summary

🔗 Useful Links
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Thank you for your support 🙏🙏🙏 !!!
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Tags
#excel #اكسل #learnexcel #excelshortcuts #exceltips #shortcuts #microsoftexcel #microsoft #exceltutorial