| Thread | Last Post | Replies |
|
| Save As HTML | 25 Oct 2006 00:01 GMT | 2 |
I'm trying to Save As HTML in Excel so I can publish my sheet on a web page but that HTML isn't an option listed on my Save As drop down menu. On the help index it appears that they want me to install that option from the CD but all I get when I try to find any option for Excel ...
|
| Check if Number in Excel | 24 Oct 2006 22:04 GMT | 1 |
In MS Excel, I want to check if the value in the cell above a cell is numeric. For eg I want a formula in Cell D8 if value in Cell D7 is numeric. How do I do it.
|
| Cell reference displays 0 instead of blank | 24 Oct 2006 19:45 GMT | 3 |
In a multi-sheet workbook, if I reference a cell in another sheet (using =SheetName!Cell) that is blank, the result displays as a 0 (zero). If the cell being referenced is indeed blank, I need the value returned to be blank as well. I know I can turn off display of zero values ...
|
| Cannot open Excel files by doubleclicking on file | 24 Oct 2006 19:44 GMT | 1 |
This may really be a Windows problem rather than an Excel problem. But on a users PC, if they double click on an Excel file in Explorer, Excel opens but with no spreadsheet. It does not open with the selected spreadsheet, or a blank spreadsheet but just the program with no open ...
|
| numbering rows | 24 Oct 2006 18:19 GMT | 4 |
I'm using excel 2002 and I want to add an additional column that counts the rows. I have created it and numbered it, but when ever I do a sort, the numbers get sorted and they are out of order. Is there a way to keep them in order while sorting?
|
| How do I get Plus and Minus signs in my additions and subtraction | 24 Oct 2006 18:11 GMT | 1 |
How do I get Plus and Minus signs in my additions and subtraction formats? I have a report that I exported into Excel and it is missing the "-" and "+" from the grid. How do I get them back?
|
| Importing a Web Query | 24 Oct 2006 17:22 GMT | 4 |
I have a little problem when importing a web query. I go to the the Data menu and choose the "New Web Query" option. Then I go the following page: http://www.banxico.org.mx and click on the "Mercado cambiario" link then I clic on the yellow arrow
|
| Misaligned Reports | 24 Oct 2006 16:44 GMT | 1 |
One of my clients sends me sales reports that are generated by a custom program, and create excel spreadsheets. I have two questions about these reports: 1. There are a number of columns (a. Store, b. Qty Delivered, c. Qty Sold,
|
| Grafiek assen 90 gr. draaien | 24 Oct 2006 14:41 GMT | 1 |
Hallo allemaal, Ik wil de assen van een lijngrafiek draaien zodat de x-as vertikaal komt te staan en de y-as horizontaal. Ik heb iets geprobeerd met een spreidingsgrafiek maar dan heb je 2 waarden assen en geen categorie as.
|
| Add trendline to stacked column chart | 24 Oct 2006 14:25 GMT | 1 |
Apparently, this can not be done. Can anyone confirm or refute? Thanks.
|
| Finding Friday in week number | 24 Oct 2006 10:04 GMT | 5 |
Hello, I have a week number and am trying to find the date of the Friday in that week. The week number is selected in a drop down and used elsewhere so I can't change it but need to derive the date of the Friday in the selected week number. Can't find a way of doing this with my ...
|
| Help w/ summarizing a mess of excel data from different sheets? | 24 Oct 2006 09:22 GMT | 4 |
I'm not sure if this is the right place to post this. I really appreciate any and all help from you experts!! So here's the example: I have a mess of data sheets with sales numbers
|
| Copy/Paste into Excel; how do you keep leading zeros? | 24 Oct 2006 08:55 GMT | 2 |
Simple example: Suppose you have some data typed in Notepad. It looks like this: 001 002
|
| sum cells | 24 Oct 2006 08:53 GMT | 2 |
I am trying to total employee schedule so some cell have D/O day off, R/O requested off, so when I try to total all associates by the day I get #VALUE! in cell and total cell. Is there a way to total only numbers and ignore #VALUE!
|
| how do you insert a regression line on a chart? | 24 Oct 2006 04:09 GMT | 1 |
i'm need to add a regression line to a chart i'm makeing for a physics lab. does anyone know how to add a regression line to a chart?
|