Worksheet background

When we make reports, the goal is for them to be both functional and beautiful. Their background can also contribute to the appearance of the worksheet in a positive way. It is a picture that is placed behind the tables, charts, and other elements of the report. If after hiding it, we also hide lines separating cells (Gridlines) reports will look like they were not created in Excel. But, more importantly, users will be able to easily find the necessary information.

Picturesque charts

o far, in several “recipes,” you can find out how to create and beautify the charts. This one will be about how to combine charts and images. First, in the case of a simple column column, you will see how to replace the columns with the image. Then we will add the picture as a background. Although it will not be about new features here, using some tricks will help you to make your reports more beautiful.

Cropping images

Once we have added an image to Excel, we will often change its dimensions immediately, which can be done manually or by setting the height and width. It happens that the added image contains some unnecessary details. In that case, we are cropping the image to highlight only those parts of the image that we want to see in the worksheet. In addition to simple cropping, Excel also offers several advanced options for cropping images (fitting into a desired frame) …