|
|
|
|
1 |
499 |
|
|
Underline Accounting by
Bruinlax
How is a good way to make the underline accounting underline the WHOLE
cell? for instance -
i want 4.0% to be
______4.0%_
not _4.0%_
i've tried
_(* 0.0%_)
|
June 13th, 2004 12:44 AM
by AlfD
|
4 |
511 |
|
|
Links tutorials - resources by
David McRitchie
Hi Mustafa,
You have additional answers in excel.links
You have asked the same question several times in the Excel
newsgroups. Basically you are not...
|
|
1 |
441 |
|
|
Timesheet Formula Problem by
Bridie
I am trying to set up a timesheet to cover staff working 24 hrs. Day and
night hours are paid at a different rate (and staff members all have
different rate of...
|
|
3 |
427 |
|
|
Tab Fonts by
Does anyone know how I can change the font color on the
worksheet tabs? Thanks in advance.
Mike in Chicago
|
|
2 |
354 |
|
|
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 |
537 |
|
|
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 |
620 |
|
|
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 |
769 |
|
|
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 |
362 |
|
|
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 |
400 |
|
|
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 |
571 |
|
|
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 |
372 |
|
|
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 |
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 |
476 |
|
|
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 |
656 |
|
|
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 |
472 |
|
|
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,131 |
|
|
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 |
512 |
|
|
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 |
633 |
|
|
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 |
479 |