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: 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, 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: 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: 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: 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: 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: 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: 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 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: 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: Could you kick the file out to a .csv instead? When you import a csv file in Excel, it will give you an option to format that row as text, and as a re...
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...
Summary: in excel xp, i have a list of items spanning 10 rows and 5 columns. the first column contains text, and i can sort by that column easily, however, i h...
Summary: You can write a formula (called "mySum" in my example) with Visual Basic in Excel: 1) Open the VBE by clicking Tools / Macros / Visual Basic Editor ...
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: How can I create a print button in excel so that the user by clicking it will get the whole document printed? BUT The page must not have any backgroun...
Summary: Please forgive me if this has already been answered, but I didn't find what I'm looking for. I'm trying to figure out why in excel 2007 when I record ...
![[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
