MrExcel’s Learn Excel #984 – Snaking Columns
May 1st, 2009 learn accounting
You have a really long data set with all of the data in column A. When you print, you will be wasting 75% of the horizontal white space on the page. Is there any way to have the column A data snake through the other columns? It would be nice if there was a checkbox for this, but Episode 984 resorts to using INDEX, ROW and COLUMN!
This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Duration : 0:4:24
ExcelIsFun 01May09
Dear Bill Mr Excel …
Dear Bill Mr Excel Jelen,
That is an awesome trick! It never ceases to amaze me what the INDEX function can do!
–excelisfun
Leave a Reply