目前分類:title (3013)

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

For some reason in parts of my spreadsheet when I type a formula in a cell
and save it, the formula text will save and show in the cell, but the actual

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

Is there a formula to round numbers to the nearest quarter?

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

I am trying to find a formula to enter all data daily into column A and have it placed into specific locations I am working on a large sheet and trying to save time. Is there a function to do this?

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

Can I use an IF statement (or anything else) so that the answer to a question
in one cell dtermines the colout of ANOTHER cell?

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

When I call the function Dir(quot;Q:\quot;) and Q:\ is a network mapped drive does
it fail (return quot;quot;) if it does not receive a reply within a certain

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

MS Excel 2003 SP2

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


Hi all,

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


I have several seperate excel files where people enter a specific date

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

I want to disable refresh options while working in PIVOt table since it is
disturing my own format while refreshing or adding my data... pl. advise...

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


Hi !

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

I have a spreadsheet where each row contains data for an employee. I want to
be able to create one page forms for each employee without having to show the

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

Is it possible to hide just one of the subtotals in a pivot table? I want to
see the subtotals for my Number of customers, Quantity, and Amount. But I do

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


hi

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

when i go to quot;save asquot; it just shows an hour glass and freezes
does any one know whats wrong???i can not do any work because i need to save

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

Hi there
I have done the following to create a generic payroll system for our other

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


If I want to apply a macro to all sheets except for a certain sheet, say

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

To all those VBA experts out there, I've written a simple macro in
VBA. The purpose is to alert the user if they encounter a value that

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


I am stuck. I am trying to use the quot;SUMIFquot; function in conjunjunction

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

I want to play background music by using a macro in which also other commands
(next steps) are included. However the next step of the macro only starts

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

Hi:

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