I have chosen to freeze panes in an Excel spreadsheet with three rows at the
top of a table and two columns on the left. The table covers A1:S364.
The problem arises when I review the notes (at the bottom after a table) and
the title of the page once printed.

Can anyone tell me how to link the data in A7 (item) to B7 (description) and
E7 (price) in worksheet 1, then link all above data to worksheet 2 by
clicking A7?
Please tell me how to do this. I have a price log (worksheet 1) that I am

I have some basic knowledge of Excel but have never taken advantage of all
its operations.  Since there are so many, where would anyone begin to learn
them all?  This week I go to an Excel refresher course but boss has said
learning Excel tables and analysis tools will be ...

I have taken an existing Excel 2002 Invoice and used it as a starting point
to create new invoice.
Everything seems to work fine, except in the totals column I cannot enter
any formulae.

As the IT Director for a county commissioner, I've been asked to visit our
rural office today to give a "training" to 5 volunteers on data entry using
Excel 2003.
The volunteers have little or no experience using Office or Excel.....

Good afternoon,
I want to subtotal only numbers over 30 that are not hidden and don't know
the formula. Can anyone assist me:
                A

Good morning:
Does anyone know of a way to print an Excel document from a command line?
Thanks,
Al

I have 20 cells in a single column in a sheet called "Audits"
All the cells have a formula in them.
The formula is a simple one that reads whatever I put into a cell on a
different worksheet called "Names"

I am creating a spreadsheet that calculates a person's time on the
job.
It looks like this
Inclusive Dates (Begin)    Inclusive Dates (End)        Totals

I'd like to automatically highlight the subtotal row for a set of data
based on the category of information.
For example a collection of "Apartments" is classified as
"Residential" and i'd like the row with residential to be

I am trying to set up a sheet that has General sales Tax on it.  Now in one
colume i would like to put the subtotal then the next colume I would like for
it to automaticlly add the 6% GST and then the next colume have the total of
those two columes.

The following does work, but how is the question.
=SUMPRODUCT((range_a < c3)*(range_b>=c9))
When input individually i.e. =(range_a<c3) produces either TRUE or FALSE and
same thing for =(range_b>=c9). But as a whole it does produce values like

I have a lookup that doesn't work unless I move the last column of the sheet
being looked up to the first column. How can I get it to look by the last
column? Unfortunately it is another workbook and can't be moved. I have my
current example below. Thanks

I have raw data like this showing what % of their time was involved on a
project.
        JAN    FEB    MAR
A    Tom    .25        .5

During the execution of a macro I use ListBox and MsgBox. Is it possible to
have certain words/text highlighted in Bold and/or Italics?
If I have the following text that is displayed in a ListBox:-
“The sheet that needs the data to be extracted should be called MASTER DATA.”