1. Select the range from which you want to delete duplicate rows.
2. In the Data tab, Data Tools group click Remove Duplicates.
3. The Remove Duplicates window will open.
4. Specify whether your columns have headers or not.
5. Select the column(s) from which you want to remove duplicates then click OK.
6. The rows with duplicate data will be deleted and you will get [...]
To sort a data range by multiple columns, or keys, follow these steps:
1. Select the data range you want to sort.
2. On the Home tab, Editing group click on Sort & Filter.
3. Select Custom Sort.
4. The Sort window will open, with 3 combo boxes (drop-down) labeled Column, Sort On and Order respectively.
5. At first you will see one row of [...]
You can now convert Excel 2007 files directly to PDF format without the need for a third party software. However to be able to do that you need to download and install Microsoft Office “Save as PDF” Add-in (SaveAsPDF.exe) from Microsoft web site.
Check SaveAsPDF.EXE download page Here.
After the add-in is installed:
1. Click the Office [...]
To change worksheet tab color in Excel 2007 :
1. Select the tab whose color is to be changed.
2. In the Home tab, Cells group, click on Format.
3. Under Organize Sheets, point to Tab Color and select the color you want.
This is how your tabs will look like:
The Quick Access Toolbar, which is part of excel 2007 interface is a customizable toolbar.It comes handy for commands that you use more often.
You can customize the Quick Access Toolbar according to your needs and style by adding the commands you need from the available lists.
Follow these steps to customize:
1. Right click on the Quick Access [...]
In an earlier post I demonstrated How to count cells with multiple criteria in Excel 2003. I used an Array Formula together with the SUM function.
Fortunately enough in Excel 20007 we do not need that workaround. Now there is a direct function that count cells with multiple criteria: the COUNTIFS function.
Syntax
COUNTIFS(range1, criteria1,range2, criteria2…) … up [...]
To format a cell based on the value of another cell follow these steps:
1. Select the cell you want to format, “A1″ in this example.
2. In the Home tab, Styles group, click on Conditional Formatting.
3. Select New Rule.
4. The New Formatting Rule window will open.
5. Click Use a formula to determine which cells to format.
6. The New Formatting Rule [...]
To format a cell based on its value follow these steps:
1. Select the cell you want to format.
2. In the Home tab, Styles group, click on conditional formatting and point to Highlight Cells Rules.
3. A number of rules will show to the right. Select the rule you want to apply.
4. I will use Greater Than as an example. The [...]
View Tab
The view tab in Excel 2007 ribbon consists of 5 groups:
Workbook Views
Switch between Normal, printer page layout or page break views. You can also create and show your custom views or switch to full screen view.
Show/Hide
You can show or hide gridlines, formula bar or columns and row headings.
Zoom
Zoom in or out with different [...]
Review Tab
The review tab in Excel 2007 ribbon consists of 3 groups:
Proofing
The proofing group gives you options to check spelling, translate or check synonyms in the thesaurus.
Comments
Handles comments: add, edit, delete, show or hide.
Changes
For workbook and worksheet protection, workbook sharing or tracking of changes.
Posts on Excel 2007 user interface:
Introduction
The Home tab
The Insert tab
The Page Layout [...]
