MENU

Fun & Interesting

Dynamically insert blank rows between items in Excel | Make your analysis easier to read.

Excel Off The Grid 9,209 3 weeks ago
Video Not Working? Fix It Now

Sign up for our free Insiders program and get the example file: https://exceloffthegrid.com/insiders-signup/ File Reference for this video: 0254 Blank row between items ★ Want to automate Excel? Check out our training academy ★ https://exceloffthegrid.com/academy ★ About this video ★ In this video, we explore a technique to insert blank rows in any array or range. When faced with a sea of values, it can be difficult to see what's going on. This method helps to add some spacing and make everything easier to read. 0:00 Introduction to Inserting Blank Rows 0:28 Shaping the data 1:17 Building the formula 5:58 Apply to different scenarios 6:59 Wrap-up ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter: https://twitter.com/exceloffthegrid #MsExcel

Comment