目前分類:title (3013)

瀏覽方式: 標題列表 簡短摘要

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

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()

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?

software 發表在 痞客邦 留言(0) 人氣()

I'm sure this is a very easy one but I'm not too well versed on Macros /
VBA.

software 發表在 痞客邦 留言(0) 人氣()


Hello! I'm very new to using Excel, and having problems creating a

software 發表在 痞客邦 留言(0) 人氣()

I'm stuck. Using Excel 2002, Win XP Pro

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()

Is it possible to have a background image (like watermark) behind the
worksheet? Many thanks.

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()


I have a worksheet showing a column of file names e.g.

software 發表在 痞客邦 留言(0) 人氣()

how can i delete tempfile in excel(or don't creat tempfile)

software 發表在 痞客邦 留言(0) 人氣()

I have a spreadsheet with the following:

software 發表在 痞客邦 留言(0) 人氣()

how do i use the countif function
when i want the criteria to be a cell

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()

Hi Pam:

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()

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,

software 發表在 痞客邦 留言(0) 人氣()