I am working in a 2-page document, but I have 8 pages (6 of them are just
blank), I like to work tidy, so how do I reduce/cut the excess pages please?
Thanks
Paula

When I insert a bullet or number in Word, type something and enter, a second
bullet or number appears automatically on the next line enabling me to make a
bulleted/numbered list.
However, in excel when I do the same thing and enter, it takes me to a new

i have one cell a1 that has this in it
Tuesday, November 06, 2007   
ii the next b1 i would like to put
@7:30pm

Is there an efficient way to format columns for the date, time, and day of
week, and then reference that data in statements, for example using an if
statement assume a certian value for each month/day of week/time of day?

If I add a column to an existing workbook/sheets...do I have to recreate
existing macros in that workbook..or will they 'auto-adjust' to the new
column inserted ?
The existing macros work on various columns with different functions

How can I format a column so that any long text entered in any cell in
that column will wrap automatically? I have the 'wrap text' box ticked
but any new text entered does not wrap.
Regards

Thanks for the response.  Working perfectly!

How do I calculate out months
example: enrollment date 10/11/07 , 6 months later, 12 months later
Thanks

Thank you for reading my post:
My goal: create a locked down timecard spreadsheet for each employee
Is it possible so that each time an employee enters a "time in" or "time
out"; each                     respective field is then locked for editing?

Hi Bob:
First thank you for the help. I did as you said, but I am not sure I placed
the text string in the right place. I pasted it in View Code on the blank
area to the right of "Project / Properties" but for some reason it is not

I know how to select a range of cells and copy:
   Range("O2").Select
   Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
   Selection.Copy

I have a spreadsheet in which I need to be able to track a patient at certain
intervals from date of enrollement.  For example,  If I have and enrollment
date of 10/11/07, I need to know the exact date for 30 days later, 90 days
later, 6 months later, 12 months later.  

Excel 2003
I have following information in columns: Name, arrival date, departure date,
cost.
I would like to create a pivot table showing total headcount and cost on a

Hello, this may be kiddstuff to yuo but a huge problem to me and I'm sure
I need to insert the * character ex.
the value in cell A1 is 1
I want to change it to *1*

Is there a way to enter a date value that is between 2 dates in sumproduct
or another function that will look at the same column and return the sum of
a different column? If the value is greater than May 1,2007 but less than
August 31, 2007 in column A it will return the sum of ...