I recently upgrade from Office 2000 to Office XP.
I used to be able highlight a list of excel files and
then print.This would then print one copy of every
highlighted excel sheet.

I am trying to write a formula, that will look at a range of cells (5 of
in total) and if the number in any of those cells is between 600 and
1200 then I want to enter an amount from another cell
in lay mans terms

I am trying to copy the data from one column across one row.., in othe
words,.. i want the data to go from left to right across the pag
instead of top to bottom..
Anyone have a way to do this.., maybe  a macro or something ?

How can I make excel ogranize a block of cells by alphabetical or
numerical order. But also having the cells associated with those being
moved alos. (or just move the  rows only) I dont know you guys are the
experts.

I've written a macro which copies data over from a worksheet and then
deletes the original worksheet.  The problem is the warning associated with
the deletion of a sheet interupts the running of the macro and resumes once
the 'delete' option is selected.

Hey guys,
I would like to take one column of data and copy it across one row.,
so, I want the data to go left to right across the spreadsheet instead of
top to bottom.

My son keeps track of inventory in a spreadsheet.  He wants some sort of
alert if the number goes below 5 by either changing the number to "red" or
flash.  Is there any IF statement that can do this???  Thank you for your
help.

Can I do a mixed font with numbers, such that the cents show in a
smaller font and superscript?  Can colours be mixed with numbers, e.g.
the thousands are font 18 and blue, the hundreds are normal, and the
cents are red, superscript and font 8. (just an example, not using

hi peeps, just wondering how to use fill colour in cells but for the colours
not to be printed?
Thanks,
Steve-

I've got numbers manually entered in cells, i.e. =65+15+10.
I need to count the number of "numbers" in each cell. The result fo
the above would be "3". Otherwise, I have to manually look at each cel
and type the number of numbers I see.

    I am very new to Excel programming, but I have written a few simple macros
before.  However, I have never really worked with loading information out of a
file and then saving it back.
    I have a series of text files which contain data that I want to import.  I ran

strange problem occurring when using a workbook at work, hope someone can
help please.
everyweek workbook is copied and renamed to include current weeks date and
previous weeks figures are cleared etc, this is so each week has a record

I am trying to bring data from closed workbooks into an open workbook.
This has worked fine for most cells, just hit "=" and click on the cel
I want to transfer from.  I do have some cells that are long text cell
and need to stay together as one cell.  When I do the same thing wit

for some reason some of my cells now show #VALUE! in them, i have not
changed anything. all i have done is use the file on one pc, copy to floppy
and use on another pc, any ideas how to fix this?
the cells in question have forumlas like;

I have two tables with two columns each which I am displaying below in csv
format:
Table # 1:
Store, Sales