A2oz

How Do You Create From Selection in Excel?

Published in Excel Features 3 mins read

Creating from selection in Excel refers to using the selected data to generate new information or objects. Here's how you can do it:

1. Using the "Create from Selection" Feature

Excel offers a built-in feature called "Create from Selection" that helps you quickly generate charts, tables, and other objects based on your selected data.

  • Select the data you want to use.
  • Go to the Insert tab.
  • In the Charts group, click Recommended Charts.
  • Excel will analyze your data and suggest the most appropriate chart types.
  • Choose the chart type you want to create.

2. Creating a Pivot Table

Pivot tables are powerful tools for summarizing and analyzing data. You can create a pivot table from your selected data.

  • Select the data you want to analyze.
  • Go to the Insert tab.
  • Click PivotTable.
  • In the Create PivotTable dialog box, ensure Use an external data source is unchecked.
  • Click OK.
  • The PivotTable Fields pane will appear. Drag and drop fields to create your pivot table.

3. Creating a Chart

You can create various charts like bar charts, line charts, pie charts, and more directly from your selected data.

  • Select the data you want to chart.
  • Go to the Insert tab.
  • Click the chart type you want to create (e.g., Column Chart, Line Chart).
  • Excel will create the chart based on your selected data.

4. Using Formulas

You can use formulas to perform calculations and create new data based on your selected data.

  • Select the cell where you want to display the result.
  • Enter a formula that references the selected data.
  • For example, to calculate the sum of the selected cells, you would use the formula =SUM(selected cells).

5. Creating a New Worksheet

You can create a new worksheet from your selected data by copying and pasting it into a new sheet.

  • Select the data.
  • Right-click on the selection.
  • Choose Copy.
  • Go to the new worksheet.
  • Right-click on the cell where you want to paste the data.
  • Choose Paste.

By utilizing these methods, you can efficiently create various objects and analyze data in Excel based on your selected information.

Related Articles