This is a trick in Excel that will definitely come in handy. I imagine a good many power users of Excel are familiar with this, but as it was new to me and pretty darn cool, I thought I’d share.
Situation: Working along in a spreadsheet and you have the format all set just they way you like it, columns and rows merged, widths perfectly adjusted and you want to insert a table of information. What you could do is just re-align everything that you just spent hours, if not days, getting just so. You could make new columns, new rows, adjusting everything.
New Solution: Create the table somewhere out of the way, either on another sheet in the workbook or somewhere way off to the side. Then copy the region and paste it as a “Picture Link”.
In Microsoft Excel 2007, after copying the desired region, on the Home tab of the ribbon, click the down arrow just below Paste and select As Picture > Paste Picture Link.
In Microsoft Excel 2003, copy as usual, then while holding shift, select Edit .. Paste Picture Link.
Now you have an image that you can move around on the spreadsheet anywhere. By using the Picture Link you can also update the “out-of-the-way” table and it will update in this picture, as well.
By the way, there is a “Camera” tool in Excel that will also allow you to do the same thing. Here’s a demo video of the Paste Picture Link tool.
HT: Joel (Father-in-law)