This is probably very easy but as I don't know what it's called, I'm
not sure how to find out how to do it in the group.
I want to find out how to stop the cell reference in a formula
changing when I insert a column.  For example, say I have a formula in

After I format my pivot table every time I change the info in it , it turns
back to the original format, not just when I update it but when I am looking
for a specific combination of info

I'm trying to use excel to create a barcode sequence, with a starting number
of "00001" using the column cell code: =Code128(A2).
All is going well, except that the first 4 digits (0000) keep getting erased
leaving me with a starting number of: 1.

I have a spreadsheet linked to an Access table whose values changes weekly.  
When I do a "Refresh All", the Excel spreadsheet updates correctly.  I have a
PT derived from the spreadsheet that does not update unless I have that PT
selected and use the "Refresh" command (e.g., the ...

I have a spreadsheet that looks like this:
Defect         Priority          Vendor
bug1           1                   ACME
bug2           1                   JONES

I have a list that I exported to Excel that has a name and date of birth
(only 2 columns).  I want to sort the list by month, dated and then year.  
When I try sorting the list, it always sorts by the year.   Do I have to put
in some sort of function to make is sort this way?

Can someone give the a crash course on creating a pivot table?  Is there a
reference out there somewhere?

Is it me or is there a bug?
When I use the general format for cells, I find that after the file is saved
and reopened these cells go to a custom format
[$-C09]dd-mmm;@

"P"              "Q"
239    6.073621262    Apple
240    2.515599192    Banana
241    35.09606534    Wood

(Excel 2003) I want to change the cell padding (increase the right-side
padding, but leave the text left-aligned). Is there a way to do this?
I have tried, but was unsuccessful with: (1) Format >> Cells... >> Alignment

I have an Excel spreadsheet with approximately 15000 rows and 20 columns.  
There are conditional formats on most lines and all works well until it comes
to saving.  An error message appears and when I continue to save, not all the
rows of conditional format are saved.  There is ...

I have a list of data in D15:D3014 (no duplicates).
What i want to do if possible is set up a lookup cell (say in J9) so that
when data is entered into cell J9 that matches data in  D15:D3014 then the
page will scroll to the matching data or create a hyperlink to the matching

In Excel 2003 (service pack 2), I have a Pivot Table and have modified the
format with borders and also a conditional format which colours a row or rows
depending on a value in another cell of the worksheet (the row/s for the
selected business unit is/are highlighted).  

i have just built a macro.  how do i create a button in the spreadsheet to
run the macro?  for instance, press button and the macro will run, putting in
the answer in the field next to the button?

good afternoon,
i need to find a formulae to lookup something on a tab, where the tab name
can be different, based on various alternatives.
i have used the formulae