Hi Gang,
I work inventory control for a company in Texas and have to check stock
levels for around 15 parts daily. The download for these parts contain
an additional 1000 other rows of part numbers I dont need. I have used

Greets All
I would like to make/add a pattern for a background cell in excel how can I
make one and add it to the options in excel to choose from?
Tia

Hello, all [=D
 What's probably a very simple format-setting has got me baffled....
 I was copying some columns & then pasting them (paste special >
values) into a fresh worksheet, in order to get rid of all the tick

Can I set up as an excell tool bar on my worksheet a shortcut to format the date for cells...  mmo/dd/yy....  
Can format "," for decimal place value number, but what about a date format shortcut as an excell tool.
Thanks for help if you can....
Will save much work when formatting ...

I have searched for the method needed to change the default size of a
comment box.
I know how to change the font and user name and shape of the box.
I also know how to change the size of a comment already entred by

I am trying to teach myself VBA and have just been pulling my hair out with
the following:
Public Sub name1()
Dim x As String

I have an inventory .dat file that I need to convert to excel so that I can
import it.
Please advise how to perform this task?
Thank you for your time and consideration.

I would like to lookup a users ID in a table and check if they have a
paticular qualification, a normal VLOOKUP will do that but then I would like
to refer to a date in the header to see when they gained the qualification
so the cell can determine whether they are qualified based ...

Where can I obtain property management accounting files?

Rotating excel spreadsheet for use in photoshop/ using diamond cells tia
sal2
Greetings, All
I'm trying to get the basic spreadsheet that has square cells that looks

I have a column of data (numbers) which I want to turn by 90 degrees and
make it into a row. I think this is called 'transposing'. ?
I thought there was a transpose option on the data menu, but can't find it.
?

I am trying to source a simple inventory template for my wife`s jewellery
for use with our home insurance.  It need to be able to total the amount
each item costs.  I have looked at the MS template site but the only one I
can see uses the US dollar and I require it to be in British ...

sometimes when I enter decimal fractions Excel thinks this is a date. How do
I stop this?

Under Tools there is an option to hide BOTH Row& Column Headers.
How do I hide ONLY the column headers?

How can I hide gridlines ONLY for selected areas of a worksheet ?