Hello,
目前分類:title (4957)
- Aug 07 Thu 2008 20:45
Formula Contains an invalid external reference to a worksheet
- Aug 07 Thu 2008 20:45
excel totaling wrong
I am adding the below numbers in Column B and the last number (20) show the
total I am getting???? I checked to see what cells were being added it shows
- Aug 07 Thu 2008 20:45
log any changes to spreadsheet to another sheet in excel
How can I log any changes to made to one spreadsheet to another sheet in excel?
I would like to keep a running log of any/all changes made.
- Aug 07 Thu 2008 20:45
How do I reference a Web Query on another sheet?
I am taking a Microsoft Office college course. I have a Web Query on
worksheet one and I reference it in worksheet two, but when I hit enter it
- Aug 07 Thu 2008 20:45
Protecting Worksheets
I have been trying to protect a worksheet to prevent it from being deleted.
I have tried the toolsgt;Protectiongt;Protect Workbooks. I have selected
- Aug 07 Thu 2008 20:45
How to Histogram w/o raw data but histogram Table on Excel
Hi
- Aug 07 Thu 2008 20:45
Excel formula to increment the month by 2?
Dear friends,
- Aug 07 Thu 2008 20:45
AutoComplete in EXCEL
Hi.
Sometimes, when i type text in a cell, , the AutoComplete feature not
- Aug 07 Thu 2008 20:45
Autofill with sheet number increasing
I am building a workbook that has a summary sheet and several worksheets. Is
there a way to drag and autofill so that the fomula will change the sheet
- Aug 07 Thu 2008 20:45
Converting to Decimal degree's
Here is a neat trick:
- Aug 07 Thu 2008 20:45
.xls files become scrap objects
This same question has been asked in the applications error forum
have gone back 2 months and all files in these folders are now scrap
- Aug 07 Thu 2008 20:45
How can I alter the rounding rules?
Is it possible to alter the rounding rules in Excel so that it rounds up when
the value is .5 or higher
- Aug 07 Thu 2008 20:45
Use criteria for values in range for small function
I have a range (a1:a5) with values such as:
- Aug 07 Thu 2008 20:45
copy worksheet to another workbook
I have a workbook with a worksheet that referances other worksheets within
the same workbook. When I copy this worksheet to another workbook, it still
- Aug 07 Thu 2008 20:45
Recording a high price on a worksheet
I need to know the highest price I have ever paid for a product. In my
inventory, I update prices monthly, changing the previously recorded price.
- Aug 07 Thu 2008 20:45
Grouping Data
- Aug 07 Thu 2008 20:45
How to make a daily calendar
I am trying to make a daily calendar either in Excel, Publisher or Word which
would show the hours.
- Aug 07 Thu 2008 20:45
How to sort in Excel with headers link to all body parts
I have a table that have subheaders and each subheader with rows of items
below them.
- Aug 07 Thu 2008 20:45
How to format a number cell to auto count 1 up on file open
I'm trying to format a number cell to auto count 1 up on file opening. Trying
to create custom invoices each having an unique number.
- Aug 07 Thu 2008 20:45
WHERE IS THE INTERPOLATION FUNCTION IN EXCEL 2003
I RECENTLY UPGRADED FROM EXCEL 2000 TO EXCEL 2003. IN EXCEL 2000, THERE WAS
AN ENGINEERING FUNCTION CATAGORY AND IN THIS CATAGORY THERE WAS AN