Excel 2019: Line Up Dashboard Sections with Different Column Widths
June 05, 2019 - by Bill Jelen
If you are anything like me, you often need to fit a lot of data into a small area in a dashboard. What if columns in one dashboard tile don‘t line up with columns in another tile? Using a linked picture will solve the problem. In the figure below, the report in A1:M9 requires 13 columns. But the report in Rows 11:13 needs that same space to be two columns. I am never one to recommend merged cells, so let‘s not broach that evil topic.
Instead, go to another section of the workbook and build the report tile. Copy the cells that encompass the tile.
Select where you want the tile to appear. On the Home tab, click on the lower half of the Paste dropdown to open the paste options. The last icon is Paste Picture Link. Click that icon. A live picture of the other cells appears.
Title Photo: rawpixel at Unsplash.com