software

I was wondering is anyone can tell me to how to have a fixed header

Good afternoon,

On Excel 2003 how do I get the arrows on my keyboard to move me to next cell?
Right now my screen moves a tiny bit but doesnt not move me to next cell. I

This is the formula I am using:

I use Peter Noneley's Function Dictionary at work, a lot. I have to enable
the macros but that's ok with me because I first saw it on Mr. Pearson's

In one spreadsheet I have got 2 worksheets. I wish to compare the contents of
the two worksheets in an easy fashion, without having to flick from one to

I am trying to take a mail list that is in Excel and create a macro to only
show every 10th row. I need these addresses for a survey, so it doesn't make

When I open a spreadsheet and do a fill down I get all types of strange

We’re preparing a report and the detail commission values are rounded to two
decimals. I also calculate commission as Total Revenue x 5% (rounded to two

The following IF statement is not working:
=if(A1gt;B1, quot;quot;, B1-A1)

In some cases Excel (2003 SP2) is displaying the formula in a cell, not the
results. The formula (say Concatenate or an IF) is correct and there is no

Hello There
Could Someone show me how i can create a macro to copy the activecell from,

i have to add cells evenly spaced, eg a1 a11 a21 ... a991
how can I avoid writting all references?

I need to enter more than 10 numbers to left of the decimal and more than 5
to the right of the decimal. Right now if I enter more than 10 numbers to the

I am using Excel 2003 and I need to write a function to select numbers in a
column based on two separate criteria and then sum those selected numbers. I

Check to see if you have an Auto_Open macro.--

How can I put a border around the header when it prints? Any help would be
appreciated.

how do you format a cell so that when you select it a note box pops up with
directions. i am fimiliar with comments which also shows a red flag in the

I've written a macro that uses the histogram tool. When using the macro, it
generates a dialogue box for quot;OKquot; to overwrite existing data which makes me