Hi, using Excel 2002 here.
目前分類:title (3013)
- Oct 22 Sun 2006 20:09
Calculating time
- Oct 22 Sun 2006 20:09
Subtract times and let result go negative
Total hours available less hours worked each day, allow results to go
negative. Excel displays negative times as #.
- Oct 22 Sun 2006 20:09
Updating Functions (Vlookup)
I have a worksheet that looksup other worksheets we continually update.
However, when we enter information day to day, we want the information to
- Oct 22 Sun 2006 20:09
lookup values
hi,
- Oct 22 Sun 2006 20:09
restrict a user from opening a dbf file from excel?
how can i restrict a user from opening a dbf file from excel? and how can i
restrict him from saving an excel file as DBF? thanks
- Oct 22 Sun 2006 20:09
leading zero truncate
When importing a .csv file where the data is encapulated (each item of data
is enclosed in double quotes) excel strips off the leading zeros.
- Oct 22 Sun 2006 20:09
Referring to a column
- Oct 22 Sun 2006 20:09
Excel need help
- Oct 22 Sun 2006 20:09
Text amp; Date same cell
- Oct 22 Sun 2006 20:09
Pivot tables and drop-down lists
- Oct 22 Sun 2006 20:09
How to count unique values?
Thank you very much for all of your suggestions. I ended up using the
subtotal function and that worked fine. Thank you again for your quick
- Oct 22 Sun 2006 20:09
hilighting entire row
- Oct 22 Sun 2006 20:09
Keyboard shortcut to go to first worksheet in workbook?
Is there a keyboard shortcut that will go to the first worksheet in a
workbook? I can use the mouse to click on the double arrow left, but
- Oct 22 Sun 2006 20:09
VLOOKUP Returns Erroneous Value When Control Data is Variable
I have a workbook that uses VLOOKUP on the Summary sheet to find values
associated with a Name and Week #. The worksheet I'm trying to capture the
- Oct 22 Sun 2006 20:09
Importing External Data function
Dear all,
- Oct 22 Sun 2006 20:09
Exporting Data
- Oct 22 Sun 2006 20:09
Yet another Look up thread...
- Oct 22 Sun 2006 20:09
Timestamp Macro
I am trying to simplify a timetable to mimic several functions of a
stopwatch. Currently I have the macro below:
- Oct 22 Sun 2006 20:09
curing the blocking of cells.
after the name cell is used the cells following do not permit entry.