Summary: If you really trying to simply delete every other row in a range, try this "generic" method: 1 - In a blank column in your spreadsheet, enter A in the...
Summary: My function isn't working. The calculation comes out wrong. I'm trying to use the COUNTIF function in Excel 2003. Here is what I'm trying to do. I...
Summary: Dear Concern, I have an excel 2003 sheet filled with data. Now i want others to add the data but not edit the old data expect me. If some one can sugg...
Summary: Hi I'm trying to work out how to devise a formula in Excel 2003 which does the following ... Searches a range of cells for a certain text value 'False...
Summary: Hello, I need to perform an Autofilter function in Excel 2003 that allows me to filter a list using the contents of another cell as the criteria. For ...
Summary: I used to prepare monthly progress report where i have to delete the figures under monthly column whenever there is no expenditure during the month al...
Summary: I know how to hide formula by unlocking and hiding the cell properties then by applying worksheet protection. I want to know how to hide formula but a...
Summary: Let's say your list of goods is in column A of Sheet1. Let's say you are entering a quantity in Column B or C of Sheet1. Right click the sheet tab for...
Summary: Webpage content saved as .xls file has no problem while opening in excel 2003, excel 2000. but while opening in excel 2007 its giving the below warnin...
Summary: When you have a long value in one cell and the cell(s) to the right has no value, Excel displays the text overlapping the blank cells. You can set the...
Summary: Excel by default allows that many rows, and the columns actually go to IV. If you have no data in any of those cells, there will be no effect on the ...
Summary: Dear Friends I have excel sheet made of many rows and column, out of that one 03 column in a row need to input the number and all others are formulas....
Summary: Jillian, The only time I've seen this problem in excel 2003 is when you are using wrap text and autofit with merged cells - Excel won't automatically ...
Summary: I have a series of worksheets, each containing approx 5000 rows of data. This data is ordered in four columns Chainage, Easting, Northing and Elevati...
Summary: Hi everyone, I'm working on a large worksheet on Excel 2003, with over 1000 rows. Each row consists of one movie, and each column provides information...
Summary: Concatenate (combine) Header Row with Variable Number of Detail Rows I need help writing an Excel VBA routine. My input worksheet consists of rows, wi...
Summary: Hi! Excel Gurus, let say A1=2 and B1=5 then i add B1 with A1 in B1 which is = 7 i.e. B=7 (i entered this formula in B1 cell: =sum(5+A1) Now the questi...
Summary: Hi, The formulas for conditional formatting that DerbyDad03 gave you do work in Excel 2007. Maybe you didn't enter them correctly. Excel 2007 has a lo...
Summary: I have a Parts spreadsheet that I want to be able to fill in the first column in a row, which is the part number, and then it automatically fills in t...
Summary: Could some one please tell me how to construct a macro, in excel, to delete rows that in a collumn aren't multiples of 300. Thanks in advance ...
Summary: In Excel 2003, you can select a number of columns that are numbered sequentially and drag the cells down with the lower-right hand corner tool. This ...
Summary: Perhaps it is different for Excel 2002 but in Excel 97 you are limited to 256 columns and 255 sheets per workbook. So the maximun number of columns in...
Summary: My newly installed excel 2003 cannot display the changes to cell formatting, i.e.the color of the word and fill of the cell, but it can display normal...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
