您可以增强Excel 电子表格(Excel spreadsheet)的外观,使其在视觉上对观众更具吸引力。增加趣味的最好方法是添加Excel 背景(Excel background)图像。本文将向您展示几种不同的方法。
您可以使用图像作为背景或纯色或图案(color or pattern)。在Excel中基本上可以通过三种方式执行此操作:使用页面布局(Page Layout)、调整图像的透明度和插入对象。
使用页面布局在 Excel 中添加 Excel 背景图像(Add an Excel Background Image In Excel Using Page Layout)
- 通过单击页面(Page Layout)布局打开页面布局功能区(page layout ribbon)。
- 查看背景的(Background)页面设置(Page Setup)部分。
- 单击背景(Background )并查看三个选项 - 来自文件、必应图像搜索(Bing Image Search)和OneDrive-Personal。
- 让我们从选择第一个选项从文件(From a file )开始,然后从您的计算机中选择一个图像。
- 选择一个图像,然后单击插入(Insert)。在下面的屏幕截图中查看您的数据背后选择的背景。
当您向下滚动页面或从一侧移动到另一侧时,图像会在背景中一遍又一遍地重复。
请注意您选择使用的Excel 背景图像。(Excel background)正如您在上图中看到的,由于图片上的区域很暗,文本也很暗,因此许多区域的数据都被遮挡了。
你有几个选择。您可以更改文本的颜色并将其加粗。
请记住,您的数据是电子表格的焦点。如果Excel 背景(Excel background)图像难以阅读,则说明您正在淡化您的信息的影响。
这是使用背景图像的缺点。您不希望背景干扰您的数据。
另一个缺点是当您缩小电子表格时数据会变小,而图像大小(image size)保持相对相同。
如果放大,文本会变大,图像保持相对稳定。
Excel 背景(Excel background)图像不会通过与数据保持成比例来跟随数据。现在让我们使用第二个选项来添加背景。
首先,通过转到Page Layout > Delete Background删除旧的。
第二个选项是从Bing Image Search插入图片。这通常是一个更好的选择,因为您的计算机上可能没有最好的图像。
由于此电子表格是关于不同国家/地区的财务信息,我们来搜索有关地图(maps)的图像。
默认情况下,搜索只会显示知识共享(Creative Commons)图像的结果。这些是已上传到网络以供共享的图像。
单击(Click)过滤器图标(filter icon)以仅查看图像Sizes、Types、Layouts和Colors并选择您喜欢的那些。
请参阅下面的屏幕截图,其中包含地图背景(map background)图片。我将黑色文本加粗以使其更加突出。
背景可能在视觉上很吸引人,但您必须小心它们不会使您的文本难以阅读。
使用此方法插入Excel 背景(Excel background)图像时,图像在打印时不显示。
因此,仅当您在演示文稿中向其他人展示电子表格并且想要吸引他们的注意力时,它才有用。
插入图片并调整其透明度(Insert a Picture & Adjust Its Transparency)
确保您位于“主页”(Home )选项卡上,然后转到“插入(Insert)” > “图片”。(Pictures.)
从您的计算机中选择(Choose)一个图像,然后单击(computer and click) 插入(Insert)。请注意(Notice),图片不是背景图片(background image)。它浮动在电子表格数据之上。
您可以在电子表格周围移动图像并通过将光标放在边缘的一个圆圈上并拖动它来调整其大小。
插入Excel 背景(Excel background)图像而不是添加背景的一个优点是您可以调整透明度。如果您的电子表格很长,此方法可能不是最方便的方法。
首先将图像推到电子表格的左上角(left-hand corner)。然后拖动图片,使其覆盖所有数据。
通过单击图像调整透明度。然后单击图片格式(Picture Format)选项卡 >透明度(Transparency)>图片透明度选项(Picture Transparency Options)。
为图片添加透明度(Add transparency),使其位于背景中,数据位于数据后面。将透明度(Transparency)选项上的切换开关向右移动,直到数据变得清晰且易于阅读。
此方法使用插入的图片,其行为类似于背景图像(background image),并在打印时显示。
在 Excel 中插入对象(Insert An Object In Excel)
如果您的电子表格很长,则以前的方法可能会很麻烦。插入对象可能是更好的选择。
- 首先单击功能区菜单中的插入(Insert)。
- 然后单击形状(Shapes)。形状(Shapes)旁边的下拉菜单将打开。
- 通过单击选择一个形状。我们将使用矩形。使用鼠标,将形状拖放到电子表格上以创建它。
- 然后通过拖动形状周围的圆形按钮来调整它的大小,直到它覆盖所有数据。右键单击形状并选择(shape and select) 格式化形状(Format Shape)。
- 从菜单中单击填充>(Fill)图片或纹理填充(Picture or texture fill)>插入(Insert )(在图片源(Picture source)下)。从文件、在线图片或图标中插入图片。
- 让我们选择一个纹理(Texture)填充。在格式形状(Format Shape)下,选择图片或纹理填充(Picture or texture fill)。然后单击“纹理(Texture)”旁边的下拉菜单并选择要使用的一个。
- 纹理将填充形状并覆盖您的数据。使用透明度(Transparency )旁边的滑块设置一个百分比,以显示纹理后面的数据。在下面的屏幕截图中,我们使用了 75 % transparency。
使用此方法时,打印时会显示背景。
向Excel 电子表格(Excel spreadsheet)添加背景时,请记住,能够清晰地读取数据至关重要。
调整背景的透明度并更改字体颜色或样式(color or style)可以提高数据的可读性,同时为您的电子表格添加一点活力。
您(Have)是否在添加Excel 背景(Excel background) 图像时遇到任何问题 -(image –)或者您有关于如何添加其他背景功能的提示?加入对话,并在下面的评论中告诉我们。
How to Add and Print Excel Background Images
You can enhance the appearance of your Excel spreadsheet and make it more visually attractive to an audience. The best way to spice it up is to add an Excel background image. This article will show you several different ways to do so.
You can use an image as a background or a solid color or pattern. There are basically three ways you can do this in Excel: using Page Layout, adjusting the transparency of an image and inserting an object.
Add an Excel Background Image In Excel Using Page Layout
- Open the page layout ribbon by clicking on Page Layout.
- Look under the Page Setup section for Background.
- Click on Background and see the three options – from a file, Bing Image Search, and OneDrive-Personal.
- Let’s start by selecting the first option From a file and choose an image from your computer.
- Select an image and then click Insert. See the background chosen behind your data in the screenshot below.
As you scroll down the page or as you move from side to side, the image repeats itself over and over in the background.
Be careful with the Excel background image you choose to use. As you can see in the image above, the data is obscured in many areas because the area on the picture is dark and so is the text.
You have a few options. You can change the color of the text and bold it.
Keep in mind that your data is the focal point of your spreadsheet. If the Excel background image makes it hard to read, you are diluting the impact of your information.
This is a downside of using background images. You don’t want the background to interfere with your data.
Another disadvantage is the data gets smaller when you zoom out on your spreadsheet while the image size stays relatively the same.
If you zoom in, the text gets larger, and the image remains relatively stable.
The Excel background image does not follow the data by staying proportional to it. Let’s use the second option now to add a background.
First, delete the old one by going to Page Layout > Delete Background.
The second option is to insert a picture from a Bing Image Search. This is often a better option because you might not have the best image on your computer.
Since this spreadsheet is about financial information in different countries, let’s search for images about maps.
By default, the search will only bring up results for Creative Commons images. These are images that have been uploaded to the web to be shared.
Click on the filter icon to only see the image Sizes, Types, Layouts, and Colors and select the ones you prefer.
See the screenshot below with a picture of a map background. I bolded the black text to make it stand out more.
Backgrounds can be visually appealing, but you must be careful that they don’t make your text unreadable.
When you insert an Excel background image using this method, the image does not show up when printed.
It is therefore only useful when you are showing your spreadsheet to others in a presentation and you want to grab their attention.
Insert a Picture & Adjust Its Transparency
Make sure you are on the Home tab and go to Insert > Pictures.
Choose an image from your computer and click Insert. Notice that the picture is not a background image. It is floating on top of the spreadsheet data.
You can move the image around the spreadsheet and resize it by putting your cursor on one of the circles on the edges and dragging it.
An advantage of inserting an Excel background image rather than adding a background is that you can adjust the transparency. If your spreadsheet is very long, this method might not be the most convenient method.
Start by pushing the image to the top left-hand corner of your spreadsheet. Then drag the picture so that it covers all the data.
Adjust the transparency by clicking on the image. Then click on Picture Format tab > Transparency > Picture Transparency Options.
Add transparency to the picture so that it is sitting in the background and the data is behind the data. Move the toggle on the Transparency option to the right until the data becomes clear and can be easily read.
This method uses an inserted picture that behaves like a background image and will show up when printed.
Insert An Object In Excel
If your spreadsheet is very long, the previous method could be cumbersome. Inserting an object might be a better option.
- Start by clicking Insert from the ribbon menu.
- Then click Shapes. The drop-down menu next to Shapes will open.
- Select a shape by clicking on it. We will use a rectangular shape. Using your mouse, drop the shape on your spreadsheet to create it.
- Then resize it by dragging the circular buttons around the shape until it covers all your data. Right-click on the shape and select Format Shape.
- Click Fill from the menu > Picture or texture fill > Insert (under Picture source). Insert a picture from a file, online pictures, or from icons.
- Let’s choose a Texture fill. Under the Format Shape, select Picture or texture fill. Then click the drop-down menu next to Texture and choose one to use.
- The texture will fill the shape and cover your data. Use the slider next to Transparency to set a percentage that allows your data behind the texture to show. In the screenshot below, we used 75% transparency.
When you use this method, the background will show up when you print.
When adding a background to an Excel spreadsheet, keep in mind that being able to read your data clearly is vital.
Adjusting the transparency of the background and changing the font color or style can improve the readability of your data while adding a little pizzazz to your spreadsheet.
Have you had any trouble adding an Excel background image – or perhaps you have a tip on how to add other background features? Join the conversation and let us know in the comments below.