| Thread | Last Post | Replies |
|
| How do I default to open documents in a new window in Excel? | 12 May 2008 02:44 GMT | - |
I would like to be able to set Excel to open new documents in a new window. Currently, documents open in the same window, so if you close the window instead of the document all open Excel documents close and I have to go back and re-open them. We use multiple file systems so this ...
|
| Default value for selected cell colour change Excel 2007 | 11 May 2008 22:56 GMT | - |
How do I change the default highlight value so that it is possible to see the highlighted selected cells within an Excel 2007 sheet. i.e. selected rows and or cells. I wish to set this so that it always has this value for any sheet. I am
|
| How to add info thru macro | 10 May 2008 20:01 GMT | 1 |
I need help with a macro that should help me add info to a sheet. I have a list of customers, and I keep on adding, and I want to post the new customers to the cutomer list by thru a macro, and it should add it to a new line to the list and then sort the whole list to ...
|
| How do I copy a header and footer to multiple worksheets? | 10 May 2008 19:06 GMT | 6 |
I have a worksheet that has a custom header and footer and I need to copy it to 40 worksheets, is it possible to do without goining into each worksheet individually and setting it up? I am using Excel 2003. Has anybody encountered this problem?
|
| Number entered in cell getting always divided by 100 ! | 10 May 2008 09:40 GMT | 1 |
I use excel 2007. Whenever i enter a number in cell, it gets divided by 100. For example, when i enter 10, it displays as 0.01. How to resolve this problem ? really frustrated with this error ! DKL
|
| Variance Report - Need to reflect 0% | 09 May 2008 18:29 GMT | 1 |
Hello! I need my variance number to show 0% even when the formula's answer is #DIV/0!
|
| running multiple instances | 09 May 2008 15:08 GMT | 2 |
First of all this may not be as much as an excel issue as it could be a dual monitor issue. I have two monitors on one computer and would like to have two excel spreadsheet open at once, one on one monitor and another on the other
|
| DEC2HEX with VBA in Excel 2007 | 08 May 2008 23:59 GMT | 5 |
I have a program working with Excel 2003 with VBA that uses the DEC2HEX function within the VB routine (not in the Excel sheet) I have turned the Analysis and the Analysis VBA add-in on. I have also checked the atpvbaen.xls reference on in the VBA tools section.
|
| How to reset incorrect date format after reinstalation of Window X | 07 May 2008 22:34 GMT | 3 |
Thank you very much in advance if someone can assist. I need to reinstall the window XP. After the installation, the contents of the "Date" column have been change as follows: 18/02/2008
|
| File Paths and Carrying Data into Future Budget Periods | 07 May 2008 18:38 GMT | - |
I am currently using Excel 2003. My budget worksheets consist of 10 workbooks which all have cells linked to each other. (exa: Salaries links to Employees which links to Resource which links to Summary). I start with a file folder for 07_08 in which I create a
|
| how to set shading color of selection when i am selecting cells? | 07 May 2008 05:14 GMT | - |
When i select some range of cells, the selected range will be displayed in shaded color. however, the shading is too thin, so it is difficult to see the range of selection. how can i set the shading color when selecting a range of cells in Excel 2007?
|
| Only show one tab in a new workbook. | 06 May 2008 20:42 GMT | 3 |
Every new workbook opens with three worksheets (tabs)...how many times do you need three worksheets in a workbook?? I'd rather create my own when I need them. Just give me one worksheet. ----------------
|
| Obsolete workbook names in "Open" | 06 May 2008 18:42 GMT | 1 |
How do I delete obsolete names from "Open" ?
|
| How do I change the Tab to tab over one cell only versus several? | 06 May 2008 17:40 GMT | 1 |
Excel 2003, I can not tab to the next cell - it automatically tabs several columns over.
|
| MS Excel Autofill for directory locations | 06 May 2008 13:44 GMT | - |
How do you turn on the feature to autofill directory locations in the File Open or File Save dialog box? Windows XP would allow me to key only a few letters and then hit tab and it would autofill the rest of the directory location.
|