| Thread | Last Post | Replies |
|
| how do i create an access code sheet to number my office files an. | 12 Feb 2005 03:49 GMT | 1 |
im new to this office. the former person made an access code sheet (looks like it was made in excel, but im not sure) the sheet numbers and color codes files that are in the office. i guess the former did not save the sheet, and i need to add new files. So if i need to make a ...
|
| Conditional Formatting | 12 Feb 2005 03:31 GMT | 2 |
How do I set a conditional formatting? Thanks Michelle
|
| Publishing a pivot table | 12 Feb 2005 00:24 GMT | 1 |
I have a friend who wants to publish a pivot table. We go throught the Excel dialogs to publish and 'Add interacvtivity' with 'PivotTable functionality' but he only gets the table showing with no data. There is also somebody else with a similar problem where the Published web
|
| how to copy on double-click the cell value to Clipboard | 11 Feb 2005 23:29 GMT | 2 |
My question is in the title... I just want to be able to automatically copy the text content of one selected cell (selected by double-click) into the Clipboard. Can you help me? I tried something like the following, but it doesn't work.
|
| Pictures with Macro's attached to it are displayed as red cross | 11 Feb 2005 23:19 GMT | 2 |
I am having trouble with spreadsheets with macro's in it: in the excel sheet there are icons/pictures which have a macro attached to it. When you click the icon/picture the macro will execute. When the user, running Windows XP SP1 and Excel 2002 with macro security
|
| FileSearch problems | 11 Feb 2005 22:11 GMT | 1 |
I do not seem to be able to make FileSearch macro to work properly. It seems that it works on some installations and not at all on others, and even when it "works" I have to go through hoops to make it work. Purpose of the macro is to open a file as a worksheet. File is of a
|
| i need an example of a hourly and weekely pay sheet | 11 Feb 2005 22:06 GMT | 1 |
i need to create a paysheet that will allow me to pay my employees per hour.
|
| When using CtrlF, told formula too long | 11 Feb 2005 21:59 GMT | 6 |
I am working in Excel 2003, I have 4 spreadsheets 1st QTR thru 4th QTR and then another sheet which is a summary. The summary report is readng info from the QTR reports. Now I would like to Copy QTR 1 to QTR 2 and do a control find 1st Q and replace with 2nd Qtr, but it
|
| Page SetUp Print Problems | 11 Feb 2005 21:41 GMT | 1 |
A friend has a spreadsheet that is giving him some problems. We go to Page Break Preview and the sheet is 2 pages wide. My friend wanted to make 1 page wide so we dragged the blue line to the right to make it one page. Excel, instead of doing that, made it 20 or more pages. We
|
| Excel macro problem | 11 Feb 2005 21:36 GMT | 3 |
i currently convert an excel file to newer excel version. In the excel file is a macro command named "FORMEL.SUCHEN.UND.ERSETZEN" (englisch: FORMULAR.REPLACE). The problem is, that Excel crashes at this command and i can't find the bug. Maybe the parameters has changed, but i can't ...
|
| Range name special characters | 11 Feb 2005 21:33 GMT | 3 |
A quick test shows that Excel allows only two special characters to begin a name: \ and _. That is, I can define these two names: \Foo _Foo
|
| Prompt on selection of cell? | 11 Feb 2005 20:19 GMT | 2 |
In the invoice template that is supplied with excel (Sales Invoice 1) they have a feature I haven't figured out. If you select one of the cells at the bottom, a text box pops up giving instructions for what to do with that cell. It is much like a comment but it isn't a
|
| Unsaving a file | 11 Feb 2005 19:43 GMT | 2 |
Does anyone know of a way to unsave a file? A user accidently saved a file instead of using the save as option. So he saved over information he didnt want to. So is there any way to get the orginal document back? TIA
|
| Label/data hidden | 11 Feb 2005 19:10 GMT | 1 |
I need to know if there is any way that I can program cells so that they will display a name (such as 'Group 14'), but 'underneath' the name there's a number that can be used in a row so that it can be one of the elements in e.g a sum.
|
| How do I make a template to choose a new school name? | 11 Feb 2005 18:35 GMT | 1 |
We are consolidating 2 schools and will have a new name. There will be a number of suggestions for names. I want to be able to analyze according to the criteria we have to work with and be able to grade selections according to criteria we have.
|