| Thread | Last Post | Replies |
|
| Macro to create new files | 14 Nov 2007 19:03 GMT | 3 |
I have a .csv file with a single column of data. I want to create a separate .csv file for each cell in the column utilizing a macro since there are over 600 cells in the row. Any advice on how to create this macro to automate the process?
|
| Explode Button to review a Formula | 14 Nov 2007 16:34 GMT | 1 |
I want to quickly review a formula written by others; in particular, the cells it has refered to. I have seen "Explode" button in other's computer which reveals a mini-window detailing each of the reference cells, its value and location.
|
| Excel header how to automate for new worksheets | 14 Nov 2007 01:25 GMT | 1 |
I want to ensure that all worksheets including new ones created in a document automatically have the same custom header and footer. Can anyone help. I have a lot of templates established and need to get this sorted for all of them.
|
| file extention .xsls | 13 Nov 2007 22:22 GMT | 3 |
When I create a new excel workbook the file is given the extention of .xsls. This file extention is an excuitavble file and wil be blocked by many servers. How do I change the extention name? How so you change the default setting to .xls?
|
| Can't see highlighted selections | 13 Nov 2007 21:53 GMT | 3 |
When I make multiple Cell, Row and or Column selections I can not discern what is selected. The highlight color is so pale you can only see the first selection. How can I change the color of selected items?
|
| Transferring a cell value to another sheet | 13 Nov 2007 16:34 GMT | 1 |
Is it possible to input a formula to transfer a cell value from one sheet to another within a spreadsheet eg to make C7 in sheet 1 equal C7 in sheet 2 ?
|
| Offline Help File | 13 Nov 2007 15:56 GMT | 5 |
I have a dial-up connection, and it's really irritating when I click on the Help button, to look up the syntax of a function, and Excel tries to look it up online. It takes about three minutes, and, more often than not, crashes. I have the Help information on my computer already. ...
|
| How do I set a drop-down to auto-pop. by typing first letter? | 12 Nov 2007 21:34 GMT | 2 |
Set up a drop-down, but want to be able to type a letter to send it to the first letter in the drop-down list. For example, if you had a list of states, and you hit the "W" key, it takes it to "Washington"
|
| Conditional formating | 11 Nov 2007 10:24 GMT | 1 |
I have a spreadsheet with multipe dates I want to have dates less than 01/11/2007 in the cell to turn into R with Red background and for dates more than 01/11/2007 to turn into X with Green background and all blank cells to be blank. I can do some of it with 2007excel
|
| Problems with opening a VBA contained excel file? | 08 Nov 2007 20:01 GMT | 3 |
When I want to open a file that contains Visual Basic program in Excel 2007 I face this Error message: Opening the VBA project in this file requires a component that is not
|
| excel format | 08 Nov 2007 17:06 GMT | 1 |
i need a draft for timber sizes in excel format
|
| "Delete interactive button" | 08 Nov 2007 02:43 GMT | 2 |
I copied a page from a web site onto an excel sheet that has an interactive button and search box on it. How do I, or can I, delete that.
 Signature Ferret Mom
|
| formula marker | 07 Nov 2007 13:14 GMT | 2 |
In Lotus, there was a setting where you could turn on formula markers and any cell with a formula in it would contain a dot. Is there a similar setting in Excel without having to actually view the formula?
|
| Excel -My paste menu is not the norm. The menu is different. | 03 Nov 2007 20:07 GMT | 2 |
When copying a formula, Excel copies the results of the formula and not the formula. Also when pasting the Special Paste option brings up options that are not the same. They are Excel 8, Bitmap instead of Format, Column width, values and number formats.
|
| XLSTART-Creating a toolbar | 01 Nov 2007 18:20 GMT | 2 |
I created a toolbar and it has been working great. I have my file in the C:\program files\micosoft office\office11\XLstart folder and has been working fine. However; I just installed sp3 for office 2003 and there is one user that it won't launch the file. I did however figure ...
|