|
|
Calculating age from birth dates by
John Nall
I need help with a similar problem. I am making a spreadsheet with the
names, DOB, and DOD dates for persons in a church cemetery. I am having
trouble with...
|
|
2 |
1,641 |
|
|
Comment boxes by
Martina
Hello experts,
If you have a large spreadsheet set to view at say 60% how
do you make the comment boxes readable??
kind regards
Martina
|
|
1 |
1,472 |
|
|
|
September 15th, 2003 08:05 AM
by beppe005
|
1 |
1,339 |
|
|
Don't show Zeros by
Morpheseus
I know I've seen this somewhere but I cannot find it. I looked all day with
no luck. I have to ask what I know is a simple question :(
I did up an invoice. ...
|
|
2 |
1,623 |
|
|
Trim function limitations by
Boz.theale
I have imported text from another application and want to convert the
contents of cells into a continuous string - ie like trim but removing
all spaces,...
|
|
2 |
1,724 |
|
|
excel custom menu by
Lynn
Thank you!
A problem is that when a user click on a chart in the
workbook, the menu is no longer showing on the
commmandbar. Until user clicks somewhere else...
|
|
2 |
1,882 |
|
|
MS.Excel vs Works Spreadsheet by
Excel Gure
I am confused, why does Microsoft have two excatly alike
products on the market? Office XP and Ms. Works? Works is
is around $50 and MS Office XP sells for...
|
|
3 |
1,419 |
|
|
|
|
1 |
1,167 |
|
|
split worksheet by
patrick072040
Can you split a worksheet in half vertically, but scroll vertically on
both?. For example, have cells j1..l8 stay put, when scrolling up cells
a1.I100 ?
It...
|
September 15th, 2003 01:00 PM
by Jim Rech
|
3 |
1,356 |
|
|
Time-of-day Average by
GBL
Hi:
Cell designations are H8:H51.
I used your entire formula. But didn't understand where you got the "hhmm"
designation.
My military-time cell examples a...
|
|
2 |
1,043 |
|
|
sumif function by
Dee
I am trying to use sumif function to add up a range in
excel using color as "CRITERIA". Is this possible? or is
there another way to go about it? Thanks.
|
September 15th, 2003 01:24 PM
by JMay
|
5 |
1,111 |
|
|
Numbering rows for sorting by
Dan
If i understand you correctly try this:
Say you want your numbers from A1 to A1000
In A1 input the number 1.
In A2 input the number 2.
Hilight (select just...
|
September 15th, 2003 02:08 PM
by Andy B
|
1 |
983 |
|
|
Combo Box & Linked Workbooks by
D B
I have two questions:
1. Drop Down Boxes: Is there a way to actually convert a
cell(s) to be a combo box? The only way I have been able
to achieve this is...
|
|
1 |
1,241 |
|
|
Excel column headings by
Wayne
EVery time I open EXcel for a new worksheet, the columns
are shown as numbers, the same as the rows. How do I
change it so that they are letters? Makes it much...
|
September 15th, 2003 03:01 PM
by Andy B
|
1 |
1,011 |
|
|
Notes by
Pinda
Is it possible to have a note attached to a phrase rather
than a cell?
So where ever that phrase may be duplicated within a
worksheet, it will carry the same...
|
|
1 |
1,043 |
|
|
Excel "IF" function problem by
Johan
Our domain uses group policy to configure user rights on
the workstations, and it appears that on certain machines,
or rather under certain user profiles, the...
|
September 15th, 2003 03:08 PM
by JM
|
2 |
1,214 |
|
|
VLOOKUP problem by
Crystal
I'm using the VLOOKUP worksheet function and I'm having
some issues with the result affecting my other formulas.
Instead of the lookup returning "#N/A" when it...
|
September 15th, 2003 04:03 PM
by Anon
|
1 |
987 |
|
|
Pivot range update on mulitple tables by
aablank
I am using the same range for a number of pivot tables. If
I add to the data, is there a way to update all of the
tables at once? Right now I need to update...
|
September 15th, 2003 04:12 PM
by aablank
|
0 |
1,141 |
|
|
excel.exe program error by
Dawn
I have a spread sheet that I'm running macro's in, and it
keeps coming up with the error message
"excel.exe has generated errors and will be shut down...
|
|
1 |
1,029 |
|
|
Selecting from a list by
Mike
I want to be able to select from a list based on the contents of
another cell.
For example, in A1 I can select the value from a list of 4 options.
Cell B1 has...
|
September 15th, 2003 04:46 PM
by Anon
|
1 |
1,183 |