I have a report (worksheet) that stores my "item numbers" that look like
numbers as numbers.
I have another report (worksheet) that stores all item numbers as text.
I am trying to do a vlookup from the first report to the second report but I

I have Excel 2002 SP3 but another user has 2000 SP3. I created a big
worksheet but only want him to be able to edit 1 column, so I used the Tools

column. When he opens it in 2000, he can not edit anything ...

As a new user to excel I am thinking of setting up a data base of my music.
The total number of tracks is in excess of 70,000. I have seen a simple
solution using excel which would be ok but I'm not sure if I can have 70,000
rows in one work sheet. A friend has suggested access ...

I have a dilema.
In A1 I have (for instance) $100.00
There are other cells that I need to add to A1.  I know what I need to do is
use an IF statement and I can do that.

How do you you give your workheet a title, e.g. 'Prodect Sales' in the middle
then the cells below as usual?

Hello. I need help with this, it's 2 cells telling 1 cell what to do
is what I can get.
I have 3 cells I'm working with A1 A2 A3
cell A1 needs to display a YES or a NO depending on what cells A2 & A3

When I protect a sheet, i get a message when i goto a cell that is fully
protected that i cant chagne the contents.
well i know this,  that was the whole point of protecting the sheet.  how do
i get excel to do what access does in forms...   ie when i go to a fully

I'm making a table to keep track of deposits, credits, etc for a bank
account, with a running balance. Here is the basic layout:
Column b = date of entry
Column c = credits

I'm trying to add-subtract various numbers. One column will be nothing but
withdrawals from an account, so I want every number to be negative, so that
if I do calculations with that column, they will always show as deductions.
Is there a way I can set up the cells in that column ...

пока использую эксель для распечатки прайса
разным клиентам- разные цены
данные берутся из одной таблицы
в зависимости от того какую цифру ставлю в нужном окошке функцией

We have a large Excel 2007 document with a lot of pictures. Viewing
the document normally, the pictures all look fine, but when either
previewing or printing, the further down the spreadsheet you get, the
pictures are moving down the page.

I need help on this:
I have a worksheet that has a list of emp names and address/phone#s
etc.. ( 300 + names)
I have a form that need to be populated with this information.

I have about 12 graphs each with 4 data sets that I have to change the
data set range on each month to display the next months data as it is
accumulated through the month.  This is a very time consuming task.
Is there a way to set the data range to key off of a formula (using

I am working on a spreadsheet with numerous text entries in all uppercase and
would like to change to lowercase. Is there a simple solution to this matter?

Excel calls a worksheet that has a initial row consisting of labels a what>