Download free books at BookBooN.com
1. Select the Data
Tab in the Ribbon.
2. Click on the Filter
button. It is easy to find because at present the filteris active, which means the
button is highlighted with a red/orange colour.
Figure 42: Excel is being "creative" by inserting column headers.
Now the arrows have disappeared from the column headers, but there has also been another change in the
table. In the upper left corner it suddenly says "column1". Iwondered the first time I saw this in Excel 2007,
since I had never seen it before.
The explanation is that when you define a field as a table Excel requires that all columns have a header. This
is because Excel will use the headlines in connection with the sorting and filtering features that are available
for tables. This is also the reason you cannot delete the text.
You can write anything you want, but Excel does not allow this cell to be empty.
I you want it to be empty anyway, I have a little ”trick” for you.
1. Activate the cell.
2. Press the spacebar on the keyboard.
3. Press the ENTER key on your keyboard
Now you have typed an empty space in the cell, and spaces are invisible.
5.5 Conditional Formatting
Excel can change the colour, font, etc. of a cell, depending on what value it has. You can pre-select a number
format that shows negative numbers in red, but conditional formatting gives more options.
The way it works is that you give a cell the format you would like it to have as a starting point. Then you set
up a list of the alternative formats it can have, and what conditions must be met for it to change the format.
Imagine an example where you want to build up statistics on absenteeism rates among a group of
employees. You make a list of employees and a calculation of absence rates.
If the absence rate for the individual employee is less than 5%, the cell should have default formatting. If
absence rates are greater than 5% but less than 8%, the cell should be marked with a yellow background
colour. If the absenteeism rate is 8% or more, the cell should have white writing on a red background colour.
If you have worked with conditional formatting in earlier versions of Excel, this may not be new to you. But
Excel 2007 has introduced a new way to define rules. It has now become much easier. In addition, it has
become possible to use a value-dependent colour spectrum, which can give quite impressive results.