|
|
auto filling columns from rows by
Ken
Hi there
How can I auto fill a series of values that equals a series of cells from
another sheet?
The cells I want the information to come from a row in...
|
February 23rd, 2005 10:49 AM
by Max
|
2 |
124 |
|
|
|
February 23rd, 2005 12:19 PM
by Max
|
2 |
75 |
|
|
|
|
2 |
140 |
|
|
Reference by
Incognito
I would like to make reference to a cell in a worksheet in a second excel
file. However, I would like the worksheet to be variable.
Normally you use the...
|
|
2 |
140 |
|
|
Strange color issue by
Julie
Not sure how I did this but when I click on a cell the row/column headers
turn orange. Even the drop down menu highlights in orange as I am going thru
the...
|
|
4 |
103 |
|
|
|
February 23rd, 2005 03:52 PM
by JulieD
|
2 |
220 |
|
|
Pivot Table ?? by
Kirk P.
I've got a pivot table, one on each sheet. Both pivot tables display similar
information, but in slightly different ways. Question is, can I set it up...
|
February 23rd, 2005 04:55 PM
by Kirk P.
|
3 |
76 |
|
|
Extracting the number from a text by
Venkatesh V
Hi,
In a cell say C3, the value is such as S9(09)V(05).
the value of that cell might be in one of the following format:
(1) S(9)V(5)
(2) S9(09)V(05)
(3)...
|
|
1 |
80 |
|
|
involuntary format changes by
dave glynn
I have prepared a file of bank payments for electronic payments. The fields
(column heads) are
sort code account name account number ...
|
|
2 |
166 |
|
|
|
|
5 |
165 |
|
|
|
February 23rd, 2005 06:37 PM
by melzki
|
2 |
153 |
|
|
Conditional Formatting by
Michael
I would like to use conditional formatting in a number of
cells. The condition I would like to highlight would be
if the cell contained text. ie. 1Y
Can...
|
|
1 |
71 |
|
|
Publishing to a webpage by
Bowtye
I have published an excel file as a webpage and would like to add more
interactivity to it. The basic interactivity is there but there is no
printing...
|
February 23rd, 2005 07:25 PM
by Bowtye
|
0 |
86 |
|
|
Excel Text import wizard by
Kate
Hello,
When you open up a .txt file in Excel, this starts up the Text import
wizard. On the second screen of the wizard, you get a set of delimiters...
|
|
1 |
161 |
|
|
Moving dates between worksheets by
SuperDad
I track my bank balance on two worksheets. The first is a date/debit/credit
to track the balance. The second worksheet lists my monthly Standing Orders.
At...
|
February 23rd, 2005 08:35 PM
by SuperDad
|
3 |
148 |
|
|
Paste Special, Metafile by
JB in Kansas
When I copy an Excell spreadsheet and paste it into a Word documet as a
Metafile, I loose the font color. The logos and filled cells paste in color
only the...
|
February 23rd, 2005 09:01 PM
by Michael
|
1 |
103 |
|
|
Balance sheet Formula by
TC
Hello everyone.
I got the template from MS for the blance sheet but I ran
out of space on the template. Does anyone know what the
formula would be in Excel...
|
February 23rd, 2005 09:13 PM
by TC
|
0 |
242 |
|
|
|
|
3 |
362 |
|
|
|
February 23rd, 2005 10:27 PM
by Pierre
|
2 |
284 |
|
|
Conditional Format? by
Ken
Excel 2000 ... I know this is basic ... However, I always
have a "brain cramp" when dealing with ... "Empty Cells
&/or Blank Cells"
I want to set Conditional...
|
|
3 |
94 |