Hi all,
Have search the groups but didn't find an answer to my problem,
therefore here my question.
software 發表在 痞客邦 留言(0) 人氣(2)
I am currently working on a detailed inventory, but also want to make a
hard-copy version from the list in excel in the form of individual note cards
for each entry? Are there any shortcuts I could take through excel or any
other Office programs so that I could just click and print rather than do
everything manually?
software 發表在 痞客邦 留言(0) 人氣(0)
I received an email with an attachment that is a spread sheet. My computer
will not open it and directs me to go on line to get excel help. I'm at a
loss. Please advise some one new to this on how to do it. Thank you.
You can't just download Excel but you can download a free Excel Viewer
software 發表在 痞客邦 留言(0) 人氣(0)
Using Excel 2003 I want to make a button control visible/invisible according
to the value in a cell which contains the formula counta(a1:a10). How can I
do this?
I've worked it out now. I used the worksheet recalculate event to trigger a
software 發表在 痞客邦 留言(0) 人氣(0)
Hi there,
I have a need to enter a formula to limit the size of a number displayed in
a cell.
software 發表在 痞客邦 留言(0) 人氣(0)
I have two columns each with numbers in them.
*Column A* has a current event score in it for an event.
*Column B* has the alltime record in it.
I want *Column B* to update with a new record anytime a *Column A* cell
exceeds the value in *Column B*. If this were the case, the cell in
software 發表在 痞客邦 留言(0) 人氣(0)
In a form, I have a Years of service note. It works as it should except for
the first year of work, which would really be quot;0quot; years for the first year.
gt;D48 gt; 02/06/06
gt;D48 is the Anniversary date MM/dd/yy
gt;H48 is the number of years of service
software 發表在 痞客邦 留言(0) 人氣(4)
Maybe a stupid question .. but what exactly is the difference in function?
VLOOKUP allows you to find an entry in a list and return a value that
is a given number of columns away from that entry. This can be a text
string or numeric value.
software 發表在 痞客邦 留言(0) 人氣(4)
Is there any way to adjust the vertical spacing between wrapped lines of text
within a cell?
Formatgt;Cellsgt;Alignmentgt;Text Alignmentgt;Verticalgt;Justify.
software 發表在 痞客邦 留言(0) 人氣(1)
I'm following the FAQ for taking a list of dates produced by my piviot table
and trying to group them by week. When I select the field name, right click
and select grouping, I get quot;cannot group by the selectionquot;. My data source
for this field in the table is all dates (other than the header).
--
software 發表在 痞客邦 留言(0) 人氣(3)