| Thread | Last Post | Replies |
|
| increase data with cursor on cell bottom right corner | 21 May 2007 20:14 GMT | 2 |
I can't incremente cells data by setting the pointer on the bottom right corner of the selected cell. The pointer doesn't change to allow to perform such operation. Pls give a hand.
|
| Macro (or equivalent) to display certain pivot table data | 21 May 2007 19:40 GMT | 8 |
Here's the situation. It's hard to imagine without seeing the whole sheet, but here goes. Assume someone enters a product number (e.g., 1438) into cell A1. Let's say I have a pivot table about 30 rows down that lists all the sales data YTD
|
| Dynamic number formatting | 21 May 2007 19:27 GMT | 2 |
Costs in my sheet could be in a wide range of different currencies. The ideal visual outcome would be to associate the appropriate currency symbol to each cost number. The currency information is dynalically generate in a cell inside the working sheet. As an example, if Euro is ...
|
| The column name on Excel are numbers instead of letters | 21 May 2007 18:59 GMT | 1 |
Right now for some reason, I have numbers for both rows and columns' names. I would like to go back to the original setting of having letters as columns' names. Can anyone help? Thanks!
|
| auto-expansion of excel cells, turning it off | 21 May 2007 18:55 GMT | 2 |
I regularly paste text into the content bar in Excel 2003 that contain several lines of text--enough to cause word wrap to trigger and such. I like the word wrap, but I dislike that the cell expands to display all the content.
|
| Data Validation/Forms Combo Box | 21 May 2007 18:49 GMT | 5 |
I have created a worksheet that works splendidly involving Data Validation Drop Downs (DDVD). There are many formulas in this workbook. All was well until my boss told me that he prefers "the little hand instead of having to click on the cell to select the item he wants." ...
|
| How to sum more then 31 worksheets cell | 21 May 2007 18:45 GMT | 3 |
My one Excel file have 31 worksheet i want Cell A1 data of all 31worksheet in one worksheet with sum furmula (Summery worksheet) sum of all 31 worksheet cell A1 data in my summrey cell. i know only with + Exp =SUM('(1)'!B5+'(2)'!B5+'(3)'!B5+'(4)'!B5+'(5)'!B5+'(6)'!B5) till 31 ...
|
| Word has "compare documents" function, does Excel? Any way to do? | 21 May 2007 18:44 GMT | 2 |
In Word, you can pull up a file, click track changes, compare documents, choose another file, and it will show you the differences between the two very similar documents. Does Excel have anything like that? I looked at "track changes", but compare documents was not an option. ...
|
| Absolute Reference Problem... | 21 May 2007 18:37 GMT | 5 |
Hi Every One, I am using Excel-2007. I used this formula in cell R15C15 =$R12$C10*$R13$C10
|
| formula | 21 May 2007 18:31 GMT | 1 |
I have 2 workbooks, Weekly Totals and Monthly Totals. I would like the sum of each week in Weekly Totals (week 1, week 2, week 3, week 4, week 5) to appear in the workbook Monthly Totals. Some of the Weekly Total catagories are $ amounts and some are #' of patients. Does ...
|
| Take me to the number | 21 May 2007 18:30 GMT | 1 |
I've used this formula to count the number of order numbers that appear X number of times in one column: =SUM(IF(FREQUENCY(A1:A36533,A1:A36533)=X,1)) There is one order number that appears 6 times in column A and I need
|
| Can I use an IF statement to show a picture? | 21 May 2007 18:21 GMT | 3 |
I am using the following IF statement to show the % increase in costs, only if it is 10% or higher than the running average. If not the cell stays blank. =IF(AND(J11>10%,J11<>""),J11,"")
|
| Date/Time parsing and calculation | 21 May 2007 17:59 GMT | 8 |
I'm struggling with this one and would appreciate some help please. I have a Start Time fixed in C3, 10:20, in Custom format hh:mm. IOW, getting on for half past ten in the morning. In the body of the worksheet I have
|
| How to send worksheet so indicator will show with comments | 21 May 2007 17:49 GMT | 1 |
I am trying to email a worksheet that has comments. The indicator shows on my worksheet, but when I email the indicator is just numbers of comments listed. How do I send with the indicator?
|
| bluetooth - Broadcom | 21 May 2007 17:34 GMT | 4 |
does somebody know how to solve the following problem (which causes EXCEL 2007 to crash very often) ?; it has something to do with a bluetooth-add-in in EXCEL (sorry, I ony have the text in Dutch) : Probleem veroorzaakt door Btsendto_office.dll. Dit probleem is ...
|