|
|
conditional formatting by
reno
on a amotization sheet that may run to 240 payments, payments may start in any month and the first payment would be in about row 40 or so. want to highlight...
|
June 13th, 2004 11:49 PM
by Domenic
|
1 |
312 |
|
|
VB to filter a list by
CrankyLemming
Hi
I have a worksheet containing a list of businesses, their addresses,
phone numbers, and so on, and also a column which specifies the type
of organisation:...
|
|
4 |
381 |
|
|
merge and wrap by
David Fore
I'm formatting an excel spreadsheet.
I'm using merge horizontally to get comments spread across multiple
cells.
I.E.
name ______ comapny _______ date...
|
June 13th, 2004 10:22 PM
by Ragdyer
|
3 |
361 |
|
|
MATCH within INDEX question by
Ron H
Hello,
In a previous thread I got a nice solution to a lookup problem I had
with the INDEX/MATCH functions.
I would like to learn exactly what the formula...
|
|
9 |
593 |
|
|
Bold deletion by
Yarroll
Hi,
I run a macro which checks if specific cells' font is bold. If it isn't,
then the whole row gets deleted. The lines in question read:
For k = howm To 2...
|
June 13th, 2004 05:10 PM
by Yarroll
|
3 |
460 |
|
|
spliting words up by
Continental Translations
In cells A1:A502, I have a few words in each cell. These words are split up
by a colon. So, for example, in cell A1, it says "Today : yesterday", cell
A2,...
|
June 13th, 2004 05:06 PM
by Ragdyer
|
3 |
630 |
|
|
deleting spaces by
Continental Translations
In a column of cells, tha majority of cells have spaces before the text. As
there are over 500 cells, is there any easy way to delete these spaces? As
there...
|
June 13th, 2004 04:54 PM
by Ragdyer
|
2 |
506 |
|
|
summing based on auto filter by
Art
I have a spreadsheet with several hundred rows and many
columns.
The formula in column "C" sums values for all columns
from "D" through the last column for...
|
|
2 |
1,118 |
|
|
Lists obtaining additional information by
engmgriff
Hi
I have created a dynamic list. From this list I would like (depending
on what the user has chosen) another list which represents the list
they have chosen...
|
|
1 |
468 |
|
|
Conditional Formatting by
Art
In Excel 97, is it possible to have more than 4
conditional formats? Maybe up to 6 or 7.
I am looking at changing the color of a row (say columns
A through H)...
|
|
4 |
652 |
|
|
Worksheets - Visibility by
Doria/Warris
Hi,
My Excel workbook has got many worksheets and in addition they have quite
long names.
As you can imagine, I have to scroll the horizontal bar continuosly...
|
|
2 |
474 |
|
|
How do I run multiple instances of Excel? by
Scott
In Word, each file opens in a separate instance of Word,
with its own Taskbar entry, etc. But with Excel, if I
click on a second .XLS file, it opens in the...
|
|
2 |
651 |
|
|
logic doubts by
nowfal
I am using a work sheet for billing purpose, for that i need some
security options for certain cells where i put currency rates,
the format is as follows:
A ...
|
|
3 |
370 |
|
|
VLOOKUP several conditions by
Ron H
I have two worksheets, one with customer data and financial data, and a
second with salesperson information. I need to "import" the
salesperson from the...
|
|
6 |
569 |
|
|
On Open by
Ian
Can anyone help me out with this?
I want a worksheet to preform these actions each time it
opens:
Automatically unhide any hidded rows (especially...
|
|
1 |
397 |
|
|
Moving programs by
greg
Can anyone advise how to remove a program from Excel to
another program such as MSWord. I have a file that is
incompatible with Excel.
|
|
2 |
357 |
|
|
Autofilter - are number of rows limited? by
NickMinUK
I have a spreadsheet some 20 columns wide by 6000 rows. Autofilter has
been applied to all columns on the header row and has been working
without any problem....
|
|
4 |
761 |
|
|
Automatic chart generator by
Jon Peltier
Michal -
I have some suggestions on this web page that would make it easier to
select which data to...
|
|
0 |
618 |
|
|
WRAP TEXT by
LYNN
I HAVE TRIED TO DO FORMAT, CELLS, ALIGNMENT & WRAP
TEXT...IT DOES NOT WORK. I'M TRYING TO DO THIS IN A CELL
THAT HAS BEEN MERGED WITH THREE OTHER CELLS TO THE...
|
|
2 |
534 |
|
|
Tab Fonts by
Does anyone know how I can change the font color on the
worksheet tabs? Thanks in advance.
Mike in Chicago
|
|
2 |
350 |