|
|
Excel Toolbars in Word by
ianripping
I have created my own customised toolbar for word. I want to get rid of
the menu which has: File, View, Tools, etc. I know this can be done in
excel but can it...
|
|
1 |
356 |
|
|
Disappearing formulae by
Schol-R-LEA
I recently was asked to help someone with a problem in
which, on certain sheets of a large Excel 2000
spreadsheet, every formulas had been inexplicably...
|
|
1 |
363 |
|
|
Portion of sheet with different column widths by
Laurence Lombard
I have a sheet containing two tables of data, but they require different
column spacing.
I could use a formula similar to the one below (assuming the data is...
|
|
2 |
462 |
|
|
Problem with Linked Cells by
Dave Peterson
Use a few helper cells in the original workbook and split the text up there.
Then retrieve the values from those helper cells and concatenate them in...
|
|
1 |
491 |
|
|
|
|
1 |
533 |
|
|
E-mailing spreadsheet by
Art
Is there a way to e-mail a spreadsheet to a specific list
of people, lets say every Tuesday at 1:00 pm? My company
is using Groupwise.
|
|
2 |
342 |
|
|
Copying Data between Workbooks by
Steve
As new versions of a spreadsheet system are released, I
would like to add a button that will allow a user to
select the previous version ( file locations and...
|
|
1 |
549 |
|
|
Data Validation Ammendment by
Continental Translations
I have set up two drop down menus which use data validation. The results of
the second drop down menu depend on what was selected in the first drop...
|
|
3 |
357 |
|
|
simple formula by
Ash T.
Cell A4 = A1 + B3
Cell B4 = D1 + E3
C4 = G1 + H3
And so on. How can I write the formulat in A4 so that I
can just drag that cell to cells B4, C4, D4 etc. so...
|
June 12th, 2004 03:52 PM
by Ash T.
|
8 |
562 |
|
|
|
|
2 |
572 |
|
|
need help (graph) by
K1s0s
my i got an X,Y graph
my X is months but i instand of the name of the month i see is number
(may -5 ) plz help
---
Message posted from...
|
|
1 |
348 |
|
|
need an answer quick about charts by
K1s0s
hello im new here but i need the answer quickly plzz
i have a graph. my X is month but instad of the names of the months is
show the number of the mounth...
|
June 12th, 2004 04:15 PM
by JulieD
|
1 |
436 |
|
|
Combining two macros by
ADE2
Hi
I have two macros that i would like to combine by adding Sub Every5()
to the start of Sub AUTOINTRADAY()so that it runs every five minutes
based on the...
|
|
1 |
347 |
|
|
|
June 12th, 2004 04:58 PM
by hglamy
|
2 |
333 |
|
|
Pivot table by
JIM.H.
This is my table
name price1 price2
d 11 5
d 11 5
e 13 4
This is Pivot Table I get
name Data Total
d Sum of price1 22
Sum of price2 10
|
|
1 |
315 |
|
|
Conditional Format by
Continental Translations
This question has probably been asked a thousand times but just scrolled
through and couldn't find it.
I want to conditional format my sheet, so if there is...
|
|
2 |
594 |
|
|
|
|
6 |
439 |
|
|
Calculaion based on Previous Sheet by
kishan
hi, i need some help with a particular function i need.
basically i need a function that adds 1 to the number on
the previous sheet in the cell B1. For example...
|
|
6 |
364 |
|
|
#VALUE! by
Rock
Hi All,
I copied a spreadsheet from a website into excel. I wanted
to used the numbers in the spreadsheet to create my own
formulas. When I created the...
|
|
2 |
334 |
|
|
Splitting Cell Data? by
Dax Arroway
OK here's a great one. Check this out. I have a simple one page spreadsheet of addresses. My client wants me to sort/filter the data so that it is sorted by...
|
June 12th, 2004 08:59 PM
by Ragdyer
|
2 |
374 |