Summary: Hi, I'd like to minimize and maximize rows in excel. Note: I don't want to hide them, but I'd like to add the feature that comes up the left portio...
Summary: Hello, how to set the type (text, number, date,..) of column in EXCEL with VBA? (not manually through Ctrl+1 -> Format of Cells ->...) Thanks for your...
Summary: On worksheet 1 - I have a 2 columns and several rows of data. Column A has product names that are repeated. On worksheet 2 I want Cell A3 to show a l...
Summary: Hi, is there a way to reverse the order of all the rows in a spreadsheet in Excel 2003? By this, I mean I have rows 1 to 50, and I want row 50 to move...
Summary: If I have a formula in A1 that reads: =sum(a2:a5000) to get the sum of up to 5000 rows. Is it possible to have that value remains as 5000 after I ins...
Summary: I have two works---s with the same data (there is a big list of the goods) what I wish to do is: I wish to enter quantity of goods in works---1 but in...
Summary: Hi all, having a problem trying to merge rows in a client database due to duplications. What I need to do is merge all values into one row. Format is ...
Summary: I want to sample a cell in Excel and if it is empty, I want to delete that row. I can delete a row using the row number but can't do it using a variab...
Summary: Hi Guys, I know this is simple, but I'm very new to the MS office environment. Does someone know what I would do to add duplicate rows in excel based ...
Summary: re: I doubt if I can determine the version of XL In any Excel spreadsheet, click on Help...About Microsoft Office Excel to get the version. re: wherea...
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: I have a column of numbers in excel 2003, but it won't recognize them as such--the report in excel was generated from another app. Is there any way to...
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: I need to Sort an entire row by date automatically (close of escrow). I would like to be able to hit a button and the sheet sorts all the rows by date...
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: 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: User has an excel spreadsheet created in Excel 2000. The spreadsheet is fairly simple, a listing of meetings with several filters inserted. The user t...
Summary: What did this function do? Is it possible that URLEncode was a User Defined Function. A User Defined Function is a function written in VBA and made ac...
Summary: We haven't created any pivot table. We just have the data. The data in each sheet looks like this (one row details where ABC is the name of the employ...
Summary: I m facing a problem and I am bounded to work in excel: Hope u all will help me after reading the following situation. Let me discuss it in detail: I ...
Summary: Hi, I have a problem, I have a column (lets say column A) in Excel that contains data of type date, I converted it to date using the formula DateValue...
![[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
