Pivot tables are a powerful feature in Excel. They put flexibility and analytical power in your hands. Pivot tables extract information from large data tables without using formulas. When you find data you want to include in a pivot table, such as data included in a pivot table tutorial, copy the sample data into an Excel worksheet.

Data for Excel Pivot Table Tutorial

Here’s an example of data you’ll find in a pivot table tutorial:

Instructions in this article apply to Excel 2019, 2016, 2013, 2010; and Excel for Microsoft 365.

How to Copy the Tutorial Text

Follow these steps to copy the sample data into your own Excel file. These steps are relevant for any data you want to copy into Excel, not just the specific data shown in the table above.

  • Highlight the data in the table above. Select from the title Cookie Sales by Region to the number $69,496 at the bottom of the table.
  • Right-click (or tap-and-hold) any part of the highlighted text and choose Copy from the browser’s context menu.
  • Another way to copy the data from the table is to use the Ctrl+C (Windows) or Command+C (Mac) keyboard shortcut.
  • Select cell A1 in a blank Excel worksheet to make it the active cell.
  • Go to the Home tab.
  • In the Clipboard group, select the Paste dropdown arrow.
  • Choose Paste Special.
  • In the Paste Special dialog box, select Text.
  • Select OK to paste the data into Excel.
  • Each piece of data is pasted into a separate cell in the worksheet. If cell A1 was the active cell when the data was pasted into the worksheet, the data appears in the range A1 to D12.

Highlight the data in the table above. Select from the title Cookie Sales by Region to the number $69,496 at the bottom of the table.

Right-click (or tap-and-hold) any part of the highlighted text and choose Copy from the browser’s context menu.

Another way to copy the data from the table is to use the Ctrl+C (Windows) or Command+C (Mac) keyboard shortcut.

Select cell A1 in a blank Excel worksheet to make it the active cell.

Go to the Home tab.

In the Clipboard group, select the Paste dropdown arrow.

Choose Paste Special.

In the Paste Special dialog box, select Text.

Select OK to paste the data into Excel.

Each piece of data is pasted into a separate cell in the worksheet. If cell A1 was the active cell when the data was pasted into the worksheet, the data appears in the range A1 to D12.

Get the Latest Tech News Delivered Every Day

  • How to Create a Report in Excel

  • How to Select Rows, Columns, or Worksheets in Excel

  • How to Create a Drop-Down List Using Data From Another Excel Worksheet

  • How to Use the Office Clipboard to Copy Multiple Items in Excel

  • How to Use the STDEV and STDEV.S Functions in Excel

  • How to Limit Rows and Columns in Excel

  • How to Export Data to Excel

  • How to Move Columns in Excel

  • How to Count Data in Selected Cells With Excel’s COUNTIF Function

  • Do’s and Don’ts of Entering Data in Excel

  • How to Use the Excel RIGHT Function to Extract Characters

  • How to Link or Embed Excel Files in Word Documents

  • How to Use the ISBLANK Function in Excel

  • How to Remove Extra Spaces From Excel

  • Excel SUMIFS: How to Sum Only Values Meeting Multiple Criteria

  • How to Use Conditional Formatting in Excel

  • Facebook

  • Twitter

Hit Refresh on Your Tech News

  • About Us

  • Privacy Policy

  • Editorial Guidelines

  • Terms of Use

  • Careers

  • Advertise

  • Contact

  • EU Privacy

  • NEWS

  • HOW TO

  • FEATURES

  • ABOUT US