|
|
|
|
3 |
162 |
|
|
|
|
4 |
128 |
|
|
Row Height Adjustments by
Janet Lyn[_2_]
I have a "timecard" sheet set up with a column of numbers that when a number
is typed in, it does a Lookup and fills in a wide column with a name. Then a...
|
|
3 |
98 |
|
|
Drag down the color fill box by
inthestands
I am using excel 2007. In previous versions you could drag the fill and font
color boxes onto the page so that you could easily change from one color to...
|
|
1 |
104 |
|
|
prevent blank cells in excel by
jojik
Hai all, i have an excel sheet with different empty cells. i don't want the
user to save the file (or to go to another cell) without filling those
particular...
|
March 25th, 2009 01:54 PM
by jojik
|
5 |
128 |
|
|
Delete content but not formulas by
Jake F[_2_]
I was asked if there is a way to remove the content of spreadsheets but to
keep the formulas. I'm not sure why the person wants to do this, but want to
give...
|
|
2 |
146 |
|
|
formula auditing problem by
marnie
Sometimes when I use the trace precendents (or dependents) the blue dots
don't appear in the cells that are applicable and sometimes they do. I can do
this...
|
March 25th, 2009 01:22 PM
by marnie
|
0 |
96 |
|
|
ROUNDING UP TO NEAREST 9 by
JUDY
I would like to multiply a number by 3.5 and then have it rounded up to the
nearest 9. example a product cost 32.45 to get the comparitive price 32.45...
|
|
5 |
91 |
|
|
Calculate message by
Mark
I am running an Excel 2003 spreadsheet with 20 tabs, many calculations and
Links to external Query Tables resulting in a file that is 33Mb in size.
Initially...
|
March 25th, 2009 12:27 PM
by Mark
|
1 |
101 |
|
|
Formula to display just number and not text by
edeaston1983
Hi,
I have looked through other peoples questions and so far I havent been able
to find an answer that works for me.
I have cells which contain both numbers...
|
|
3 |
99 |
|
|
no worksheets in a workbook - Excel 2003 by
Jarek Kujawa[_2_]
Hi,
I have a workbook with several worksheets (10) and 7 VBAProject
modules (with numerous procedures). The workbook is used to perform
calculations on a...
|
|
1 |
96 |
|
|
|
|
1 |
77 |
|
|
|
|
1 |
91 |
|
|
pivot table by
User
is there any option which helps the format of the pivot table report not to
change whenever we refresh or add the data fields
|
|
3 |
93 |
|
|
Reference Numbers by
DaveKid[_2_]
Hi.
I would like to know if there is a way of creating reference numbers in excel?
Thanks
|
March 25th, 2009 09:55 AM
by Dave
|
7 |
79 |
|
|
|
March 25th, 2009 09:39 AM
by l0l
|
0 |
94 |
|
|
.CSV file by
pankaj
Hello,
I have a standard database in .CSV created with german settings, and now I
would like to use the same database files in english version. Do need to do...
|
|
1 |
115 |
|
|
Headers by
Chad Williams[_2_]
How do I add a header in excel?
|
March 25th, 2009 06:07 AM
by Dave
|
5 |
134 |
|
|
IF value is in range by
Kirsty
I am trying to write a formula or macro that returns a result if a value is
in a range.
I can write the lookup fine, but i am getting data errors if there is...
|
|
2 |
97 |
|
|
Adding by
DTP
I am making a price list based on supplied figures. I would like to add a
markup on every number in every field. To do this successfully I would need
to...
|
|
1 |
113 |