![I want to combine data from multiple sheets into one place in Excel! The hidden camera function solves the problem[اختراق العمل اليوم]| LifehackerJapan](https://media.loom-app.com/loom/2024/03/26/91d8149c-50ac-4987-90bf-cbe7e5948afe/original.png?w=1280&h=630&f=jpg)
Screenshot in ExcelIt's easy to take pictures.
But if you paste it into a sheet of paper and change that data,Do you know how the image data is also updated automatically?
Excel's hidden camera feature allows you to create images linked to your data.Useful when you want to collect data from multiple sheets in one placeHe is. Here's how.
notice:“This is Excel”Insert“Unpaid invoice”appearance” in “Screenshot“Not a feature. The screenshot function allows you to take a picture of the screen, but it cannot be linked to data like photos taken with the camera function.
[يوصى باختراق العمل اليوم لهؤلاء الأشخاص! ]
- People who often take screenshots in Excel
- Those who deal with many numbers in Excel
Hack of the Day: How to use screenshots to manage multiple data in one place
How to enable the camera function in Excel
The camera feature in Excel is a hidden feature.
Start Excel and follow the steps below.
- Click File in the Excel menu bar.house“go to the(Behind the scenes showDisplays).
- Under the left sidebar, clickoptionIn Excel Options, selectQuick access toolbar“Settings.
- 「Select the command“From drop-down menu”The commands are not on the tape“.
- 「The commands are not on the tape“from”camera“.
- Between the Camera and Quick Access Toolbar boxes.addition” button.
- When you open a spreadsheet, you'll see “cameraThe button is displayed.
Alternatively, you can click the small down arrow in the Quick Access Toolbar, choose More commands from the menu that appears, and then follow the same steps above.
How to use the camera function in Excel
Once you add the camera, you can take screenshots of your data.
- Open the spreadsheet containing the data you want to screenshot and paste.
- Select the data range or chart and click the camera button on the Quick Access Toolbar.
- Open the worksheet where you want to paste the data and select the location where you want to paste it.
- The cursor will change to a thin crosshair, so drag and release the crosshair to paste the data.
Since I'm pasting it as an image, use the formatting options on the Image tab to do thisYou can customize the display of your data.
thisThe great thing about the camera feature is that you can link two cards, not just a screenshot.By the way. This feature saves you time and eliminates the need to review the original data again and again.
Read more business hacking articles today
In today's Business Hack series, you can get your work done quickly and efficiently! We provide shortcuts, uses and ideas for tools, applications and operating system.
![How to always display important rows in Excel | Save time![اختراق العمل اليوم]| Lifehacker Japan](https://media.loom-app.com/loom/2024/02/08/562b7ed5-a1d9-4427-b135-79fc1409b691/original.png?w=240&h=180&f=jpg)
How to always display important rows in Excel | Save time![اختراق العمل اليوم]| Lifehacker Japan
![I knew? How to freely add new fonts to Google Docs[اختراق العمل اليوم]| LifehackerJapan](https://media.loom-app.com/loom/2024/03/21/b52692b6-ae40-458c-8445-af1b2063ee09/original.png?w=240&h=180&f=jpg)
I knew? How to freely add new fonts to Google Docs[اختراق العمل اليوم]| LifehackerJapan
“Travel maven. Beer expert. Subtly charming alcohol fan. Internet junkie. Avid bacon scholar.”
More Stories
“iPhone14 Pro” vs. “High-end Compact Digital Camera”.Comparison of photos taken in the mountains |. LifehackerJapan
Ubuntu 24.04 LTS – PC Watch
A research team from Showa University and other institutions has concluded a joint research agreement with the Japan Aerospace Exploration Agency to start space medical science research! Showa University