I am using Microsoft office excel 2003.  I do not know how to create a 2nd
page on my spreadsheet?  I tried using page break but that is not working for
me?

When I select a group of cells, in most of my excel docs, the sum of those
cells is displayed in the bar at the bottom of the sheet.
In some docs, it doesn't work. I've right-clicked on the bar and sum is
checked, but nothing happens. Is this my fault? Most things are.

How do I show a percentage of one cell in $ in another cell also in $

=VLOOKUP(A30,Sheet1!A1:C3,3,FALSE)
The above is a formulae that i will be dragging through my worksheet,
problem is a dont want this section ....Sheet1!A1:C3,......)
incrementing, is this possible? If so what do i do?

Why does it disappear when I leave the cell (a1, b1, etc.) And how can I
resolve this?

trying to set up a spreadsheet and final column must show vat content but
can't work it out

i hv a column that contains all the model name. I want to remove the spacing
in the model name. e.g. from abc 123 to abc123. May i know how to do it.
Thank you

Is it possible to set two freeze points in a spreadsheet?  For example,
let's say I want to freeze at Row 5, and at Row 500, so that I can
scroll between Rows 6 and 499.  Can I do this?
Thanks in advance.

Try to figure out how to write a macro button to color all rows "yellow"
that match a selected cell's value in 2 ranges.
Specifically, I want to be able to select a cell in column A from sheet1,
click a macro button, and highlight every row in 2 ranges "Players1" and

I have the foll prob, i have two worhsheets with values in column A matching
values in column C     A1 = 6 and  C1 = Cat
                A     B    C       
           1    6    Dog          Cat

I need to be able to retrieve a text file and have it automatically display
a date column in a date format, rather than the value 39288.3743055556 or
whatever value comes across.  What happens is we retrieve the file, and even
though the value is correct, the display isn't.  So ...

Is there a format or formula to convert a decimal to time?  An example would
be .5 would be 30 (minutes), .75 would be 45 (minutes), etc.  The Workbook
is relatively large so any method would have to easily apply to thousands of
numbers, versus simply manually converting one cell ...

Excel 2003 has recently become very slow to open.  Regardless of the
workbook / file.  I have disabled all Add-In's and cleaned out the
temp
folder.  The slow down appears to be related to having a live

I have the following formula I need to repeat
=((A2*A5)+(B2*B5)+(C2*C5)+(D2*D5)+(E2*E5)+(F2*F5)+(G2*G5)+(H2*H5)+
(I2*I5)+(J2*J5))
Row 2 has fixed values

Hi... I'm trying to put in a macro that will sort the data in column
G... what I have now is:
Sub SortMe()
   Cells.Sort Key1:=Range("G1"), Header:=xlYes