| Thread | Last Post | Replies |
|
| Formulas in excel 2007 | 26 Nov 2007 02:08 GMT | 2 |
Hi, I have a workbook that was created in excel 2003. Now we are using excel 2007. The formulas don't work work anymore. Also, simple charts that were created in excel 2003, if you change the
|
| number increasing | 25 Nov 2007 23:34 GMT | 4 |
Is there a way in a master worksheet to put a formula in a cell which contains a number such as 15846 and have that number increase by one in the same cell when you make a copy of the original worksheet.
|
| Conditional Format Font Style in Cell | 25 Nov 2007 23:29 GMT | 2 |
In Excel 2003 changing the font colour when a certain value was reached was easy. I have tried without succsss with Excel 2007. Okay to highlight the cell but I don't want that. Can anyone help? TIA
|
| Count certain values | 25 Nov 2007 23:05 GMT | 7 |
I have a spreadsheet that has column A with names, column B with their choice of meal. Example: A B
|
| office 2007 excel | 25 Nov 2007 22:17 GMT | 1 |
i want to customize my toolbar by adding two buttons like making a macro toolbar that has two options below it .can anyone help?
|
| Spreadsheet view does not refresh when using mouse wheel | 25 Nov 2007 21:44 GMT | 3 |
When I scroll in a spreadsheet with the mouse wheel (3 brands of mice, two PCs, Excel 2007, same error) the view for some of the cells does not refresh. In other words the cells contain data, but it is invisible. If I use the page up/down keys this does not happen. If I
|
| Excel 2007 - One pivot table; multiple sheets | 25 Nov 2007 21:23 GMT | 2 |
All - I have a workbook with 5 sheets. All sheets a different number of rows and all have at least 40K rows. I have two columns for which I'm creating a pivot table. I've been able to do that for one sheet.
|
| Moving Data Automaticaly | 25 Nov 2007 20:23 GMT | 3 |
Can you help I have a table (part shown below) the Date and Day moves automaticaly to left at midnight - is it possible to get the rest of the data to move as well 25-Nov 26-Nov 27-Nov 28-Nov
|
| Vlookup Formula | 25 Nov 2007 15:46 GMT | 4 |
column J has dates (days of each month). Column K has numbers. the whole rang is J7:K38. E12 has a date and F12 has a number. In cell G12, I need to:
|
| Unlocking The Positioning Grid And Printing Question | 25 Nov 2007 14:54 GMT | 3 |
Thanks for previous help. Using Excel 97. Two questions, please. a. Something new; never had showup before.
|
| Insert Comment Macro | 25 Nov 2007 10:18 GMT | 4 |
Hello, Group I tried to use the macro recorder in Excel 2003 to create a macro to insert a short comment in the active cell. I keep getting a "run time error 1004", which is an application-defined or object-defined error according to the
|
| un-consolidating a list | 25 Nov 2007 07:19 GMT | 1 |
I have a PDF document that has 4 columns: Line number, Employee Number, Last Name, First Name. When I export this, I get a document that has one column, in the following pattern, once per page:
|
| Setting number in cell back to zero | 25 Nov 2007 05:55 GMT | 2 |
I asked this before and got no real answer so here goes again ----A----B----C 1............0 B1 is where I want to enter a number lets say 5 -
|
| Formula to Calculate Dates | 24 Nov 2007 17:43 GMT | 1 |
I need to enter one date, and have it compute the future date based on the number of years: For Example: - Date Added: June 2007
|
| Entering a Formula / Wrong value | 24 Nov 2007 17:04 GMT | 1 |
I have inserted a new column into the work sheet called column D, I have named the cell D1 Service. In cell D2 I enter the formula =(TODAY()-E2)/365 and should come up with the Value 4.9 in D2 and them drag the fill handle down 14 cells to compute the rest of the length in the ...
|