|
|
|
November 5th, 2008 09:28 PM
by Bob I
|
8 |
87 |
|
|
Printing excel by
cupidsbelle
When I send a report to the printer, an annoying box pops up to tell me it
has gone to the printer...Anyway to disable it? I am not the only one that
finds...
|
November 5th, 2008 09:20 PM
by Bob I
|
6 |
85 |
|
|
|
November 5th, 2008 09:19 PM
by MAK
|
0 |
81 |
|
|
Duplicate formula by
Mark Allen
I am using this formula to de-duplicate a spread sheet
=IF(COUNTIF($A$2:A2,A2)=1,"First Occurrence","Duplicate")
However, if one cell has a "9" in it and...
|
|
2 |
70 |
|
|
Excel 2007 - Hide & Unhide Columns/Rows by
leahl[_2_]
The tool tip that appears when you cursor over the Unhide Rows and Unhide
Columns doesn't work --- rows - Ctrl+( and Columns - Ctrl+). The Hide Tool
tip...
|
November 5th, 2008 09:17 PM
by Bob I
|
8 |
90 |
|
|
If/Count/Sum formula in Excel by
Steve C.[_2_]
A B C
1 20 1 1
2 20 1 1
3 20 1 0
4 40 1 1
Above is an example of the data I have. I want to check column A for a
value of 20, and then...
|
November 5th, 2008 09:11 PM
by Mike
|
1 |
73 |
|
|
fitting within a range by
rory_r[_2_]
I'm trying to compare 2 sheets and highlight any discrapancies from the first
sheet.
Currently sheet 1 (IM) has a column of procedures, a column describing...
|
|
4 |
57 |
|
|
Pictures Move by
KJ
Ok, I have a price sheet I'm trying to create and like to have line drawings
of the product on the sheet. The picture is large, larger than just the one...
|
November 5th, 2008 08:58 PM
by KJ
|
2 |
60 |
|
|
document by
JM
how do I save a document so that when I send it to someone else they can not
change the format when they start typing on it?
|
|
1 |
67 |
|
|
conditional formatting bug? by
joemeshuggah
curious to know what might cause this...
=MIN($F$10:$F$17,$F$19:$F$22)
this is the formula i am using for a conditional format (the min value is
highlighted...
|
|
2 |
60 |
|
|
|
|
4 |
83 |
|
|
|
November 5th, 2008 08:29 PM
by rolando
|
9 |
87 |
|
|
Move Comment into cell as Text by
Frances
How do I move comments into cells as text?
or use vlookup to pull comment to another sheet?
--
Just Computing
|
November 5th, 2008 08:22 PM
by Frances
|
2 |
69 |
|
|
|
November 5th, 2008 08:18 PM
by mdavis
|
0 |
65 |
|
|
Inserting rows by
Raynelle
I have a spreadsheet that I need to insert rows. However, after i insert
rows, then go to enter data in a cell, everytime i start to type data, a new
row is...
|
|
1 |
70 |
|
|
Changing Default Paste behavior by
D Riggins[_2_]
Is there any way to change the default bhavior of the paste operation so that
it pastes values only (without having to use Paste Special).?
|
|
1 |
95 |
|
|
Maximum date in a Month by
Steve
Is there a way, using a macro to calculate the last date for a month when the
fist day of the month is input?
examples:
Input 10/1/2008
Result...
|
|
4 |
67 |
|
|
Merge cells by
Hollister
I have an excel spreadsheet where the first column is frozen. In cell A1 we
enter our project name which always ends up overflowing into the next cell.
This...
|
|
4 |
50 |
|
|
|
|
17 |
141 |
|
|
Data Validation by
LeeCC
Hello! Friends:
Appreciate if anyone could help on the followings (EXCEL 2003):
My data are stored in Col A (say, A1.A10)
Under...
|
|
5 |
138 |