I am doing the entries for a sporting event and have completed the entries,
but now need to sort them in to the order they will compete but do not wish
to sort in alpha order.  I have three columns of info i.e. rider, horse, club
so I need to keep the information in the rows ...

Here's the problem side scrolling is not workign right.
1. split a spreadsheet vertically so you have left and right sides.  
2. Pick a cell on the right side and using your mouse wheel side scroll.  
When my user does this the left split side scrolls, not the right one where

How do I create a diagonal line separating "Day" and "Time" in a cell?

I read posts concerning paste special shortcut, but I do not know how
to do this:
I would like to assign a shortcut (lets say ctrl + m) to opening of
paste special dialog box.

This is my sheet
SLR NO.    NAME     POINTS            REDEEM
POINTS                                  TOTAL
001    HARDEEP    4500.00

How can I show hourly values in a diagram – now  the minimum  resolution
seems to be day

Hello - I have a group of nurses that keep a lot of patient data in
standard excel workbooks.  I need to pull reports based on that data
on a weekly, monthly, and sometimes daily basis.
For now, I have been having them send me the data, and then I copy it

I just cannot seem to get this to happen. Instead of a space between each
piece of data I want the bar to look more solid in connection.
I have hours in 15 minute incements over a 24 hour period eg.A2:10, and say
the date in B1.

i have a worksheet with a list of prospects. I want the row to be
conditionally formatted when a change one cell to "quote". i can get that
particular cell to change, but i want it for the whole row!
Can anyone help?

I have a minor Excel formula problem.  
In my example has following data, cell A5 shows "apple", A6 shows "salt", A7
shows "sugar" and A8 shows "fish".  On another hand, cell B3 is the
"criteria" data showing 3.  My question is to form an Excel formula which can

I run Excel 2000
I have 2 option buttons in each row (total of 20 rows)
I would like the only one of the 2 buttons in each row are on or off.
The problem I am having is that it dosent matter which button on which row I

Is it possible to print out the Comment? There is no option in Print dialog
box to print comment
Regards,

when I highlight number fields, in the "lowerer" right of screen it shows a
COUNT of the rows i have selected...can I do the same for SUM? If I use
autosum it will store the result into a cell below my selection...want to
eliminate that step.  In other words if I select 3 numeric ...

All the documentation I've seen for pivot table caches assume either a
worksheet range or an OLE DB connection as the source data. Is it
possible to set a 2D array as the source data?
Cheers,

Is there a setting that will default my SaveAs to the 2003 version?
Ed