I have to make a spreadsheet for the first time.   I have been paid for
a project, and I have to keep a timesheet in minutes, which works best
for this project.  The time I’ve been paid for comes to 4,590 minutes.
I will have 4 columns: date in A, description of specific task in B ...

I am finding that I cannot place (R), meaning a capital R between two
parentheses in to a cell.    Excel always replaces that with a smaller
capital R in a circle.
What's the trick to getting the (R) to show up?

I get messages about hidden modes when I open excel 2007. How do I unhide
whatever the software is having trouble with?

is there any way to insert a row with all formulas from the row above?
Thanks and greetings
Udo

"" generates a zero-length string, not a truly empty cell. This is
causing problems elsewhere. I'd like to find an output for an IF
statement that will give me a truly empty cell. The current formula
is:

Name  Type   Amount
A           P       10.00
A           P       20.00  total 30.00
A           R       15.00 total 15.00     grand-total 45.00

Hi to all,
I have a "custom view" named "main_cat" that hides some rows and colomns.
how can have this done using a macro to show this view of the sheet.

I'm trying to get this SUM calculation:
=SUM(C24:C29)
to display an answer only if one or more of the cells in the range
C24:C29 contain a value. I have tried this:

How to copy unconditional formatting to the below 10 rows? For example
H2,J2,L2 is having "Bottom 1 items" formatting.
How to copy the same formatting to the below rows?
Thanks for any replies.

I have a worksheet with a cloumn where I am using validation with a list of
values on another sheet. So, for the column to be validated, in the
validation window I have "List" in the allow box, and "=clientlist" in the
source box. On the other sheet I have 6 values in column A ...

I have just started using Micrososft Office 2003 for Excel and noticed that
the options for showing negative values is only a negative sign.  I was
wondering if there is a way to change this to parentheses as I was used to
this idea in the older version.

I've just been surprised to come across reference to the <space>
intersection reference operator.  Surprised because I've used Excel for
years and consider myself reasonably advanced but have never come across
this before, i.e SUM(A1:A6 A5:A10).

I would like to display, in one cell, the average of all values in row
2 where "beg" appears in the same column of row 1.
For some reason I am incapable of getting the search terms for this
correct - I'm sure this must have been covered in a previous post!

I have an alternating set of three columns, labelled (in row 5) Beg,
Mid and End. They represent the beginning, middle and end of each
month. Row 24 contains values for these periods. I would like to
calculate the average for all Beg columns, for all Mid columns and for

I have one workbook which is a template for Order Forms and another
that is the Product Listing. I am creating a userform in the Order
Form.xls. When a Part Number is entered on the Order Form, I want to
open Product Listing.xls and look up various fields on that record.