Uploaded August 2021 | Updated November 2026, 37 minutes ago
In this video, we will learn how to insert blank or empty rows using the excel new calculation engine with using the formula in Microsoft Excel. We might need to insert blank rows after data is entered. This dynamic arrays formula will be helpful in exploring the easy solution to add empty rows after every data.
โฑ Time Stamp
00:00 Intro
00:20 Understanding the dataset & building the solution
01:00 Doing the Math
05:50 Removing the formula
06:30 End Screen
--------------------------------------------------------------
๐ Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
๐ฃ Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family ๐จโ๐ฉโ๐งโ๐ฆ so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
๐ ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
๐๐ป Like Facebook Page :
facebook.com/ExcelExciting
๐ฅJoin The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
VLOOKUP Data From Multiple Worksheets [Excel for mac & windows]
youtu.be/ROym3e-S4OQ
Trick to Create A Data Entry Table In Power Query for Excel
youtu.be/bHPrRbcw6f0
Change Multiple Value using Array Method [Excel for Mac & Windows]
youtu.be/c8d3xx8KVl8
Extract Number & Text from a Cell in Excel | Solution 02 by Power Query
youtu.be/iei5rMstlJ0
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks
In this video, we will learn how to insert blank or empty rows using the excel new calculation engine with using the formula in Microsoft Excel. We might need to insert blank rows after data is entered. This dynamic arrays formula will be helpful in exploring the easy solution to add empty rows after every data.
โฑ Time Stamp
00:00 Intro
00:20 Understanding the dataset & building the solution
01:00 Doing the Math
05:50 Removing the formula
06:30 End Screen
--------------------------------------------------------------
๐ Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
๐ฃ Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family ๐จโ๐ฉโ๐งโ๐ฆ so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
๐ ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
๐๐ป Like Facebook Page :
facebook.com/ExcelExciting
๐ฅJoin The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
VLOOKUP Data From Multiple Worksheets [Excel for mac & windows]
youtu.be/ROym3e-S4OQ
Trick to Create A Data Entry Table In Power Query for Excel
youtu.be/bHPrRbcw6f0
Change Multiple Value using Array Method [Excel for Mac & Windows]
youtu.be/c8d3xx8KVl8
Extract Number & Text from a Cell in Excel | Solution 02 by Power Query
youtu.be/iei5rMstlJ0
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks









![How to Leave or Exit an Organization in Microsoft Teams
We someone invites us from their organization on Microsoft Team, we become the guest of their organization. However, in this video we will learn how to Leave or Exit the organization in Microsoft Teams for personal/work/school accounts
00:00 Introduction
00:17 About Guest Accounts
00:57 Leave Organization for Work/School Accounts
01:45 Leave Organization for Personal Accounts
03:40 End Screen
๐ https://myapps.microsoft.com
Buy Microsoft365 (Affiliate Link):
https://click.linksynergy.com/link?id=kTx0J25Zvjs&offerid=780606.17637808982&type=2&murl=https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fp%2Fmicrosoft-365-family%2FCFQ7TTC0K5DM%2F007P
๐ https://www.ExcelExciting.com
๐ https://excelexciting.com/forums/
Connect to our forums feel free to ask to queries & answer them.
๐๐ป Like Facebook Page - https://www.facebook.com/ExcelExciting/
๐ฅ Join the Facebook Group - https://www.facebook.com/groups/ExcelExciting/
***********************************************************
You can check the following videos ๐บ as well
Extract Multiple Matching Records: https://youtu.be/pTVxxaZQx24
Learn how to use Microsoft Flow / Power Automate: https://youtu.be/HQyxnPYW9Jc
Create Organizational & Business Flowcharts Linked to Excel
https://youtu.be/Cor1mixgotY
Change Multiple Value using Array Method [Excel for Mac & Windows]
https://youtu.be/c8d3xx8KVl8
***********************************************************
#MicrosoftTeams #TeamsExitOrganization #TeamsLeaveOrganization #FarazShaikh #ExcelExciting #MicrosoftCreators #TeamsTips #ProductivityHack #MadeWithCamtasia #TeamsForMac #TeamsForWindows How to Leave or Exit an Organization in Microsoft Teams](https://i.ytimg.com/vi/LNJb9Jj_PYI/mqdefault.jpg)
