I want to share an excel workbook for all on the network. However I do not
want one worksheet only to be accessed.

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

I am working with an accounting worksheet and using the following formula:
=If(D12-D13 = 0, quot;Balancedquot;, D12-D13)

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


Hey,

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

I need to use the Autofilter on the first column of data. However, each cell
in the first column is actually two cells (two rows merged), and it is not

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

how do i get data that is being imported in 5 second intervals to enter into
the next cell? The data enters A1, then 5 seconds later another number comes

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

i want to use pivot table for my cycle time calculation. the cycle time is
the difference between the maximum of one column and the minimum of another

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

At work we use Excel all the time, and many of our spreadsheets use
INDEX-MATCH formulas to pull in stock quotes from other workbooks saved

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

I have to check each row for the maximum value in that row. But instead of
writing the maximum value of that row, I have to write the column number of

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

How can I create a keyboard shortcut (preferably a left-handed one) that will
perform the same function as the quot;merge cellsquot; button on my Excel toolbar.

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

Hi,Someone has given me a whole text document written in Excel 2002 and I wish to
use it in Word as a doc file.

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