February 23, 2017
Hi fellow Excel Addict,
Today's 'Excel in Minutes' tip will show you how to do something you may not have thought possible with Excel. I'm going to show you how to 'Create a Linked Picture of a Range of Cells'. This one is really cool.
And if you missed my 'Excel in Seconds' newsletter on Tuesday, I showed how to 'Turn Off AutoRecover For Individual Workbooks'. You can read that tip here.
I hope you'll have a great weekend and keep on Excelling,
Keep on Excelling,
Francis Hayes (The Excel Addict)
If you missed my last newsletter, you can click here to view it online.
If you have a favourite quote, send it to me and I may post it in my newsletter.
Create a Linked Picture of a Range of Cells
One of the almost-magical features of Excel that few users have discovered is 'linked pictures'. Yes, you can paste a 'live' picture of a range of cells from one part of a worksheet into another sheet or even into another workbook. Can you just imagine all the cool new ways you can use this?
There are a couple of ways you can do this:
Option 1: Paste Linked Picture
1) Select the cells you want to capture an image of and click Copy (CTRL+C);
2) Then select the cell where you want to paste the picture link and, (a) from the Home tab, click the small arrow below Paste and click the Linked Picture button, or (b) right-click the cell where you want to paste the image, point to Paste Special..., then click the Linked Picture button;
Option 2: Using the Camera Tool
Maybe you have never seen Excel's Camera tool. That's because it's nowhere to be found on the Ribbon. To be able to use it you will have to add it to your Quick Access Toolbar (QAT).
How to capture a linked picture of a range of cells using the Camera
1) Select a cell or range you want to capture;
2) Click the Camera tool on the QAT. You'll notice that your mouse pointer changes to a crosshair;
3) At this point, wherever you point to and click is where the top left corner of the picture will be pasted. You can paste the picture into the same sheet, another sheet or another workbook. Since the captured image has been copied to the Windows clipboard, you can even paste it to other applications such as an image editing program or even your email. (Note: Using regular Copy and Paste allows you to paste images of Excel ranges to other applications as well).
Once you have pasted the picture, you can then click and drag to reposition it anywhere on the sheet and resize it if you like. You can even add picture formatting such as a shadows, borders, etc...
Notice that when the picture is selected, a reference formula is shown in the Formula Bar. Since this is a 'linked' picture, it will automatically update to reflect any changes made in that referenced range.
Are you starting to get some new ideas for using this?
If you want to change a linked picture to a static 'snapshot', select the image and delete its reference in the formula bar. This will convert the 'live' picture to a static one.
Alternatively you can paste a static image by using the Picture button rather than the Linked Picture button.
Here are a few things you should keep in mind when using linked pictures
|"Spreadsheets Tips From An
Excel Addict" is a weekly publication of TheExcelAddict.com.
Copyright Francis J. Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630