I have 2 worksheets. Each worksheets has a vertical list of part
numbers (1 sheet has 888 rows and the other has 956.  They SHOULD be
identical part numbers on each sheet but they obviously are not. In
actuality, each page contains part numbers that don't exist on the

I have the following problem with Excel 2007:
When saving files in previous version (2003), quite often Excel
crashes or it fails to open these 2003 version files (saved by itself)
and also crashes.

I have looked for the solution to this, but have had no luck. I need
to link multiple excel spreadsheets to a master spreadsheet, where
each sheet on the master would represent one external spreadsheet. If
the info on the external spreadsheets are changed, the master should

cannot send excel 07 files to anyone that does not have excel 2007
how do i get this file to them
cannot convert to PDF does not work- adobe does not support this file is the
error i get

i have200 rows in sheet- there are lets say 100 rows the title shipping
i have another 100 rows with the title payments.
they are in mixed in and not grouped together otherwise i could highlight
them all together and delete-how do i delete all the ones that say shipping

I'm trying to copy a table containing text, decimals and fractions
from a word table into excel. How can i stop the fractions from
becoming dates when pasted?
ie. 1-5/8 becomes 1/5/2008 and 9/16 becomes 16-Sep.

Step 1: I have range of numbers lets say 50, 25, 30 and so on....
Step 2:  I want to find 10% of of the range in above ex 5, 2.5, 3...
Step 3: The numbers to be rounded of to  5,3,3.......
The following will help for first 3 steps i.

I am having difficulty with measuring the width and heigth of cells. I can't
figure out the formula if  I want to set the height to .5  inch and the
width to 1.5 inch. Under View, Ruller bar is checked but greyed out. I can't
get any ruller bar (horizontal or vertical) to come up ...

I have a worksheet which I can correctly add/subtract time vaues.  But
whenever I try and add/sum reults I do not get the answer in either hrs or
hours and mins
see below

Ever found difficult to change case of text in Microsoft Excel, just
try this free, easy to use, add in
http://exceltemplates.blogspot.com/2007/09/microsoft-excel-change-case.html
You can change case to lower, upper and proper case.

Ever found difficult to change case of text in Microsoft Excel, just
try this free, easy to use, add in
http://exceltemplates.blogspot.com/2007/09/microsoft-excel-change-case.html
You can change case to lower, upper and proper case.

[excel 2000]
on status bar, you amy select function to present, for example, sum of
selected cells
problem is that on my excel, there is written "total sum=2E+06", which is

I have difficulties seeing/locating the cursor box in Excel XP v2002.  Is
there a way to get a darker cursor box?  I seem to remember seeing some kind
of VB routine somewhere that would do this trick.

This code below compacts the access database, but is it possible to do
it in vba code from excel?
Sub compact_bd()
Dim strDBtoBackUp As String

Hi all, is anybody can tel me how I can send small range of my work sheet by
mail though out look express
A perticular range contains a data (Report)
as and when i change the dropdown box data will get updated, each time drop