BITS & BYTES: Using Excel's cameral feature is a snap

2013-07-17T09:45:00Z 2013-07-17T14:59:27Z BITS & BYTES: Using Excel's cameral feature is a snapApril Miller Cripliver Times Business Columnist nwitimes.com

Q: I use the Snipping Tool quite a bit on my Windows 7 computer. A friend told me he uses the Camera in Excel which has more features. Can you explain how to use Excel’s camera feature?

A: Excel allows you to capture "pictures" of your worksheets that you can use in other worksheets. This may sound odd, but it is quite helpful at times. You capture pictures by using the Camera tool. This tool is not available on the various Excel ribbons, so you need to add it to the Quick Access toolbar as follows:

1. Launch Excel.

2. Right-click on the Quick Access toolbar in the upper left of the screen.

3. Choose “Customize Quick Access Toolbar.”

4. Choose “All Commands” from the “Choose commands from…” pull-down.

5. Scroll to find Camera in the left pane of commands, select it, then click the Add button located between the two panes.

6. Click OK.

With the Camera tool in place on the Quick Access toolbar, follow these steps:

1. Select the cells you want to capture as a photo.

2. Click on the Camera tool (the one added to the Quick Access toolbar). The selected cells will be framed in “marching ants.”

3. Click in the cell where you want the top left-hand corner of the picture to appear. This can be on a different sheet or the same sheet of Excel. The picture is then inserted as a graphic.

Now you can manipulate the picture the same as you would any other graphic — stretch it, resize it, crop it, move it, or whatever. The really amazing thing, however, is that the picture is dynamic. This means that if you change the information in the original range (that you selected in Step 1), the information in the picture will change as well.

Opinions are solely the writer's. April Miller Cripliver, of Chesterton, has a doctorate in management information systems and is a computer hardware and software consultant. E-mail your computer questions to nwitimes@cripliver.com, and specify your operating system and other pertinent PC information.

Copyright 2014 nwitimes.com. All rights reserved. This material may not be published, broadcast, rewritten or redistributed.

activate-button-3
Follow The Times

Latest Local Offers

Featured Businesses

In This Issue

Professionals on the Move Banner
Get weekly ads via e-mail

Poll

Loading…

Should struggling small school districts merge with their neighbors?

View Results