Excel

How to Use Labels as References in MS Excel 2003 0

How to Use Labels as References in MS Excel 2003

Ever have formulas in Excel that simply won’t budge if you ‘labeled’ one of the cells? No need to restrain yourself from Labeling cells. This step-by-step guide will teach you how to configure Excel to accept Labels in formulas.

How to Add Conditional Formatting In MS Excel XP 0

How to Add Conditional Formatting In MS Excel XP

Highlighting data is a very useful concept to emphasize values that need attention in a spreadsheet. In MS Excel you can manually highlight specific cells, but often the value of the cell will actually determine if the cell needs to be highlighted. Using conditional formatting in MS Excel XP, this is very easy to set up and apply.

How To Freeze And Unfreeze Panes In MS Excel XP 0

How To Freeze And Unfreeze Panes In MS Excel XP

Using MS Excel for tables is a very commen use of a spreadsheet application. But when your tables increases in size, you need to scroll the view. Unfortunately that means any column header (normally in the top row) will scroll out of view. Use the freeze panes options to prevent this.