|
|
|
June 30th, 2004 11:00 AM
by ANZAC
|
4 |
114 |
|
|
|
|
1 |
273 |
|
|
2 decimals by
Elsa
Are you sure that you need all those decimals in the
original worksheet/workbook?
If you don't, you can round them (or truncate them) to the
proper 2 decimals...
|
|
1 |
121 |
|
|
Logical pivot table by
dk
Is there anyway to create a logical field and a pivot table for ex: colmun d is going to be a logical T. F. column E is going to be figures which is going to...
|
|
1 |
104 |
|
|
adding worksheets by
craig
I am trying to add a worksheet to an existing excel workbook, but under the insert tab "worksheet" is greyed out. What is the deal?
|
June 30th, 2004 10:07 PM
by Paul B
|
1 |
95 |
|
|
Condition by
lolita
i have 2 problems :
1) i need a formula that will put me 20 if the day is 18th of each month of the year 2004
2) i need a formula that will put me 205 every...
|
July 1st, 2004 12:21 AM
by CLR
|
1 |
113 |
|
|
Blank rows between data by
sdrendon
I have a spreadsheet with blank rows between each row of data. First of
all, how can I set it up to skip the row automatically when entering
and second, when...
|
|
1 |
133 |
|
|
Match one column to another? by
bobfronk
Ok, I am not an Excel person, but as the IT manager I have been asked to
help someone with a spreadsheet.
A SQL database is queried. It returns information. ...
|
July 1st, 2004 12:30 PM
by JulieD
|
1 |
115 |
|
|
make command button invisible by
Excel-VBA Dummy
Could someone please tell me the syntax to make a command
button visible or invisible?
I was hoping it would be something easy like:
commandbutton.visible =...
|
July 1st, 2004 01:42 PM
by
|
5 |
145 |
|
|
Applying a Header to Workbook by
Kerri
How do I apply a header to an entire workbook? What I
really want is for the header to print on every page. I
would also like the page numbers to appear as...
|
|
3 |
160 |
|
|
Fonts unavailable for symbols by
Dianah
I'm trying to insert a symbol from a font, however, when I go through the
steps , ... I click on the font field pulldown menu and the
fonts only go to what...
|
|
2 |
222 |
|
|
Comment box by
tghcogo
When I insert a comment, already inserted is "User:", is there a way to
get rid of this so that the box is completely empty?
---
Message posted from...
|
|
3 |
160 |
|
|
|
July 1st, 2004 10:36 PM
by CLR
|
2 |
112 |
|
|
Inserting EXCEL into WORDS by
Lee
Hello! Friends:
I try to insert an EXCEL worksheet into WORDS by using (in
WORDS)INSERT/OBJECT/CREATE FROM FILE/(XL filename).
The inserted XL worksheet...
|
July 2nd, 2004 01:07 AM
by CLR
|
9 |
160 |
|
|
Subtotal by
George Gee
Hi all.
I have formula in A2 =SUBTOTAL(3,A4:A2963)
this counts the number of visible records, (after using Autofilter),
that contain text (ignores blank...
|
|
6 |
126 |
|
|
|
July 2nd, 2004 02:52 AM
by Max
|
2 |
171 |
|
|
Refreshing pivot table when cut/paste data by
Martha
I think this is supposed to be easy, but I'm having
trouble. I have a pivot table that is run off data called
Source. I need to replace the Source data on...
|
|
1 |
528 |
|
|
|
July 2nd, 2004 08:02 AM
by lumi
|
7 |
156 |
|
|
address book by
redman
Is there a macro or other way (short of cutting & pasting) of putting address book entries into a row format. For example:
John Smith
123 Main...
|
|
3 |
130 |
|
|
|
|
1 |
154 |