Excel Training
Find all how-to-guides and step by step videos below.

Tables, charts, and analysis

Copy cell formatting

In Excel, select cell contents to help manage your work efficiently across a workbook.

Select a cell

  • You can select a cell using a mouse or by navigating to that cell using the arrow keys on your keyboard.

Select a cell range

  • Select a cell, hold the right bottom edge of the cell and drag over the cell range you want to select.
  • Or to select a range using the keyboard, hold the Shift key while navigating across the cell range using the arrow keys.

Select a row, column, or worksheet

  • Use one of the following methods to select a column:
    • If you don’t want to select the title of the column, select the cell below the title, press Shift, and then double-click the bottom edge of that cell.
    • To select the entire column, select any cell in that column (for e.g., A2), and then press Ctrl + Space.
  • To select the entire row, select any cell in that row (for e.g., A2), and then press Shift + Space.
  • To select a list, select any cell in that list, and then press Ctrl + A.
  • To select the entire worksheet, select any cell and press Ctrl + A + A.
  • To select a table without the heading or title of the table, select any cell and then press Ctrl + A.
  • To select a table with heading or title of the table, select any cell in that table and then press Ctrl + A + A.
  • To select the entire worksheet which is in table format, select any cell and then press Ctrl + A + A.
  • Select the letter at the top of a column to select the entire column.
  • You can also select the Select All Select All button at the top left corner of the worksheet to select the entire worksheet.

Select non-adjacent columns

  • Hold Ctrl while selecting the column headings of the non-adjacent columns. For example, hold Ctrl and select A, C, E, G, H, I, K.

Select non-contiguous cells or ranges

  • Hold Ctrl while selecting non-contiguous cells or ranges.

Type data in non-contiguous cells at once

  1. Select non-contiguous cells.
  2. Start typing data.
  3. Press Ctrl + Enter.

Hide columns

  1. Select a column.
  2. Right-click and select Hide.

Hide non-contiguous columns

  1. Select non-contiguous column ranges.
  2. Right-click one of the selected column ranges and select Hide.

Copy only visible columns

  1. Select a cell range with hidden columns.
  2. Press Alt + ; and then Ctrl + C to copy only visible columns.
  3. You can paste them in any worksheet in your workbook by simply pressing Ctrl + V.

Select cell contents

In Excel, select cell contents to help manage your work efficiently across a workbook.

Select a cell

  • You can select a cell using a mouse or by navigating to that cell using the arrow keys on your keyboard.

Select a cell range

  • Select a cell, hold the right bottom edge of the cell and drag over the cell range you want to select.
  • Or to select a range using the keyboard, hold the Shift key while navigating across the cell range using the arrow keys.

Select a row, column, or worksheet

  • Use one of the following methods to select a column:
    • If you don’t want to select the title of the column, select the cell below the title, press Shift, and then double-click the bottom edge of that cell.
    • To select the entire column, select any cell in that column (for e.g., A2), and then press Ctrl + Space.
  • To select the entire row, select any cell in that row (for e.g., A2), and then press Shift + Space.
  • To select a list, select any cell in that list, and then press Ctrl + A.
  • To select the entire worksheet, select any cell and press Ctrl + A + A.
  • To select a table without the heading or title of the table, select any cell and then press Ctrl + A.
  • To select a table with heading or title of the table, select any cell in that table and then press Ctrl + A + A.
  • To select the entire worksheet which is in table format, select any cell and then press Ctrl + A + A.
  • Select the letter at the top of a column to select the entire column.
  • You can also select the Select All Select All button at the top left corner of the worksheet to select the entire worksheet.

Select non-adjacent columns

  • Hold Ctrl while selecting the column headings of the non-adjacent columns. For example, hold Ctrl and select A, C, E, G, H, I, K.

Select non-contiguous cells or ranges

  • Hold Ctrl while selecting non-contiguous cells or ranges.

Type data in non-contiguous cells at once

  1. Select non-contiguous cells.
  2. Start typing data.
  3. Press Ctrl + Enter.

Hide columns

  1. Select a column.
  2. Right-click and select Hide.

Hide non-contiguous columns

  1. Select non-contiguous column ranges.
  2. Right-click one of the selected column ranges and select Hide.

Copy only visible columns

  1. Select a cell range with hidden columns.
  2. Press Alt + ; and then Ctrl + C to copy only visible columns.
  3. You can paste them in any worksheet in your workbook by simply pressing Ctrl + V.

Move or copy cell contents

You can use the Cut, Copy, and Paste commands to move or copy cells or their contents.

Move cells

  1. Select a cell or a cell range.
  2. Select Home > Cut Cut or press Ctrl + X.
  3. Select a cell where you want to move the data.
  4. Select Home > Paste Paste or press Ctrl + V.

Copy cells

  1. Select a cell or a cell range.
  2. Select Home > Copy Copy or press Ctrl + C.
  3. Select a cell where you want to copy the data.
  4. Select Home > Paste Paste or press Ctrl + V.

By default, drag-and-drop editing is turned on so that you can use the mouse to move and copy cells.

  1. Select the cells or range of cells that you want to move or copy.
  2. Do one of the following:
    • To move a cell or range of cells, point to the border of the selection. When the pointer becomes a move pointer move pointer , drag the cell or range of cells to another location.
    • To copy a cell or range of cells, hold down Ctrl while you point to the border of the selection. When the pointer becomes a copy pointer Copy Pointer , drag the cell or range of cells to another location.

Move cells between existing cells

  1. Select a cell range.
  2. Hold Shift and when the pointer becomes a move pointer move pointer , drag the cell range to the new location between existing cells.

Get started with Excel

You’ve got mountains of data.

Wouldn’t it be great if you could find the story behind the numbers on your own?

That’s why there’s the new Excel.

In these courses, you’ll see how Excel is the best app for reviewing and editing spreadsheets at work, at home, and everywhere in between.

As you enter data, Excel recognizes patterns, so it can automatically fill in the remaining info for you.

Then, after you’ve entered your data, Excel helps you spot trends and patterns using data bars, sparklines, color-coding, and icons.

Excel even helps you summarize and illustrate your insights by recommending pre-made PivotTables and charts.

And when you’re all done, you can let others view or edit your work at the same time by saving to the cloud, on OneDrive.

You don’t even need a PC.

You just need a browser or the Excel Mobile app.

Learn how to uncover the story behind the numbers…with Excel.

Create a workbook

A workbook is a file that contains one or more worksheets, to help you organize your data. You can create a workbook from a blank workbook or a template.

Create a workbook

  1. Select File > New.
  2. Select Blank workbook.

    TIP: Press CTRL+N to quickly create a new workbook.

Create a workbook using a template

  1. Select File > New.
  2. Do one of the following:
    • Select a template from the available list of templates, and then select Create.
    • From Suggested searches, select a category (such as Business, Personal, or Industry), select a template, and then select Create.

Add, delete, or rename sheets

By default, Excel gives you one worksheet in a workbook, but you can add more worksheets, rename them, or delete them, as needed.

Insert a worksheet

  1. Do one of the following:
    • On the Sheet tab, select   add . A new worksheet will be added to the right of the current sheet.
      sheet
    • Select Home > Insert > Insert Sheet.
    • Right-click a sheet, click Insert, and in the Insert box, click Worksheet, and then click OK.

Rename a worksheet

  1. On the Sheet tab, right-click the worksheet you want to rename, and then click Rename.
  2. Type a new name for the Sheet, and then press Enter.

    TIP: Double-click the sheet name on the Sheet tab to quickly rename it.

Remove a worksheet

  1. On the Sheet tab, right -click the sheet you want to delete.
  2. Click Delete Delete .
  3. If the sheet is empty, it will be Deleted, but if there is data on the sheet, then a pop-up message will appear. Select Delete to confirm the deletion.

Hide a worksheet

  1. On the Sheet tab, right -click the sheet you want to hide.
  2. Click Hide.

Hide or unhide columns

Hide or unhide columns in your spreadsheet to show just the data that you need to see or print.

Hide columns

  1. Select one or more columns, and then press Ctrl to select additional columns that aren’t adjacent.
  2. Right-click the selected columns, and then select Hide.

    NOTE: The double line between two columns is an indicator that you’ve hidden a column.

Unhide columns

  1. Select the adjacent columns for the hidden columns.
  2. Right-click the selected columns, and then select Unhide.Or double-click the double line between the two columns where hidden columns exist.

Freeze top and left panes

Freeze rows and columns to keep specific areas visible when you scroll in a worksheet.

Freeze the first column

  • Select View > Freeze Panes > Freeze First Column.

    NOTE: The faint line that appears between Columns A and B inidates that your first column is frozen.

Unfreeze rows and columns

  • Select View > Freeze Panes > Unfreeze Panes.

Freeze rows and columns

  1. Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.
  2. Select View > Freeze Panes > Freeze Panes.

Apply themes to change the look

Use or customize a theme in your Excel workbook to make your data stand out.

  1. Select Page Layout > Themes.
  2. Select a theme you want to use from the available list.

    NOTE: You will see theme previews in your worksheet as you hover over different themes.

Move or copy worksheets

You can move or copy a worksheet in the same workbook, or copy a worksheet to another workbook.

Move a worksheet within a workbook

  • Select the worksheet tab, and drag it to where you want it.

    NOTE: Be aware that calculations or charts that are based on worksheet data might become inaccurate if you move the worksheet.

Copy a worksheet to a new workbook

  1. Right-click the worksheet tab and select Move or Copy.
  2. Check Create a copy.
  3. Under To book, select (new book) or another workbook you have open.
  4. Select OK.
  5. Press CTRL + TAB to go back to the other workbook.

Copy a worksheet in the same workbook

  1. Press CTRL and drag the worksheet tab to the tab location you want, or right-click the worksheet tab and select Move or Copy.
  2. Select the Create a copy checkbox.
  3. Under Before sheet, select where you want to place the copy.
  4. Select OK.

Rename a worksheet tab

  1. Double-click the worksheet tab.
  2. Type a new name.

Add and edit data

Explore the basics of adding and editing data in Excel.

Add data

  1. To add data in a cell, place the mouse cursor in a cell and select it or use the arrow keys on a keyboard to navigate to the correct cell.

    NOTE: The address of the selected cell displays in the top left part of the screen above the worksheet and the selected cell now has a border to visually indicate it is the active cell.
    Add data

  2. After you have selected a cell:
    • Type in the active cell.
    • Select Formula Bar located above the worksheet, and then type in the data.
      Formula Bar
    • Double-click the cell, and then enter data.
    • Press F2 and then enter data.

Edit data

  • Select a cell to display the data in Formula Bar, and then select Formula Bar to edit the data.
  • Double-click a cell and then edit the data.
  • Select a cell in the worksheet, and then start typing to replace the cell content with new data.

Change active cell

  • Press Tab to change the location of the active cell to the cell in the next column.
  • Press Enter to change the location of the active cell to the cell in the next row.
  • Use the mouse cursor to choose another cell.

Create reusable lists

For lists that you use often, you can create a reusable list, so you don’t have to type the list every time you need it.

Create a custom list

  1. Select the cells within the list that you want to reuse.
  2. Select File > Options.
  3. Select Advanced, scroll-down, and in the General section, select Edit Custom Lists.
    Advanced
  4. Select Import, and then select OK.
    Import

    TIP: You can also create a custom list by typing the list into List entries.

  5. Select OK to exit the Excel Options dialog box.

Use a custom list

  • Type any data in a cell from the custom list, and then drag the fill handle across cells.

Sort by custom list

  1. Select a cell in the column you want to sort.
  2. Select Data > Sort.
  3. For Sort by, select the column you want to sort.
  4. For Sort on, select Values.
  5. For Order, select Custom list.
  6. In Custom lists, select the custom list.
  7. Click OK to close the Custom Lists dialog box.
  8. Click OK to close the Sort dialog box.

Resize and merge cells and align data

You can change the way data appears in a cell by merging cells, and aligning, wrapping, or rotating text.

Align cell data

  1. Select a cell or cell range in your worksheet.
  2. On the Home tab select a text alignment option. You can align text at the top, middle, or bottom of the cell, and to the left, center, or right of the cell.

    NOTE: You may not be able to change the alignment, based on the format of the cell.

Add a line break within a cell

  1. Select the cell.
  2. Type the text you want on the first line.
  3. On the keyboard, press Alt + Enter to add a line break.
  4. Type the next you want on the next line.
  5. Press Enter.

Make a cell taller or wider

  1. Place the cursor on the line between the cell and next cell.
  2. Drag the line to the height or width you want.

Wrap Text

  1. Select a cell or cell range.
  2. Select Home > Wrap Text.

Merge cells

  1. Select the cells you want to merge.
  2. SelectHome > Merge & Center.

    NOTE:  To later unmerge cells, select Unmerge Cells from the Merge & Center drop-down.

Rotate cell data

  1. Select a cell or cell range.
  2. Select Home > Alignment Settings Alignment Settings .
  3. In Orientation, edit the degree of rotation the cell data.
  4. Select OK.

    NOTE: Note: You can also select Home > Orientation Orientation and select an option from the drop-down.

Format numbers in cells

In Excel, you can display number formats as currency, percentages, decimals, dates, phone numbers, or social security numbers.

Number format

  1. Select a cell or a cell range.
  2. On the Home tab, select Number from the drop-down.
    General
    Or, you can choose one of these options:

    • Press Ctrl + 1 and select Number.
    • Right-click the cell or cell range, select Format Cells… , and select Number.
    • Select the dialog box launcher Alignment Settings next to Number Dialog box launcher and then select Number.

Currency

  1. Select a cell or a cell range that has numeric value.
  2. Select Home > Currency .

Decimal

  1. Select a cell or a cell range that has numeric value.
  2. Select Home > Increase Decimal Increase Decimal or Home > Decrease Decimal Decrease Decimal .

Date

  1. Select a cell or a cell range.
  2. On the Home tab, select Number Format Alignment Settings .
  3. Select Date, and then select the Type.
  4. Select OK.

Phone number or social security number

  1. Right-click a cell or a cell range, and then select Format Cells…
  2. Select Special.
  3. For Type, select either Phone Number or Social Security Number.
  4. Select OK.

Change the look of cells

Format cells to make them stand out using fonts, font size, color, and borders.

Cell styles

  1. Select a cell or cell range in the worksheet.
  2. Select Home > Cell Style Cell Style .
  3. Select the cell style that you want to apply.

Select a font, font size, font color, and border

  1. Select a cell or cell range.
  2. On the Home tab, select a Font and Font Size from the drop-down.
  3. To change the font color, select Font Color Font Color and select a color from the drop-down. to change the text color.

    NOTE: If you want to see more colors, select More Colors from the drop-down, and select a color from the Standard or Custom tab.

  4. To change the font style, select Bold, Italic, or Underline.
  5. To change the Border, select a border Border from the drop-down.

Insert or delete rows or columns

Small changes in the layout of your worksheet can give you big improvements in readability. Insert and delete rows, columns, and cells to organize your worksheet.

Insert a column

  1. Select the letter at the top of a column to select the column.
  2. Select Home > Insert > Insert Sheet Columns
    Or, right-click the top of the column, and then select Insert.

    NOTE: Excels inserts a new column to the left.

Delete a column

  1. Select the column.
  2. Select Home > Delete > Delete Sheet Columns.Or, right-click the top of the column, and then select Delete.

Insert a row

  1. Select the row number to select a row.
  2. Select Home > Insert > Insert Sheet Rows.
    Insert Sheet Rows
    Or, right-click the selected row, and then select Insert.

    NOTE: A new row is inserted above the selected row.

Delete a row

  1. Select the row.
  2. SelectHome > Delete > Delete Sheet Rows.
    Or, right-click the selected row, and then select Delete.

Insert a cell

  1. Select a cell or a cell range.
  2. Right-click the selected cells, and then select Insert.
  3. In the Insert box, select an option:
    Insert box

    • Shift cells right – shifts cells right to make space for the new cell(s).
    • Shift cells down – shifts cells down to make space for the new cell(s).
    • Entire row – inserts a new row.
    • Entire column – inserts a new column.
  4. Select OK.

Resize rows and columns

You can manually adjust the column width or row height by dragging the cell boundaries, or automatically resize columns and rows to fit the data.

NOTE: If a column is too narrow to display the data, you will see ### in the cell.

Resize columns

  1. Select a column or a range of columns.
  2. Place the pointer on the boundary between the column headers.
    Select column
  3. Drag the boundary to change the width. This resizes all of the selected columns to the same width.

Resize rows

  1. Select a row or a range of rows.
  2. Place the pointer on the boundary between row numbers.
  3. Drag the boundary to change the height.

Automatically resize columns or rows to fit the data

  1. Select columns or rows with data.
  2. Double-click a boundary. All columns or rows resize to fit the data.

    NOTE: If only one column is selected, double-click the right boundary of the column header. If only one row is selected, double-click the lower boundary of the row.

Automatically resize all columns and rows to fit the data

  1. Select the Select All button Select All at the top of the worksheet, to select all columns and rows.
  2. Double-click a boundary. All columns or rows resize to fit the data.

AutoFill time spans

With the AutoFill feature, you can automatically fill cells with data that follow a pattern or series.

  1. Select a cell and type the first word of a series (e.g. type “January” for a 12-month series).
  2. Select the fill handle  handle  at the lower-right corner of the cell, hold down, and drag to fill the rest of the series. Fill handles can be dragged up, down, or across a spreadsheet.
    dragging

    NOTE: If you only enter a three-letter abbreviation (e.g. “Jan”) in the cell, AutoFill will automatically fill in the rest of the series.

Split and combine data

With Flash Fill, you can automatically fill data in a specific pattern across multiple columns.

  1. Select a cell and then enter data from a specific pattern.
  2. Press Enter.
  3. In the next cell, enter data. Excel will begin to automatically fill data in cells from a set pattern.
    automatically fill data
  4. To use Flash Fill, select Data > Data Tools > Flash Fill Flash Fill or press Ctrl + E.

Build custom numeric formats

Excel has many built-in numeric formats you can use, or you can build your own.

  1. Right-click the column header, and then select Format Cells.Or, select a column, and then select Home > Number.
    GeneralThe Format Cells dialog box opens, with the Number tab selected by default.

    NOTE: You can also press Ctrl + 1 to open the Format Cells dialog box.

  2. In Category, select Custom.
    Category
  3. In Type, select an existing format.Or, type a new format in the Type box, to create one.
  4. Select OK.

Validate cell data

When you create worksheets that will be used by others, it’s important to make sure they can only enter valid data. Use Excel’s data validation features to make rules to restrict the type of data or values that others can enter into a cell.

  1. Select the cell(s) you want to create a rule for.
  2. Select Data >Data Validation.
    Data validation
  3. On the Settings tab, under Allow, select an option:
    • Whole Number – to restrict the column to accept only whole numbers.
    • Decimal – to accept decimal numbers.
    • List – to pick data from the drop-down list.
    • Date – to restrict the cell to accept only date.
    • Time – to restrict the cell to accept only time.
    • Text Length – to restrict the length of the text.
    • Custom – for custom formula.
  4. Under Data, select a condition:
    • between
    • not between
    • equal to
    • not equal to
    • greater than
    • less than
    • greater than or equal to
    • less than or equal to
  5. On the Settings tab, under Allow, select an option:
  6. Set the other required values, based on what you chose for Allow and Data.
    For example, if you select between, then select the Minimum: and Maximum: values for the cell(s).
  7. Select the Ignore blank checkbox if you want to ignore blank spaces.
  8. If you want to add a Title and message for your rule, select the Input Message tab, and then type a title and input message.
  9. Select the Show input message when cell is selected checkbox to display the message when the user selects or hovers over the selected cell(s).
  10. Select OK.Now, if the user tries to enter a value that is not valid, a pop-up appears with the message, “This value doesn’t match the data validation restrictions for this cell.”

Tables, charts, and analysis

Create and format tables

You can create and format a table, to visually group and analyze data.

Shortcuts

  1. To create a table, select the data and select Home > Format as Table.

    TIP:  You can also press CTRL + T or CTRL + L.

  2. To make sure there are no empty columns or rows in the data, select a cell within the data, press CTRL + A, then press CTRL + . a few times to move around the data.

Create a table

  1. Select a cell or range of cells to include in the table.
  2. Select Insert > Table Table .
  3. A Create Table box appears with the cells to include in the table. Edit if needed.
  4. If your table has a header, check the My table has headers checkbox
  5. Select OK. A Design tab appears in the Ribbon.

Format a table

  1. Select a cell within the table.
  2. On the Design tab, select a Table Style.
  3. In the Table Style Options group, you can check and uncheck different boxes to get the look you want, for example Banded Rows or Banded Columns.

    NOTE: If a new row or column is added in the table, it will be automatically added with the table style. Formulas are applied as you add new rows, or create a formula within a column.

Sort data in a table

Sorting is one of the most common tools for data management. In Excel, you can sort your table by one or more columns, by ascending or descending order, or do a custom sort.

Before sorting a table:

  1. Make sure that there are no empty rows or columns in the table.
  2. Get table headers into one row across the top.
  3. Make sure there is at least one empty column between the table you want to sort, and other information on the worksheet not in that table.

Check for empty rows or columns

  1. Select a cell within the data and press CTRL + A.
  2. Press CTRL + . a few times to move the active cell around the corners, and check for empty cells.

Sort the table

  1. Select a cell within the data.
  2. Select Home > Sort & Filter.
    Sort&Filter
    Or, select Data > Sort.
    DATA-Sort&Filter
  3. Select an option:
    • Sort A to Z – sorts the selected column in an ascending order.
    • Sort Z to A – sorts the selected column in a descending order.
    • Custom Sort – sorts data in multiple columns by applying different sort criteria.

For a Custom Sort:

  1. Select Custom Sort.
  2. Select Add Level.
    Add Level
  3. For Column, select the column you want to Sort by from the drop-down, and then select the second column you Then by want to sort. For example, Sort by Department and Then by Status.
  4. For Sort On, select Values.
  5. For Order, select an option, like A to Z, Smallest to Largest, or Largest to Smallest.
  6. For each additional column that you want to sort by, repeat steps 2-5.

    NOTE: To delete a level, select Delete Level.

  7. Check the My data has headers checkbox, if your data has a header row.
  8. Select OK.

Filter data in a table

Filters provide a quick way to find and work with a subset of data in a range or table. When you filter a list, you temporarily hide some of the data, so you can focus on the data you want.

Filter data

  1. Select a cell within the data that you want to filter.

    NOTE: Before you filter your data, make sure there are no empty rows or columns.

  2. Select Home > Sort & Filter > Filter.
    Or, select Data > Filter.
  3. Select the filter drop arrow of the column you want to filter.
    Filterdropdown
  4. Uncheck Select All, and check the filters you want.
    SelectAll
  5. Select OK. The filter drop arrow changes to a filter Filter to show the column is filtered. The Blue row numbers show which rows are included in the filtered data.
  6. To remove the filter, select Clear. All data displays.
    Clear

    NOTE: To apply filters on multiple columns, select the first column, apply the filter, and then select the next column and apply a filter on one.

Apply a custom filter

  1. Select the filter drop arrow and then select:
    • Text Filters – available when the column Contains text or a mix of text and numbers: Equals, Does Not Equal, BeginsWith, EndsWith, or Contains.
    • Number Filters – available when the column contains only numbers: Equals, Does Not Equal, Greater Than, LessThan, or Between.
    • Date Filters – available when the column contains only dates: Last Week, Next Month, This Month, and Last Month.
    • Clear Filter from ‘Column’ – available when the column is already filtered. Select this option to clear the filter.
    • Select And if both conditions must be true.
    • Select Or if only one of the conditions needs to be true.
  2. Enter the filtering conditions.
  3. For example, to view the numbers greater than a specific number, select Number Filters > Greater Than Or Equal To and then enter the specific number.
    CustomAutofilter
  4. To filter results by two conditions, enter the filter conditions in both boxes.
  5. To change the order of the filter results, select the filter drop-down, and then select either Sort Largest to Smallest or Sort Smallest to Largest.

Add a Total row to a table

You can add totals to a table by selecting the Total Row checkbox on the Design tab. You can also add a function from the total row drop-down.

  1. Select a cell in a table.
  2. Select Design > Total Row.
    TotalRow
  3. The Total row is added to the bottom of the table.
    TotalRow

    NOTE: To add a new row, uncheck the Total Row checkbox, add the row, and then recheck the Total Row checkbox.

  4. From the total row drop-down, you can select a function, like Average, Count, Count Numbers, Max, Min, Sum, StdDev, Var, and more.
    functions

Filter data with slicers

When working with large amounts of data, you can use slicers in your table, to filter and view your data.

Convert data into a table

  1. There are four ways to convert data into a table:

    NOTE: In order to use a slicer, you must convert your data into a table first.

    • Press Ctrl + t.
    • Press Ctrl + l.
    • Select Home > Format as Table.
    • Select Insert > Table.
  2. Select OK.

Use a slicer to filter data

  1. Select Insert > Slicer.
    InsertSlicer
  2. Select the fields you’d like to filter.
  3. Select OK and adjust your slicer preferences, such as Columns, under Options.

    NOTE: To select more than one item, hold Ctrl, and then select the items that you want to show. Select and hold the corner of a slicer to adjust and resize it.

  4. Select Clear Filter Delete to clear the slicer filter.

PivotTables, collaboration, and Mac