answersLogoWhite

0

In Excel 2007,

  1. Copy data to another column.
  2. Click on the column letter to select the column.
  3. On the data tab, in the data tools section, click on Remove Duplicates.
  4. Click OK.
User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

Can a worksheet contain data such as numbers and formulas?

yes


What does a worksheet cell contain?

A worksheet cell in a spreadsheet typically contains data or information such as text, numbers, formulas, or dates. It is the basic unit of a spreadsheet where you can input and manipulate data.


Can Worksheet cells only contain numbers?

No. A worksheet can hold all sorts of data, like text, dates, number, logical values and formulas.


What is the chart that is a representation of the data in a worksheet?

What is the visual representation of worksheet data?


What allows data easy to summarize and charted in excel?

An Excel worksheet or spreadsheet allows data to be easily summed and charted.


What kind of data functions manipulate quantitative data in a worksheet?

Mathematical and Trigonometric and statistical functions manipulate quantitative data in a worksheet.


What are the four kind of data you can enter in a worksheet?

numbers, text, images, and imbedded objectsUtilities, repairs, phone bills, etc.


Duplicate data in multiple data files is?

Data backups


Can a chart be saved on the same worksheet as the data or on a separate worksheet?

A chart can be saved on the same worksheet or on a separate worksheet in Excel. The easiest way to put a chart on a separate worksheet is to create your chart on the same worksheet as your data. After you create your chart, just cut and past to the worksheet where you want it to show.


Is not a method for copying data to another part of the worksheet?

Printing is not a method for copying data to another part of the worksheet.


Are embedded charts updated when the worksheet data changes?

Ye, embedded charts are updated when the data in the worksheet is changed.


What is the difference between sheet tabs and worksheets?

A worksheet contains columns, rows and cells and is where you do your work. Each worksheet has a name. You can have more than one worksheet in a workbook. Each worksheet has a tab at the bottom of the screen, with its name on it. This is a sheet tab. It allows you to identify the different worksheets and by clicking on a sheet tab, you can change from one worksheet to another.