Hi there,
目前分類:title (5957)
- Apr 21 Sat 2007 20:37
Difference between two months
- Apr 21 Sat 2007 20:37
Excel hyperlinks to other cells in workbook must be relative
I've created an Excel spreadsheet with a few hundred hyperlinks to other
cells, spending hours fixing references because they're all !absolute. Now I
- Apr 21 Sat 2007 20:37
mulitple worksheets vlookup
- Apr 21 Sat 2007 20:37
Minimum cell height while using AUTOFIT?
Is it possible to set a Minimum cell height while using AUTOFIT?
--
- Apr 21 Sat 2007 20:37
HOW DO I SETUP A BANK DEPOSIT SLIP
- Apr 21 Sat 2007 20:37
cannot open this file
I save a file in excel or any Office program and when I try to open it I get
a message cannot open this file antiviru program thing something is wrong
- Apr 21 Sat 2007 20:37
Worksheet Formatting
I want to get a cell to lock automatically when I enter data into another
cell on the same line....Example: I want the cell in row one, column B to
- Apr 21 Sat 2007 20:37
Extract numbers with units. Eg. 1.6mm², 20.23mm²
I need 1.6 from 1.6mm² and 20.23 from 20.23mm²
- Apr 21 Sat 2007 20:37
Calculating a cell reference
Hi, it is possible to get excel to recognise a cell reference based on a
calculation?
- Apr 21 Sat 2007 20:37
Returning next value from a list
I have a spreadsheet where I use ISBLANK to populate a cell when a value is
entered in the cell next to it. I pull the values to populate with from a
- Apr 21 Sat 2007 20:37
Trend Line Equation Coefficients
Is there a way to link to the coefficients of a trend line? I have some data
plotted with a exponential trend line fitted to it and the equation of the
- Apr 21 Sat 2007 20:37
using the equation of a polynomial
I input my data in column A = inches and B = tons. I then graphed it with an
X-Y graph and added a 2nd order Polynomial to it. The equation that is
- Apr 21 Sat 2007 20:37
using queries in templates
I would like to use a query in an Excel template. I want it to run every time
I use the template to create a new workbook. I also need it to prompt the
- Apr 21 Sat 2007 20:37
Summed Cell won't update as I add data into the cell range...
I have a simple sum function at the bottom of a column:
=SUM(D468)
- Apr 21 Sat 2007 20:37
Numbers SHOULD BE text
Have data that is a mix of number and text.
Ex: the field if PN
- Apr 21 Sat 2007 20:37
Excel Query .QEF
Hi,
- Apr 21 Sat 2007 20:37
How Do I Eliminate the Serial Number for time from Date?
I have a long spread sheet that has two columns of dates (Received and
Finished)
- Apr 21 Sat 2007 20:37
how do I find names in a workbook full of names
I have a workbook with several worksheeets, I need to know how to find a name
on any worksheet without having to scroll through the list.
- Apr 21 Sat 2007 20:37
editing a cell that has a formula in it
I have a form that draws most of it's data from a sharable access database.
Unfortunately some of the fields aren't completely updated. Therefore I am
- Apr 21 Sat 2007 20:37
consolidate totals
I have multiple workbooks with multiple worksheets. I am trying to get a
running total to continue from sheet to sheet and book to book. How can I do