Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
You can change a table's appearance by copying and pasting table styles and table cell styles. For example, if we wanted to borrow the table style used for a group of cells in our table called Utility Costs by Type and paste the style into a group of cells in our Utility Costs by Month, we first select the cell or group of cells containing the style we want to copy. Let's click on the year 2007 in our Utility Costs by Type table and now to copy the style, click Format and choose Copy Style. Notice there is a keyboard shortcut for this as well. With it copied now we have to select the cell or group of cells that we want to copy the style to. In this case, both years 2007 and 2008 in our Utility Costs by Month table and we click Format and paste the Style.
So we are not changing the data even though the data is the same. We are just copying the style from one cell to another group of cells in a different table. Now we also have the ability to copy the style for an entire table and apply it to another table, even if it's in another spreadsheet that doesn't have that style available. For example, let's select our Utility Costs by Type table and copy the style, which happens to be called Utility Costs. It's a custom style. We click Format and choose Copy Style.
Now we are going to switch to another file. You may want to open this one up. It's called Savings Calculator. Here you can see it's got a very bland style. When we select the table, click Format and choose Paste Style, the style that existed in our other spreadsheet that does not exist here has just been applied to our brand new table in this spreadsheet. Another thing you can do when copying tables is choose whether or not you want to keep the style that exists in the table, or have the default style from the destination spreadsheet applied.
Let's move back to our Energy Savings Plan and let's say we want to copy this table called Utility Costs by Type to another spreadsheet. With it selected already we can click Edit this time and choose Copy. Now to use this table in our other spreadsheet, we'll switch to it. Let's go to the Energy Saving Plan 09 spreadsheet and click Edit and choose Paste. Notice that Paste and Match Style is what we would use to match the style of our current spreadsheet. So to keep the same style and leave this style behind from the previous spreadsheet we choose Match Style.
So because you have the ability to copy and paste table styles, you'll never have to recreate a style from scratch.
Get unlimited access to all courses for just $25/month.Become a member
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.