|
|
|
|
1 |
830 |
|
|
|
|
3 |
837 |
|
|
|
|
2 |
779 |
|
|
Date format clarification by
Blue Max
When a user selects the 14-Mar-01 standard date format in Excel 2007, then
selects the custom format option, this is the standard format that...
|
|
6 |
867 |
|
|
Linking Excel Tables by
Blue Max
Is there any way to link two separate Excel tables so that the data flows
between the tables and sorts as if the two were just one table?
We have worksheets...
|
|
2 |
748 |
|
|
|
|
1 |
776 |
|
|
|
|
1 |
752 |
|
|
Count Days until Completion by
Pat
Is there a way to count days (with a date enter in Start Column) until
"Completed" or "Cancel" is entered in my Status Column?
Right now, it is calculating...
|
|
2 |
756 |
|
|
Border Limitations for Conditional Formats by
Blue Max
Unfortunately, we have observed that the conditional format feature appears
to limit the choices for borders. For example, the user can select both
solid...
|
|
3 |
697 |
|
|
|
|
1 |
826 |
|
|
compatibility mode by
[email protected]
I am a new user of Excel 2007 and have previously used Excel 2002.
I have received an Excel sheet which opens in "Compatibility mode" and
as "Read only"....
|
|
3 |
747 |
|
|
|
April 4th, 2010 10:59 PM
by AltaEgo
|
3 |
730 |
|
|
using dmax by
dbasmb
I want to find the max temperature for each day of the year over 10 years
worth of data. I can do it by using a criteria where the first in the range
of the...
|
|
2 |
789 |
|
|
dynamic named range by
Gadeyne Dries
Dear all,
Hope you can help me with the following.
I need to create a range (Dynamic range).
As all of you are awa Insert-Name-Define...
However, the name...
|
|
3 |
636 |
|
|
|
|
2 |
679 |
|
|
|
April 2nd, 2010 01:16 PM
by JLatham
|
3 |
669 |
|
|
|
|
2 |
655 |
|
|
How do I rename my columns? (i.e. - A1) by
Novice
Just trying to get specific info at the top of my spreadsheet where (A1, B1,
C1....etc) are. Not sure quite how to do it. Any assistance would be...
|
|
2 |
594 |
|
|
Extended IF Formula by
Barny[_4_]
I use this formula to return the value in cell if the criteria is met
but I would like to extend this to say that the value is also returned
if cell J89 =...
|
|
4 |
642 |
|
|
classic pivottable layout by
Dan
I want to know how can I set the default for the classic Pivottable layout in
version 2007. I've tried the pivottable options display tab and checked
the...
|
|
5 |
779 |