How do I setup format defaults. For example, if I always want currency to be
set up for $ instead of Lbs. when I click or the currency button. Or if I
目前分類:title (3013)
- Aug 14 Mon 2006 20:09
Setting default formatting
- Aug 14 Mon 2006 20:09
space delimited!!
could anybody tell me how to save the file in the formatt, .prn using the
file type, formated space delimited, (by using vba)?...i tried to use
- Aug 14 Mon 2006 20:09
Excel should let me change the menus contextuals
In some programs like Word, Access or PowerPoint I can change the menus
contextuals how I need them. Why not in Excel, where it might be very usefull?
- Aug 14 Mon 2006 20:09
Macro question
I'm sure this is a very easy one but I'm not too well versed on Macros /
VBA.
- Aug 14 Mon 2006 20:09
Excel Scatter Plot
- Aug 14 Mon 2006 20:09
Help with simple data table?
I'm stuck. Using Excel 2002, Win XP Pro
- Aug 14 Mon 2006 20:09
Wrap text problem in Excel 2003
I am having probems with wrap text. The last line, in a ten line entry,
won't wrap. Is there anything I can do about this as it is happening on at
- Aug 14 Mon 2006 20:09
Background on Worksheet
Is it possible to have a background image (like watermark) behind the
worksheet? Many thanks.
- Aug 14 Mon 2006 20:09
addition or substraction
I have a columns with thousand of entries (rows)some are receivables ( ) and
others payables (-), how can I do a formula to add only receivables or
- Aug 14 Mon 2006 20:09
Finding matching cell data
- Aug 14 Mon 2006 20:09
delete tempfile in excel
how can i delete tempfile in excel(or don't creat tempfile)
- Aug 14 Mon 2006 20:09
Help with Formula
I have a spreadsheet with the following:
- Aug 14 Mon 2006 20:09
countif
how do i use the countif function
when i want the criteria to be a cell
- Aug 14 Mon 2006 20:09
Filtering Data With Formula
In Column D I have about 100 Cells filled with numbers. Some are greater to
or equal to zero, some are less than zero. I'm wondering if there are
- Aug 14 Mon 2006 20:09
Auto Filter Subtotals
I have five columns of data. Columns 1 and 2 are populated with names,
columns 3 through 5 with numbers. I would like to automatically create
- Aug 14 Mon 2006 20:09
Advanced filter using dates
I have a column formatted as a date field and need to do advanced filtering
on it. For example, I want to filter out entries between two dates. When I
- Aug 14 Mon 2006 20:09
Total width of several columns.
Could you please advise if there is a quick way to total the width over
several columns of a worksheet. I need to do this so that I can make page
- Aug 14 Mon 2006 20:09
longevity dates
Hi Pam:
- Aug 14 Mon 2006 20:09
bar graphs
How do I create a bar graph where the y-axis have letter values instead of
numbers? I want the x-axis to show student names and the y axis to show
- Aug 14 Mon 2006 20:09
Change Formatting In 'Active' Cell
HiI want to apply some way of keeping the formatting of an established
spreadsheet the same but changing it in the 'Active' highlighted cell only,