| Thread | Last Post | Replies |
|
| Confusion with Names | 10 Oct 2006 03:00 GMT | 1 |
When I go to the VBA IDE of a workbook, I see the Project Explorer, Properties Window, and the Code window. If I look at the Project Explorer, each worksheet is titled Sheet1(Sheet1). In the Properties Window, I see two types of names: (Name) and Name, i.e., one enclosed
|
| adding comments to protected sheet | 10 Oct 2006 01:47 GMT | 1 |
I would like to know if I can add comments to a sheet that is protected. Although the sheet is protected the cell is not locked. Can this be done?
|
| Merge worksheets | 10 Oct 2006 01:14 GMT | 8 |
I have two worksheets in "list" format. I would like to merge these two list into a third worksheet if possible.. If not possible merging into one of the original worksheets is ok. Both of these tables "lists" are sequenced by the first column (a text field
|
| Another MATCH and INDEX problem | 10 Oct 2006 00:33 GMT | 1 |
Using Excel XP. I have a 31 worksheets in a workbook that are the days of month of October. In each sheet I have a 24 hour period of certain weather data, such as temps, humidity, winds, etc.
|
| Formulas | 10 Oct 2006 00:28 GMT | 2 |
I'm a teacher and I'm trying to use exel to do grades. How do I find the total for a row of grades and then find the average against total points possible? HELP!
|
| Numbers show instead of text | 10 Oct 2006 00:16 GMT | 3 |
I entered text into some cells, and it shows up as numbers. What do I do?
|
| Incrementing Workbook Names | 09 Oct 2006 22:10 GMT | 7 |
I have a template ExceptionReport.xlt. I have code that generates a workbook out of it, and saves it. The new workbook always gets the name ExceptionReport1.xls, regardless of how many times I run it. How do I communicate to Excel that I'd prefer the second one be named
|
| Setting custom zoom settings. | 09 Oct 2006 20:36 GMT | 1 |
Setting custom zoom settings. Re EXCEL97 under WinXP-Pro w/SR-2 My eyesight is not like it used to be, so I’d like to be able to quick switch between different zoom factors. The menu bar gives the option of
|
| Problem with web page created in Excel | 09 Oct 2006 20:31 GMT | 1 |
I used Excel to create a web page with multiple sheets. I've done many web site before using Excel (yeah I know its probably a bad idea generally to use Excel to make web pages, but its easy, and for what i need it for, it is usually fine). In this case, it still works, but its
|
| remove document protection | 09 Oct 2006 18:51 GMT | 1 |
We have a exel sheet with document protection, the person who maked it, is no longer avalible. How to remove the projection or move the data to another sheet.
|
| How to merge and compare | 09 Oct 2006 18:48 GMT | 1 |
Hai, How to compare two work sheets or two workbooks in excel. thanks in advance regards
|
| XLS Viewer for 98SE | 09 Oct 2006 18:12 GMT | 8 |
Viruses wiped out my viewer and Microsoft has stopped supporting 98. I've googeled and tried several and no luck. Anyone know where a viewer can be found? Rex Hall
|
| Determine next Saturday in calendar based on date in a cell | 09 Oct 2006 17:09 GMT | 4 |
I need to determine the following Saturday based on a given date in a cell. For example, in one cell I have a date of 10/8/2006 - I need a function to return the date of 10/14/2006.
|
| embedding flash file | 09 Oct 2006 16:47 GMT | 1 |
Hi every one, I would like to embed a flash file in my excel document so that when I open the file I can view the player playing the clip automatically. Can some one please advice me how to do this?
|
| toggling between open work books | 09 Oct 2006 16:39 GMT | 4 |
Re EXCEL97 under WinXP-Pro w/SR-2 Microsoft Windows allows you to easily toggle between applications using Alt-Tab. Is there a similar key board to toggle between two open workbooks in Excel? One can use Alt-W to display list of open
|