| Thread | Last Post | Replies |
|
| Excel 2007 and the context-menu mini toolbar | 11 Mar 2007 22:58 GMT | 2 |
I searched through the Google archives and didn't turn anything up, so I'm hoping this hasn't been asked before. In Excel 2007, when I right click on a cell, I get a standard context menu. Above that is a little mini-toolbar thing for formatting
|
| Look inside .xls files | 11 Mar 2007 17:50 GMT | 2 |
In word when you are in the open folder window you can preview the insided of .doc files and decide which to open. In Excel under the same conditions the message " no preview available. Is there a way to do the same with .xls as with .doc files?
|
| macro's after transition office xp to office 2003 | 11 Mar 2007 17:46 GMT | 2 |
I recently changed from office xp to office 2003 I have several workbook linked to each other an one of them contains a few macro's that I - with much effort - concocted in VBA. After the transition I always get an alarm about these macro's, and I can
|
| Select rows meeting criteria into another worksheet? | 11 Mar 2007 15:34 GMT | 3 |
Is this possible? Users will enter records of work into a GeneralEntry spreadsheet. Each record includes a Client field, which they fill using a dropdown. Records are entered as work is completed, so client rows are not grouped together.
|
| adding a user defined function to the library | 11 Mar 2007 10:46 GMT | 5 |
In Excel-2000 in the list of function categories there is "user defined" category. If I have written a function how do I add it to the list? Also in which language this function is to be written?
|
| Help me save my job | 11 Mar 2007 10:13 GMT | 4 |
I have to do a simple task...but not simple for me! I need to take an incoming list of wood parts that have (1) quantity (2) part number (3) thickness (4) width (5) length (6) material
|
| Comma Delimited Export | 11 Mar 2007 04:42 GMT | 2 |
I use the following macro to export data in a comma delimeted fashion as opposed to save as .csv due to necessary quotation marks in the data cells. This works great, except that I have to do a SAVE AS on the file before the macro will function. Just a SAVE doesn't do it either. ...
|
| Using moExcelApp_WorkbookBeforeClose() event | 10 Mar 2007 22:15 GMT | 17 |
When using: moExcelApp_WorkbookBeforeClose(ByVal Wb As Excel.Workbook, Cancel As Boolean) and there are many opened sheets,
|
| Annoying save requests... | 10 Mar 2007 20:40 GMT | 2 |
Every time I open and view an Excel 2003 file, then close it, I get the same window: "Do you want save your changes?" even when I haven't made any changes. How can I stop this? Thanks.
|
| How to separate variables within a column | 10 Mar 2007 19:13 GMT | 1 |
I need help. I have want to separate one column into two. But I don't want to sort or filter, I want to make two extra columns, so I can view the data side by side, how do I do it? eg
|
| Prevent format change caused by pasting. (office '97) | 10 Mar 2007 17:53 GMT | 1 |
Every time I paste something that was from an website (even if only one word) the column extends as far right as it allows. I found out that I can change the format (under paste special) back to text to fix this.
|
| Cannot COPY then PASTE | 10 Mar 2007 17:53 GMT | 10 |
Repost from another newsgroup I am probably doing something very stupid. I have been using EXCEL since it's inception, and have developed many worksheets and VBA code. I am not a newbie.
|
| Modify Spreadsheet View | 10 Mar 2007 16:42 GMT | 1 |
I have just imported finance data into a spreadsheet. It went well but there are columns in the view that have no data. If I could eliminate columns L to the end the remaining columns would be larger. I also see 'page tabs' where there is apparently no data as well. Would ...
|
| Excell help | 10 Mar 2007 14:41 GMT | 2 |
What does it mean if you see ####### in a cell
|
| charting | 10 Mar 2007 14:02 GMT | 1 |
i have a column for person's name, and serveral other columns with values on time used for TV, CD, etc.. how can i generate a chart which presents to me a list of all names with the time used for TV, CD, etc during year 2006 ?
|