|
|
Formatting cells by
Doug Mc
I copied some cells from a sheet to a new sheet.
The cells I copied contained some numbers and dates.
Some of the numbers had a dollar sign on them. I wanted...
|
|
7 |
121 |
|
|
Color coding dates in excel by
Hilly
Hi ,
I am trying to set upo a spreadsheet to track stock market
purchases,dividends etc.
I have date columns, however I would like to be able to color code...
|
April 2nd, 2009 12:05 PM
by Stefi
|
7 |
212 |
|
|
|
|
7 |
182 |
|
|
Pre-programming keys by
Bill Ridgeway
In some spreadsheets I need to enter a phrase in many cells. Is it possible
to pre-program the function keys with a phrase so it may be inserted into a...
|
May 18th, 2009 10:33 PM
by ebloch
|
7 |
236 |
|
|
conditional dropdown by
aditya
i want to make conditional dropdown like this
if a1="x" dropdown in a2 should be US,CANADA,MEXICO
if a1="y" dropdown in a2 should be ...
|
May 28th, 2009 09:08 AM
by Sanjay
|
7 |
212 |
|
|
|
|
7 |
155 |
|
|
|
|
7 |
112 |
|
|
how do i expand and collapse rows by
office wreck!
I need to expand and collapse ROWS, I want main info seen and rows below it
collapsed so I can expand as needed, How do i do that?? i keep trying but
it's...
|
|
7 |
383 |
|
|
Match Function by
Melanie
Hi,
I have put together a spreadsheet to find codes, states, descriptions. It
finds the data by dates.
Columns a Dates, Codes, States, Descriptions
If I...
|
|
7 |
128 |
|
|
logical expression help please by
KRK
Hello,
What does the logical expression (A1A2A3A4) return ?
How is the expression evaluated ?
I've tried various numbers in A1....A4, but cannot seem to...
|
|
7 |
197 |
|
|
Replacement of "IF(OR( ))" by
wilchong via OfficeKB.com
Dear sir,
I have an excel formular which involve 3 cells, A1, B1 and C1. The value in
cell of A1, B1 and C1 is 2,6 & 2. I place this formular, IF(OR(A1=B1,...
|
|
7 |
208 |
|
|
"Next" button for reading NG from Internet by
Khoshravan
I am using Microsoft's site to read the posts in NG.
(http://www.microsoft.com/office/community).
There is a minor problem which wastes time.
After reading a...
|
|
7 |
198 |
|
|
IF FUNCTION by
Gulfman100
he following formula:
=IF(B3=8,IF(B7=16,(B6*12/16)+(3*B8)+(4*B9)+(8*B10),(IF(B7=24,(B6*12/24)+(3*B8)+(4*B9)+(B10*8),0))))
Works well if the first condition...
|
|
7 |
198 |
|
|
|
|
7 |
214 |
|
|
Multiple worksheets & duplicating formula by
Jackie
I have 35 worksheets; one w/s for each volunteer Each w/s has the exact
document to capture the number of hours a volunteers works and the type of
service...
|
|
7 |
249 |
|
|
Formula for adding Columns by
Gary
Please help ...I'm going mad... How do I enter a formula to add colums
together?
Thanks in advance
|
|
7 |
225 |
|
|
New at Excel and need help on a worksheet by
Jennifer
I need to create a worksheet that will have several names in a column. Next
to the names I will have three more columns that are requirements or goals
that...
|
March 2nd, 2009 11:51 PM
by Max
|
7 |
296 |
|
|
Won't Let Me Use Caps ? by
Robert11[_3_]
Hello,
Should have stayed with Excel '97
But, have upgraded to Excel 2007.
Here's a weird one:
I have a word in a cell.
Nothing unusual; starts with a...
|
|
7 |
194 |
|
|
HARD DRIVE by
DENISE
How do I find out my hard drive size.
|
March 11th, 2009 08:06 PM
by JLatham
|
7 |
153 |
|
|
Conditional Question by
H
Hi -- is it possible to do conditional formatting that would highlight the
first time a customer hits $1,000,000 or above and then in another column
look for...
|
|
7 |
123 |