| Thread | Last Post | Replies |
|
| why my mouse wheel is doing zooming | 10 Feb 2007 13:03 GMT | 1 |
i dont what i did , that my mouse is zooming in and out on scrolling wheel at work sheet , kindly help me to stop it thankyou Sohail gagai
|
| how do i delete a * at the end of each word in a column | 10 Feb 2007 02:18 GMT | 2 |
In a column I have all last names followed by * e.g. Jones* How do I delete the * Thanks in advance for your help
|
| How to represent a column in Excel | 09 Feb 2007 23:06 GMT | 3 |
Hi, everyone I currently have a formula. {=SUM(IF((Data!G2:G75="Verified")*(Data!K2:K75<=7),1,0))} However, the length of both column G and K are not fixed.
|
| How do I add a copyright (c) symbol to Auto Correct | 09 Feb 2007 22:42 GMT | 2 |
My windows XP does not include the copyright symbol in auto correct. How do I add it to auto correct. Thanks.
|
| conditional formula for blank cells | 09 Feb 2007 22:13 GMT | 3 |
I have a conditional cell color based on a formula to identify blank cells & populated cells. I want to now count the cells that meet the formula criteria. I get accurate counts with the populated cell formula count but because I have an isblank in my blank cell conditional ...
|
| Sort across multiple worksheets in a workbook | 09 Feb 2007 22:09 GMT | 4 |
I have a workbook in Excel 2003 that has 10 worksheets each laid out identically with the same one-line header having 8 columns but varying number of rows, say R1, R2... ...R8 that is are added to daily. I expect in time the total number of rows in the 10 worksheets will
|
| sumif problem | 09 Feb 2007 21:14 GMT | 3 |
I have been using sumif to total cell values from 4 different sheets. Now I added a fifth sheet. So I went into my sumif formula for a cell and added the additional sumif for the new sheet. In the cell that is suppose to show the total, I get ############. what did I do wrong?
|
| Turning Off Auto Fill Options | 09 Feb 2007 19:59 GMT | 2 |
How do you turn of the Auto Fill Options so when I copy a cell over that little popup stops popping up and offering "Copy Cells", "Fill Series", etc. It's more annoying than it's worth. I'm using Excel 2003 and thanking you in advance for your help.
|
| berekenen in een nog niet bekend bereik | 09 Feb 2007 19:55 GMT | 1 |
Hoi, ik wil het aantal weken berekenen op basis van het aantal dagen. Het aantal dagen staat in kolom H. Het aantal weken moet komen in kolom I, een nog lege kolom dus. Ik weet niet hoeveel rijen er in kolom H (dagen dus) zullen zijn
|
| Excel Formula Poser | 09 Feb 2007 18:41 GMT | 3 |
I have created a worksheet to provide details of resources. Within the worksheet are separate sheets for each month this financial year (i.e. Feb 2007 - March 2008) Along the top I have three separate rows with differing rates for
|
| Printing empty rows | 09 Feb 2007 18:17 GMT | 1 |
I have a worksheet of 30 rows and 2 columns There are intermittent rows that have no data How can I print the worksheet and not have the spaces due to the empty rows. For example Here is a portion of the follwoing worksheet:
|
| unable to use tab on protected sheet | 09 Feb 2007 18:07 GMT | 2 |
Hi Experts; I have a excel file with password protected sheet; I can not use tab key on this sheet. Is it possible that I can use tab key on a password protected sheet.
|
| Concatenate Problem | 09 Feb 2007 18:01 GMT | 1 |
I don't know much about macros in excel but have used a few from the postings from this group I am trying to create FIPS code for counties, the way I have the data, the state code is given by 1,2,3....50, the county codes are 1, 2,3....15...100. To make a fips
|
| Pivot tables with external data source | 09 Feb 2007 17:46 GMT | 3 |
I use a lot of pivottables with connetions to external data sources. Sometimes I need to modify the queries, and I do this by using the pivottable wizard, and press "get data" from step 2 in the wizard. I then get access to MS Query and can edit whatever I need to. But from time ...
|
| Overactive hyperlinks | 09 Feb 2007 17:19 GMT | 6 |
I am using an excel spreadsheet for my personal address book. One column of cells contains a web address or an email address. Once in a while I'll accidentally click on one of the web addresses or email addresses. This, as expected, starts up either my browser or
|