I have a simple equation like =SUM(F1:F28) but how can I prevent hidden

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

Is there a way to lip a name around in a single cell? For example Smith,
John to John Smith.

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


I have to keep a fairly basic database of accounts receivable invoices.

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

looking for a way to query an array 3 cells by 3 cells (they have numeric
data only) and return a value in a seperate cell that has all the numbers in

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

Excel chart trendlines/regressions, equations and r-squared values should
default to the same color as the plotted points (especially useful when

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

I have seven columns B thru H (representing the different weights of 7
individuals). The three rows under these seven columns represent Driver 1,

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

I have a column which has a variable number of comma delimited values in the
range of 11 to 56 in each cell. Is there a method or macro to count the

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

My worksheet is protected but in the cells that a user can enter data I would
like to have the spell checking available but the button is grayed out unless

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

hod do I undo a spil screen - excel file

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


Hi Everybody

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