Dynamic Screenshot
๐ธ Using the Camera Tool for Dynamic Screenshots in
Excel
๐ง Process Flow: Enable and Use the Camera Tool
1. Go to: File > Options > Excel Options > Quick Access Toolbar.2. Under 'Choose commands from', select **All Commands**.3. Find **Camera** in the list.4. Click **Add >>** to move it to the right side window.5. Click **OK**.
๐ You’ve now added the Camera tool to use for
dynamic screenshots.
✅ Step 2: Take a Dynamic Screenshot
Example Dataset (Range A1:B3):
| Item | Sales |
|---------|-------|
| Apple | 100 |
| Banana | 150 |
| Orange | 120 |
1. Select the cell range you want to capture, e.g., A1:B3.
2. Click the **Camera** icon on the Quick Access Toolbar.
3. Your cursor changes to a crosshair — click anywhere on the sheet to place
the image.
4. The snapshot will be linked to your selected data and update automatically.
๐ How It Works Dynamically:
If you update any values in the source range, the snapshot
updates instantly.
๐ Customization:
- Resize the snapshot like a normal image.
- Format it using Picture Tools.
- Place it in dashboards or summary sheets for dynamic visuals.
๐งพ Summary:
| Step | Action |
|------|--------|
| 1 | File > Options > Quick
Access Toolbar > All Commands > Camera > Add |
| 2 | Select the range |
| 3 | Click Camera icon |
| 4 | Place the snapshot |
| 5 | Data changes reflect dynamically
|