|
|
filtering simply by
merlin
I have a sheet which looks like this (in reality there are 84 names by
around 30 skills):
person skill 1 skill 2 skill 3
tom yes
barbara ...
|
July 8th, 2009 08:05 PM
by merlin
|
2 |
109 |
|
|
search a folder? by
JCW
I'm a total noob to excel (sorry)
I have a folder FULL of music that i want excel to search and update as i
add more music, is this possible? As in for excel...
|
|
2 |
178 |
|
|
Circular Reference Warning by
NeiLi
When I open my exel file .. this pop-up open ..
circular reference warning
one or more formulas contain a circular reference and may not calculate
correctly....
|
July 8th, 2009 09:23 AM
by Kassie
|
3 |
150 |
|
|
Tiny font at print time by
Laurel
I have a spread sheet that looks fine when I'm working on it, but in
print/preview, or when actually printing, the font is so tiny I can't even
read it. ...
|
|
1 |
136 |
|
|
|
|
1 |
122 |
|
|
Circular Reference Warning by
NeiLi
When I open my exel file .. this pop-up open ..
circular reference warning
one or more formulas contain a circular reference and may not calculate
correctly....
|
July 7th, 2009 09:23 PM
by NeiLi
|
0 |
89 |
|
|
cross reference by
damegood
is this the program that i use to create a cross reference for names,
addresses and telephone numbers? i want to be able to pull up either of
them and get...
|
|
1 |
126 |
|
|
Printing Forms/Reports Containing Hyperlinks by
chrisexcel060409
I have a form I created that contains hyperlinks to a dashboard. When I print
the form/report, it also prints the "Back to Dashboard" hyperlink. How do I...
|
|
1 |
129 |
|
|
AUTOMATIC FILE SAVING by
pravin
Subject: AUTOMATIC FILE SAVING 7/6/2009 11:18 PM PST
By: pravin In: microsoft.public.excel.newusers
1.Thanks for the prompt reply and...
|
July 7th, 2009 07:33 AM
by pravin
|
0 |
125 |
|
|
AUTOMATIC FILE SAVING in a folder by
pravin
I generate quiotations from a template and create a code name for each
quotation in cells B7 to F7 as follows.
TEMPLATE CODE XXX
QUOTATION ...
|
|
1 |
149 |
|
|
Creating a pass of fail condition by
jhumphreys
Hi there
I need to use a sum function that only happens if a certain condition
exist, this condition being that every number in a column has to be over
a...
|
|
6 |
142 |
|
|
Show zero in a cell by
Clare
Hi
I have the undernoted formula, however, when cell H3 has no date in it the
cell with the formula shows 5714 can anyone tell me how to make the cell show...
( 1 2)
|
|
10 |
305 |
|
|
|
|
2 |
163 |
|
|
|
|
3 |
365 |
|
|
Locking everything except cells B4:B8 by
H
Hi, can someone help me lock this sheet except for these cells - I've tried
doing the Protect Sheet but everything seems to get locked?
Thanks
|
|
2 |
106 |
|
|
Comma Style Question by
Steveal
When I format a cell using the "Comma Style" toolbar button, I get 2
decimal places shown along with the comma separated thousands.
Is it possible to change...
|
|
3 |
211 |
|
|
Hyperlink, Cell and a menu by
Lee
I create and use several workbooks during a year and then forget what I did
or where I stored them. So, I am trying a crude menu system using Hyperlink
in a...
|
|
1 |
160 |
|
|
Conditional formatting by
Clare
Hi
I've got the undernoted formula on my spreadsheet:-
=IF(T3=R3,"No","Yes")
Could someone tell me how to make the yes turn red in the cell
Thanks
|
July 5th, 2009 08:59 PM
by Clare
|
5 |
131 |
|
|
Attaining Form for Excel by
Griff
We are having some difficulty in attaining 'Forms' on Excel 2007. We have
been directed to 'Down loads' and then attempt to down load 'Exel 2002 Add-...
|
|
2 |
179 |
|
|
|
|
1 |
99 |