|
|
formula for conditional formating by
jockj215
Hi'
I have a spreadsheet (excel 2003) with data from a data base in one of the
cells is text which is free typed in the data base and I want to find the...
|
|
5 |
125 |
|
|
Excel 2007 autofit row height by
tinks
Has anyone figured out a way to get this to work right yet? I have no merged
cells and wrap text is on. Very frustrating.
--
Thanks for the help
|
April 29th, 2009 05:03 PM
by tinks
|
2 |
117 |
|
|
how to view font color in excel 2007 by
cinamom34
I cannot view the font color changes in excel, but the changes are on the
printed page. How can I view the color change in the excel workbook?
|
|
1 |
124 |
|
|
If Formula confusion by
Swtmelly
Good Morning, I need help with the following:
Gold pins go to employees with 30+ years, silver pins to employees with 25 -
29 years. I can't figure out how...
|
|
4 |
104 |
|
|
SUMPRODUCT column criteria by
GD
Can anyone tell me if an entire column can be used as criteria in a
SUMPRODUCT formula? I tried: =-SUMPRODUCT(--('PS Sales'!$K:$K='Jan
09'!I$1),--('PS...
|
|
3 |
118 |
|
|
Data Validation with linked File by
Jack
is there a way to do a data validation to a seperate spreadsheet that is not
open. I have been able to do the validation to the spreadsheet but it must
be...
|
|
1 |
146 |
|
|
Arrows dislocated when printing by
postscripter
I have a 2003 excel file which has many arrows (autoshapes)... once we
upgraded to office 2007, these arrows appear bit moved (dislocated) when
printing or...
|
|
2 |
109 |
|
|
Getpivotdata with a lookup functions by
Shaggyjh
Hi,
I have a worksheet called "summary" and cell A119 picks up data from another
sheet. Cell A119 contains a name from this other worksheet "Allotments". ...
|
|
1 |
85 |
|
|
Delete object code by
Marie Bayes
Hi
I have the following code:
ActiveSheet.DrawingObjects.Select
Selection.Delete
However, if there are no objects to delete the code deletes the cell...
|
|
1 |
116 |
|
|
Combo box formatting by
Erol
I am trying to format the text size inside the combo box. Is there anyway to
do this?
I am using MS Office 2000....
(I don't prefer to use Data Validation...
|
April 29th, 2009 03:29 PM
by Erol
|
2 |
105 |
|
|
|
|
5 |
118 |
|
|
Formula Help - Urgent by
DL
I have info that looks like this:
AD0# Cost C D E F
A B A 6567 6568
6567 $2,200.00 B $2,200.00 ...
|
April 29th, 2009 03:03 PM
by DL
|
0 |
74 |
|
|
|
|
4 |
149 |
|
|
|
|
4 |
94 |
|
|
Sorting Datain a Shared Workbook by
Az
I have an odd problem. I have a spreadsheet with 40 rows of data with columns
from A to V. I then have two blank columns and then in columns Y to AB I have...
|
|
1 |
87 |
|
|
|
|
1 |
144 |
|
|
SharePoint and Shared Workbooks by
DOUG
Does SharePoint override the ability to share MS Excel workbooks? (I want to
enable more than one person to update a workbook at the same time in MS
Excel. ...
|
April 29th, 2009 02:05 PM
by DOUG
|
0 |
91 |
|
|
Previewing Totals in highlighted cells by
Michael V.
When working with values entered in cells if I highlighted a group of cells I
could get a total value displayed in the lower corner of the screen. I don't...
|
|
1 |
108 |
|
|
Delete blank rows by
Marie Bayes
Hi
Wonder if you can help. I would like to put in some code to automatically
(on open) do the following:
Find the cell (in column A) with the word "Date"...
|
|
5 |
105 |
|
|
My clock by
Pietro
Hi,
I put the below formula in the cell A1, i need to refresh it every one
second so that it might look like a clock, can anybody help?
=NOW()
|
April 29th, 2009 01:57 PM
by Mike H
|
1 |
112 |