| Thread | Last Post | Replies |
|
| how to subscribe to this list in hotmail? slightly off topic | 18 Jan 2008 00:03 GMT | 3 |
I need this list at work. does anyone know how/if you can subscribe to the excel list through hotmail? It seems at work that I can't get the lists through this page. It doesn't allow a popup for me to respond to a question or ask a question. I have popups enabled. This ...
|
| #N/A | 18 Jan 2008 00:00 GMT | 4 |
Is there anyway to return "0" when a cell receives the #N/A error? Not in the same cell, but another one so it can be used in a new formula. Ex: =IF(C81="#N/A", "0") This didn't work.
|
| Inserting several new rows | 17 Jan 2008 23:13 GMT | 1 |
I have a spreadsheet with about 1500 rows. I want to insert 18 black rows after each existing row. Is there a quick way of doing this without having to do this after each row?
|
| Table of Tabs | 17 Jan 2008 22:39 GMT | 3 |
Trying to create a "table of contents" of all my tabs in a worksheet. I've seen this on other worksheets as a hierarchy list of tabs on the left of the screen... like a folder view... any suggestions?
|
| vlookup cell reference | 17 Jan 2008 22:35 GMT | 2 |
What formula can I use to return a cell number that a vlookup output references. For instance: Data in A1:A3 = X,Y,Z
|
| Column Heading 2 Lines | 17 Jan 2008 22:34 GMT | 3 |
How would I put "One Two Three Four" in a column Heading with "One Two" on 1 line and "Three Four" under it or on a 2nd line? Thanks NotGood@All
|
| sort by color | 17 Jan 2008 22:10 GMT | 3 |
is therer a way to group or sort so all my cells that have a blue color will go to the top?
|
| Having issues with exporting | 17 Jan 2008 22:09 GMT | 3 |
I am trying to export a spreadsheet out to a file type that is compatible with my GIS. In older versions of Excel, one could export out to a .dbf file, which was usable. Now, that option has been removed, so I'm stuck having to use a text file. However, when choosing .csv as ...
|
| Excel files don't open until a click on blank worksheet | 17 Jan 2008 22:07 GMT | 1 |
I'm having a weird Excel problem that I can't figure out the origin of. It's been happening ever since I installed 2007 many months ago. If I double-click an Excel file to open it, Excel opens and a worksheet called Personal appears. However, the file I clicked on
|
| averages that ignore #VALUE! cells | 17 Jan 2008 21:43 GMT | 7 |
I am making a spreadsheet in excel that will add subtract times and then average the totals of multiples of these. My problem is that some of the tiems do not need to be entered causing a # VALUE! in teh line where my subtraction formula. This is fine and needs to stay this way ...
|
| Replacing formula with round multiple times | 17 Jan 2008 21:42 GMT | 1 |
I have a spreadsheet that has around 12000 lines, in column D there is a formula that creates a value such as 2000.123524. The value needs to be exported to another application but I have to remove the decimal places first.
|
| The color of gridlines | 17 Jan 2008 21:22 GMT | 1 |
I am having a problem seeing the gridlines in excel, I am used to Excell 97 and in this new form the colors are to light. I would like to make them darker and have them stay that way. I can change them for the current project but would like to have that be the norm. If anyone ...
|
| Formula Won't Work after 10 Cells | 17 Jan 2008 21:09 GMT | 4 |
At my job we do reports where there is a list of 10 items that use formulas. These 10 work great, but if we add any more to the list and copy down the formulas, the formulas don't work! Has anyone ever heard of this before? Any suggestions? We keep having to manually calculate ...
|
| excel search formula | 17 Jan 2008 20:49 GMT | 10 |
I'm trying to create a formula that searches a column for the last cell that contains data, and then returns that value to a cell in another worksheet. Could anyone help me out with this? Thanks
|
| Profress Indicator | 17 Jan 2008 20:42 GMT | 2 |
I have this bit of code but I'm having problems with it, could you take a look and point me in the right direction? I can't seem to get the form to update. Thanks
|