Adding PDF files to Excel will make working with this spreadsheet tool much more efficient and professional. If you often have to work with spreadsheets or * .pdf files , this is one of the Excel tips you need to know.
Microsoft Excel for iOS Microsoft Excel for Android
Microsoft Office Excel is one of the most used and popular office tools today. The more we know how to use this spreadsheet software, the more efficient and smooth our work will become. To add PDF documents to Excel files , do the following:
Step 1 : Open the file you need to insert the PDF file. From the main interface, left-click on the Insert tab , select Object .
Step 2 : The Insert Object window appears as follows, doing respectively:
- Select the Create new item .
- Select the PDF reader software (in this article the writer is using Foxit Reader , if you are installing and using other software, such as Adobe Reader , Sumatra PDF Viewer ... then select the corresponding display of That application is in the category of Object type ), then OK to continue.
- You can also select the Display as icon option to display the Pdf file reader icon.
Step 3 : Windows window appears, find the location to save the PDF file to use, then left-click it, select Open .
Step 4 : Done, you will immediately see the selected PDF file displayed in your spreadsheet.
Customize PDF files in Excel
After successfully inserting the PDF file into the spreadsheet, you can do some quick actions with that file, such as:
- Change location: Left click the file, hold and drag it to a new location.
- Resize: You can also resize the file by left clicking on the gray squares, hold and drag to change it.
If you want to make more advanced changes, you can right-click on the PDF file you just inserted and select Format Object ...
Format AutoShape window appears, here, you can use the options available to manipulate PDF files inserted into Excel. As follows:
- Left-click the Properties tab , and choose one of the three options below, including:
- Move and resize cells - Move the position and resize it.
- Move but do not resize cells - Move and do not change the position of.
- Do not move or resize cells - Do not move or resize.
Select finished, click Ok to finish.
- Select to Size tab , we can change the size of the PDF file:
- Size and rotate : Change the length and width of the file (in the Height and Width).
- Scale : Rotate the file in different directions.
- If you feel the color of the file is not stable or will partially obscure the text, you can click the Colors and Lines tab , then change the opacity of the file at Transparency (change the percentage or drag the slider ). However, it should be noted, this operation only dims the background color of the file, but the icon and file size remain the same.
- In addition, if you left-click on the corresponding paint bucket icon right next to the PDF icon you can choose any color to pour and change the background color for the file to stand out, more impressive.
ATTENTION:
Users can also click directly on this PDF file to open it if desired.
That is all the instructions for computer users can add Pdf files to Excel as well as perform some operations, changes with this file in the process of working.
Video tutorial on adding PDF files into Excel spreadsheets