|
|
auto height by
lgreggs
I have merged cells across the bottom of a worksheet for a comment area. I
have formatted the text to wrap. How do I get the area to auto format the
height?...
|
|
1 |
184 |
|
|
|
|
7 |
159 |
|
|
|
|
4 |
186 |
|
|
Wrap text in cell by
HerbertB
It seems that wrap text and autofit row width and row height have a limit.
Any idea where to change this limit?
I have quite a large text in a cell and when...
|
|
1 |
155 |
|
|
|
March 12th, 2010 07:12 PM
by JGT
|
5 |
211 |
|
|
Repeat Rows but not on every page! by
AndreaW
Is it possible to set the repeat for just a certain number of pages, not all?
Example: I want to repeat $2:$2 on page 1 through 6 but I don't want the
repeat...
|
|
1 |
185 |
|
|
|
|
4 |
156 |
|
|
Highlight Cell that contains invalid email format by
Gareth_Evans (InterCall EMEA)[_2_]
Hi again, I've been working on a spreadsheet that will highlight cells
different colours based on criteria. I've been doing this with VBA...well,
trying :)...
|
|
3 |
159 |
|
|
|
|
6 |
149 |
|
|
|
March 12th, 2010 05:22 PM
by msnyc07
|
3 |
136 |
|
|
|
March 12th, 2010 04:11 PM
by UKMAN
|
4 |
176 |
|
|
SUMPRODUCT ISSUES by
Rbirdie
I am trying to get SUMPRODUCT to work and it is not.
Here is my data
A L M
1 C 354.54 Notes about account
2 W 16.54 ...
|
|
2 |
149 |
|
|
Parsing Information from a Cell by
Ken
I have a long list of supplies in Column A. In Column B it shows the range of
their cost ... for example, "79.99 - 89.99". I would like Column C to only...
|
|
3 |
134 |
|
|
|
|
2 |
138 |
|
|
Using Iserror with If statement and Vlookup by
juliejg1
I have the following formula in a cell:
=IF($K2="STEEL",VLOOKUP($B2,'Macos 12 Mo. Data'!$A$4:$AU$326,40,FALSE),0)
Problem is that the results of this are used...
|
|
3 |
139 |
|
|
Help with SUMIF & AND function by
mirko
Hi, how do I create a formula to sumarize value by group and subgroup? My
formula by group works but unfortunately the 2nd one doesn't work.
What I need is :...
|
|
2 |
116 |
|
|
Report one value out of a range by
jollyr
Hello everyone. I have the following scenerio that I sure could use some help
on:
A B C D E
1 Mike tools Sam tools
2 ...
|
March 12th, 2010 01:54 PM
by jollyr
|
2 |
166 |
|
|
Formula calculating to the 3rd decimal by
Shayla2008
I am using simple addition & multiplication formulas and the sum appears to
be calculating to the 3rd decimal which is making my totals unacceptable. My...
|
|
9 |
219 |
|
|
Count by
Louja
Hi,
On my file I get a list of accounts. I have a look up which lets me
know which account belongs to which individual.
I need to know how many different...
|
March 12th, 2010 10:56 AM
by Louja
|
7 |
185 |
|
|
Formula problem with Excel 2010 by
mns
Hi there,
I am trying to enter this formula in conditional formatting window
but my Excel 2010 wont accept it. I get the error "the formula you
entered...
( 1 2)
|
|
13 |
259 |