How to Copy an Excel formula across thousands of rows with gaps instantly  #shorts
Channel: Efficiency 365 by Dr Nitin
Date: 2022-02-06

The most important benefit of using Tables in Excel - formula auto-copy. 
Just type the formula and press Enter.
Blank cells are managed automatically.
You can add or edit the formula in any cell.

Try it out and share it with your friends.

Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster

https://s.efficiency365.com/bk

Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
https://hi.switchy.io/mms

Udemy Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - https://hi.switchy.io/22B1
Excel to Power BI - https://swiy.io/pivotsh

Learn more from 1000+ blog articles by Dr Nitin Paranjape 
Efficiency 365 blog: https://efficiency365.com/blog

LinkedIn : https://www.linkedin.com/in/nitinparanjape/
Twitter : https://twitter.com/drnitinp

Production
--------------------
Music and Effects: https://www.epidemicsound.com 
Created using Camtasia: https://www.techsmith.com/video-editor
AI based captions: https://videoindexer.ai (Microsoft service)