Your Excel Survival Kit by Anne Walsh

Author:Anne Walsh
Language: eng
Format: epub, pdf
Tags: Excel;Pivot Table;Formula;VLOOKUP;Power Pivot
Publisher: Holy Macro! Books
Published: 2016-05-02T04:00:00+00:00

Figure 3-17

Removing Conditional Formatting

1. Still in 03_Duplicate_entries, click in cell A2 and press Ctrl+Shift+Down Arrow.

2. Select Home | Conditional Formatting | Clear Rules | Clear Rules from Selected Cells (see Figure 3-18). Excel removes the conditional formatting.

Figure 3-18

Removing Duplicate Entries

Once you have identified those tricky little duplicates, how do you remove them? It’s actually very straightforward.

1. Open the file 03_Duplicate_entries_remove.

2. Click in cell A2 and press Ctrl+Shift+Down Arrow.

3. Select Data | Remove Duplicates (see Figure 3-19).

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.