I have a particularly tricky function that I'm troubleshooting by
splitting the parts into different cells. I have the various cells
adding up correctly, but still i have a typo or some problem in the
original cell formula.

I have a text spreadsheet index with 5 columns of information that has a
various number of wrapped phrases in each cell. I would like to add various
numbers of blank lines in some of the cells to make the information in the
columns line up horizontally. Could you suggest a way to ...

In Excel 2000 I would like the user to insert rows for data entry, but those
rows require functions.  I don't know how many rows the user will need, but
shouldn't be more than 15.  I've considered putting the formulas in and
hiding the rows and having the user unhide rows, but ...

Using XP and Office 2003
My husband got a new computer and was able to copy his normal.dot file over
which kept all the modifications he had made in Word to things like his
toolbars, etc.

I'm trying to create a formula to minus one date from the next. So i've done
the standard equation in column d (=c1-b1) and i get my answer. but in some
cases some cells in column b are not filled in. so in column d i get these
really big numbers. i dont want those numbers there ...

Just got 2007, and I've been playing around with it.  Two questions
1.  Can you scrunch the toolbar (or ribbon I guess they call it)?  In
other words can you make it narrower?
2.  In lieu of the above, can you make 2007 look like your 2003, or

Is there a way to combine validation types on a cell?
What I would like to do is force the cell value to be either a whole number
or a selection from a list.
Is that possible?

I'm using Excel 2003 and would like to insert a tab character inside a
cell. I have tried CTRL + ALT + TAB to insert a tab chacater inside a
cell but nothing happens.
Does anyone know how to enter a tab character? Thanks

in the following program if there is no value in the cells a1 and b1
it returns 0
Public Sub Add2Cells()
     Range("C1").Value = Range("A1").Value + Range("B1").Value

I know this has got to be so easy I'm gonna kick myself when I see the answer but how do I copy a group of cells say
a1-a10 that have the following formula
A1=LEFT(H$293,J$293)
A2=LEFT(H$345,J$345)

Hi. Is it possible to move a row or rows to other places using drag and drop?
Right now I insert a new (empty) row in the place or places I want to paste,
then I copy the row or rows I want to move, paste it or them in the empty
rows and then go back and delete the rows that have ...

My CRM system creates an Excefile with sales statistics.
But the figures are in text format with a space insertet after the thousand
figure.
When i try to use the VALUE formula it does not return a value due to the

I have a workbook that contains several macros that I want only some
of the users to be able to run.  Is there some way that I can add code
to these macros that will require the user to enter a password in
order to get the macro to run?  Or is there some other way to

Sometimes when I create an Excel document in Excel 2007, it is somehow saved
into the "recent items" category, and sometimes in the regular documents
file.  Why does this happen, and how can I move docs out of the recent items
folder?

I found Excel templates for almost everything imaginable, so there must be
one for a birthday list.  I want to track people with dates and maybe a
column for a gift and card.  I want to be able to sort by name as well as by
date.  Is there one?  Thanks.