I have PivotTable in Excel 2003. In "Row Fields" there is dimension called
[DepartmentEmployee] which consists of [Department] and [Employee] levels.
To hide rows I used the following code:
Sub Hide()

I have an excel file that has one column for Product No (alphanumeric).  I
have found that some of the cell are displaying Scientific Notation (e.g.
4.00000e+016) even when I specified the formatting to be text.  The only way
I could get them to show as 40000001235 is to go to ...

When I type a forward slash( / ), it won't type, but it highlights the "File"
heading.

I'm trying to determine how a series of dropdown lists were created in an
existing Excel worksheet that I'm editing.  Row 1, Columns A through G have
dropdowns with extensive lists in each.  If I click on Row 1 itself I see the
apparent name of the Row, "Print_Titles".  But I ...

I have a workbook that contains anywhere from 10 tabs to 70 tabs - I am
trying to update my header to reflect 4th Quarter dates - I grouped all
worksheets together and then went into my set-up, but when I make the update;
save; ungroup all worksheets...it's only changed the ...

If I go into Word, and choose Insert/Object/Create From File, Browse, and
find my existing Excel Workbook, only the first Worksheet is inserted into my
Word document.
If I go into Word, and choose Insert/File, and find my Excel Workbook, I get

When I use the double-underline or any of the other underline features in
"Borders", the result is a light colored gray that is hard to see when
printed out.  How do I darken this?

In Excel, is there a way to find out the character width of the data in a
column?
I have a column with 60,000 records and each record contains Street names. I
want to know what is the longest possible street name. I also want to look at

Is it possible to create multiple tabs each being named after a particular
cell.
For example:
a1     Apple

The following macro inserts two new selections to the menu which appears when
you right-click on a worksheet:
Sub Add_Controls()
   Dim i As Long

Why
width units relation is 3 units/26 pixels
and
height is 3 units/4 pixels,

I'm not looking for volumes of info on this one.  (Um, that doesn't mean I
wouldn't appreciate it, though!  LOL)  I just need a jump start so I can
figure out what to do to get started.
I have a workbook with about 50 sheets.  4 of the sheets get data, dumped

This is a new one.
Using the SUM function in XL 2003 to sum up a series of cells:
=SUM(G10+G16+G37+G52+G127+G156+G178)
All of these cells have values in them, which are themselves sums of other

If I have a spreadsheet that in column A= seconds.  I want to take the
seconds in col a and  in column b make minutes, then in column c, the minutes
to make hours, and then in column d, the hours to make days.  I do not know
how to divide to get the correct answer in each of the ...

I want to run a macro and then be able to choose files on my computer, then
save the chosen file location as a variable.  Is there anyway to do this?
Sub Macro()
Prompt: Choose filename