Söka i excel 2013

/en/excel/sorting-data/content/

Introduction

If your worksheet contains a lot of content, it can be difficult to find upplysning quickly. Filters can be used to narrow down the uppgifter in your worksheet, allowing you to view only the upplysning you need.

Optional: Download our practice workbook.

To filter data:

In our example, we'll apply a filter to an redskap log worksheet to display only the laptops and projectors that are available for checkout.

1. In order for filtering to work correctly, your worksheet should include a header row, which is used to identify the name of each column. In our example, our worksheet is organized into different columns identified by the header cells in row 1: ID#, Type, EquipmentDetail, and so on.
   A worksheet with a header row
   
2. Select the Data tab, then click the Filter command.
   Clicking the Filter command
3. A drop-down arrow will appear in the header cell for each column.
4. Click the drop-down arrow for the column you want to filter. In our example, we will filter column B to view only certain types of equipment.
   Clicking the drop-down arrow for column B
   
5. 

Find & Select in Excel

You can use Excel's Find and Replace feature to quickly find specific text and replace it with other text. You can use Excel's Go To Special feature to quickly select all cells with formulas, notes, conditional formatting, constants, data validation, etc.

Find

To quickly find specific text, execute the following steps.

1. On the Home tab, in the Editing group, click Find & Select.

2. Click Find.

The 'Find and Replace' dialog box appears.

3. Type the text you want to find. For example, type Ferrari.

4. Click 'Find Next'.

Excel selects the first occurrence.

5. Click 'Find Next' to select the second occurrence.

6. To get a list of all the occurrences, click 'Find All'.

Replace

To quickly find specific text and replace it with other text, execute the following steps.

1. On the Home tab, in the Editing group, click Find & Select.

2. Click Replace.

The 'Find and Replace' dialog box appears (with the Replace tab selected).

3. Type the text you want to find (Veneno) and replace it with (Diablo).

4. Click 'Find Next'.

Excel selects the first occurrence. No replacement has been made yet.

5. Click 'Repla

Getting Data onto a Sheet in Excel

Data entry is one of the most important functions in Excel - and one of the most tedious, especially when the data is repetitive. This chapter from Excel Absolute Beginner's Guide shows you tricks for copying down data, fixing entered data, and helping your users enter data correctly by providing a predefined list of entries.

Like this article? We recommend 

Types of Data You Enter into Excel

It&#;s important to differentiate types of data because Excel treats each differently. You tell Excel what kind of data is in a cell by how you type it into the cell or by how you format the cell. Data in Excel can fall into one of four categories.

• Numbers&#;Numeric data that can be used for calculation purposes.
• Text&#;Alphabetic or numeric data that is not used for calculation purposes. Examples of numeric text are phone numbers or Social Security numbers.
• Dates and Times&#;Although dates and times may be considered alphanumeric, there are occasions where you might want to perform calculations on the values, so it is important to identify the data correctly to Excel.
• Formulas and Functions&#;It&#;s important that Excel knows you&