In this case, the Excel data will not be linked to your PowerPoint presentation. In PowerPoint, right-click the data and select Update Link.Ĭopy and paste (unlinked) Excel data in PowerPoint In the Paste Special box, click Paste link, and then, under As, select Microsoft Excel Worksheet Object.Īfter you've used one of the methods described above to insert linked Excel data into a presentation, then refreshing the presentation to stay up to date with data changes is easy to do: On the Home tab, click the arrow below Paste, and select Paste Special. In PowerPoint, click the slide where you want to paste the copied worksheet data. In Excel, open the saved workbook with the data you want to insert and link to.ĭrag over the area of data you want to link to in PowerPoint, and on the Home tab, click or tap Copy. Link a section of data in Excel to PowerPoint When you save the Excel workbook, make sure the worksheet you want in your presentation is the one you see when you first open the workbook. Based on the selected designation, all the other columns are also filtered.Important: The linked object in your presentation displays all the data from the active, top worksheet in the linked Excel workbook. In the below image, Researcher designation is filtered. In the below image, Researcher designation is chosen. Step 4: Click the drop-down arrow and choose the value to filter the column. Step 3: When you click the AutoFilter option, a combo box will appear in the selected column header. Step 1: Select the column which you want to filter. Based on the selected value from the drop down, data in the columns will be filtered. When you select autofilter, a drop down box will be created in the first cell of the each column. In OpenOffice, there are three types of filter,Īutofilter is used to quickly filter the columns based on the selected data. In OpenOffice, Filter option allows you to narrow down the search to work with the particular set of data. How to filter data in OpenOffice Spreadsheet? Explanation

Open office spreadsheet