Paste Values is one of the many pasting options on the Paste Special menu. In the first example above, the blank cells have the default General format, and that is why there is no number formatting applied when we paste values.
When we paste values, any existing formatting in the paste range will NOT change. In the image above, the Scenario 1 column already contained both cell formatting (colors) and number formatting. Pasting values will not change any existing formatting that is applied to the cell/range. One common use is for scenario analysis where we want to “freeze” numbers that are results of formulas and place them in some blank cells.Īnother common use is when we want to paste numbers or text into a range that already contains formatting. There are a TON of reasons to paste values. This allows us to extract the numbers or text from cells. Paste Values will paste the values ONLY of the copied range WITHOUT formulas and formatting. Start by opening both the Excel worksheet and the PowerPoint presentation you want to edit at the same time.Copying and pasting values is probably one of the most common tasks we do in Excel. Linking or embedding an Excel worksheet into a PowerPoint presentation is actually pretty straightforward, and the process for doing either is almost identical.
PASTE LINK IN EXCEL 2016 HOW TO
How to Link or Embed an Excel Worksheet in Microsoft PowerPoint So, with all that in mind, let’s take a look at how to link and embed an Excel Sheet in Microsoft PowerPoint. There are some distinct advantages to embedding, though. For example, if you’re distributing that presentation to people who might not have access to the original Excel sheet, or if the presentation needs to show that Excel sheet at a specific point in time (rather than getting updated), embedding (and breaking the connection to the original sheet) makes more sense. And since it relies on the link to the original spreadsheet, it’s not so useful if you need to distribute the presentation to people who don’t have access to that location.Įmbedding that data, on the other hand, increases the size of presentation, because all that Excel data is actually embedded into the PowerPoint file. If it doesn’t, you’ll have to link it again. One disadvantage is that the original spreadsheet file needs to stay in the same location. There are advantages to both methods, of course. One advantage of linking a document (other than maintaining the connection) is that it keeps your PowerPoint presentation’s file size down, because the data is mostly still stored in the Excel sheet and only displayed in PowerPoint.
PASTE LINK IN EXCEL 2016 UPDATE
Updating the original Excel sheet does not automatically update the data in the target presentation.
While that can be useful sometimes, your other two options-linking and embedding-are much more powerful, and are what we’re going to show you how to do in this article. You can use PowerPoint’s basic table formatting tools on it, but you can’t use any of Excel’s features after the conversion. This works okay, but all it really does is convert the data to a simple table in PowerPoint.
The first is by simply copying that data from the spreadsheet, and then pasting it into the target document. You actually have three options for including a spreadsheet in a PowerPoint presentation. What’s the Difference Between Linking and Embedding?