If you are looking for the procedures to use Excel objects to create an art portfolio easily, then this article will be helpful for you. So, let’s start with the main article to know the detailed steps of doing this task.
Download Workbook
What Does Inserting Objects in Excel Mean?
Inserting objects in Excel means that Excel actually stores these objects (PDF files, Word documents, or images in bitmap format in the actual spreadsheet itself). This can be useful, if you want to create a mini-database to store some of the objects listed above, using Excel. Since the object is actually embedded in the actual spreadsheet and can be opened from there.
3 Steps to Use Excel Objects to Create an Art Portfolio
Suppose, an artist has a portfolio of eight artworks. He usually sends these artworks to galleries, when he applies for exhibition space. Usually, the galleries he applies to, require the name of the artwork, a description of the artwork, the type of art it is (traditional, digital, mixed media), and an image/pdf of the artwork itself. He has decided to use Excel to create an art portfolio to send to galleries.
He has an Excel Table set up already, as shown below in the picture of the source data. In this example, we are going to embed the artworks as objects in the form of PDF files in the Actual Artwork column.
We have used Microsoft Excel 365 version for creating this article. However, you can use any other version at your convenience.
Step-01: Increasing Row Height to Use Excel Objects to Create an Art Portfolio
Firstly, we will increase the row height of the entire table.
- Select the dataset and then go to the Home tab >> Cells group >> Format dropdown >> Row Height.
Afterward, you will get the Row Height wizard.
- Select the Row height as 45 and press OK.
In this way, the row height of this dataset will be changed like the following figure.
Step-02: Inserting Excel Objects in Excel
In this step, we will insert the objects in the Actual Artwork column.
Here, we have all of our PDF files containing art in the Art Collection folder.
- Select cell E4, and then go to the Insert tab >> Text group >> Object.
Later, the Object dialog box will open up.
We are going to select the Create from File tab since our pdf files have already been created.
- Click on Browse.
- Browse to the folder containing the already made pdf
- Click on the file name which is related to our first artwork (here, we have selected ForestintheMidst)
- Press Insert.
Afterward, the file path will be shown in the File name box.
- Check the option Display as icon.
- Press OK.
After that, the PDF object icon will appear in cell E4.
- Adjust the icon to the cell by dragging the indicated symbol.
Then, you will have the following adjusted object.
Similarly, enter the artwork objects for the rest of the art in the remaining cells.
Step-03: Formatting and Opening Created Object of an Art Portfolio in Excel
Here, we will do some formatting and show the way to display the artworks from these objects.
If the inserted objects are not fitting the cells then you can follow this process.
- Select the object of cell E4 and right-click on it and then select Format Object from the options.
Later, the Format Object wizard will appear.
- Click on the option Move and size with cells and then press OK.
In this way, we have fitted the first object in the first cell.
- Follow the same procedure for the rest of the objects of the rest of the cells.
- You can either double-click the object to open the PDF containing the artwork, or you can right-click the object, and click on the dropdown symbol of PDF Object.
- Later, choose the Open option among other options.
This opens the artwork in a PDF reader.
After opening the document you can easily view your artwork.
Practice Section
For doing practice, we have added a Practice portion on each sheet on the right portion.
Conclusion
In this article, we tried to show the steps to use Excel objects to create an art portfolio. Embedding objects such as Adobe PDF files, Word documents, and PowerPoint files in Excel spreadsheets is a very useful feature. In the above example, there is now no need to send the files separately as attachments because all the artworks are already in the Excel file. So, the artist can just send his portfolio by sending only the Excel spreadsheet, which is neatly organized in Table format with columns containing all the needed data. You can visit our site Exceldemy for more Excel-related articles.