the save as brings up a full screen, and i'd like it to be normal size.  I've
searched the help on every combination I can think of, and there's nothing
helpful. the normal says to change it in view, but the save as page has no
view option and escape only closes the page.

I have eleven different sub assemblies customers can choose from.  The
customer can choose 1 to 3 of those sub assemblies to complete the final
assembly.  Is there a way to consolidate the information when I do a total
materials used page so I don’t have a bunch of 0’s taking up ...

How would I set this calculated value up? Fat contains nine calories per
gram. I want to calculate the calories from fat for each food item. The
percentage of fat is calculated by dividing the calories from fat by the
total number of calories. What would this formula look like?

Dear reader,
I have a bit of a problem copying from one worksheet to another.  I need to
copy some dates from worksheet B to worksheet A.  Currently these worksheets
are set up this way

Does anyone know how to change this code to work in Excel '03?  It
works great in '07 but I think b/c the formula is too long my
associates cannot open it on their workstations.
Here is the code:

DEar Sir,
I have the following table:
   A              B                C
1  Ref          Date           Amount

I have the following code in a worksheet:
Private Sub Worksheet_Change(ByVal Target As Range)
  If Target.Address(external:=True) _
       = Range("p2").Address(external:=True) Then

I'm using Excel 2002
I'm trying to write a code to copy and paste special a range of data in the
next empty cell. Therefore if cell j5 has data it would start pasting it in
only k5 and so on. This is what I have so far but its pasting in all the

End-user reports that prior to the MS08-014 update, he would open a text
file from Explorer using Open With > Excel.  Excel would open the file and
format such that all text was placed in a single column (over multiple rows).
This is the desired effect.

i am crsting a spreadsheet where i will need to show the difference between
one set of numbers and the average set of numbers but i am not sure how to do
this.
i.e average score is 6 and their score is 4 i would need it to show -2

hi community
how am I to create a link where, example:
at worksheet A,
A1 is being formatted with 2 decimal places and is shaded "Blue"

Dear Sir
If I have formula at =SUMIF(A$1:A$20,C20,D$1:D$20) at cell F1,
May I know the quick way to reveal the formula as a text i,e.  
‘=SUMIF(A$1:A$20,C20,D$1:D$20) ?

cI have data in three columns.  Values in Column A are calculated by an if
statement and are summed and return a value in Column B, with blank fields
appearing in the adjacent rows to the column A data.  Is there a formula that
will allow for those blank cells to return the value ...

Hello! Friends
I have two questions related to Footer:
1.  I have a customised Footer in WORDS, how can I copy and paste to EXCEL?
2.  How can I copy and paste Footer from one EXCEL BOOK to another, other