Is there a way to ensure that all of my cell comments will always display within the comment box.  I
have noticed that different "ZOOM" values force the text to scroll past the box's borders, or the
other way they leave too much dead space.
Can this be mitigated?

I have a quick question.
I upgraded to Office 2000.  Now whenever I open an excel file from someone,
it says "Microsoft Excel recalculates formulas when opening files last saved
by an earlier version of Excel".  Can I make this automatically save so I do

I have created a large spreadsheet with tons of blueprints linked to it.
Now I  want to send this file to my customer. The file is over 10 megs so I
burned a copy. My problem is I have all the files on the disc, but the links
don't work . Are the links looking for the source on my ...

Hi...
If a have five columns of data, and use "AUTO-FIT" (or
AUTOFORMAT) to be able to size the five columns widths in
order to be able to view all the data, how can I SAVE this

Some cells in my worksheet are fed from a dropdown (validation) menu. I
would like the background colour of individual cells to change automatically
depending on which item is selected from the menu. Is this possible with
conditional formatting or VBA? I'm very familiar with VBA in ...

Good Afternoon.  I hope someone can help me with this.  I working on a
project for a client in which they have an existing Excel Spreadsheet that
has about 8 fields with about 700 rows of data.  I have another user that is
storing data into a Access database, and I want this data to ...

is there a excel viewer supported by windows XP home
edition?

I was just wondering if there was a way of Excel showing a numbe
without rounding it off?
When I enter a number like 7.8, it rounds it off to 8.0, and i was jus
wondering if there was a way to stop this from happening as i woul

Hi, I have a question.
I have a excel file shared with 10 persons throught the net, but eac
needs to see differents data in differents ranges and I don?t want the
see all the data.

I have a worksheet where I have created a macro. When I email this worksheet
the recipient gets it without the macro. What am I doing wrong? Please
advise.
---

Does anyone know if there is a formula that would allow me to count th
number of times a specific cell format (Text Color) occurs in
column.
Thanks,

I am embarrassed  to ask, but here goes.  About a year ago
some of you on this forum  explained how I can divide a cell
without creating a whole new row.  I can't remember how I
did it.  With a diagonal line?  A horizontal line?  A vertical

I'm using Office  / Excel XP.
How would I go about creating a column that contains the row number that
corresponds to the cell in the column and automatically inserts the next
number in the cell below into that cell? Basically, I'm wanting to create a

Here's what I'm trying to do, and I haven't had much luck with it yet. I've got six items, let's say in A1:A6. Some items may be repeated, but not necessarily. I need a quick way to set up Excel to arrarange the items in all possible groups of 3, 4, 5, and 6. These groups can't ...

I have a worksheets that is 500 rows long. I want to limit scrolling to the
end of the worksheet. Is there a way to do this? Can't use hide rows, 'cause
it goes on forever...
Also, is there a way to limit the scroll from side to side? I.e., If the