Summary: Hi everyone! How to fix the selected columns (or rows) so that they don't move when scrolling the others? I've seen Excel files where e.g. columns A,B...
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: Hi all - first time poster here - been having at a multiple If AND statement in Excel that I just can't get right. There are four variables and I'm t...
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, When you ask "What version of Excel" I presume you mean more than just the "Excel 2003" that I mentioned already? When I do "Help->About" I get "M...
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: 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: Hello, I have column of numbers. I would like to replace each number according to its value. So for example my column of numbers is: 2,4,7,12,90,23,12...
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: Hi, I have got two columns in excel table. Both columns contain names of companies in Croatia. My task is to compare those columns to see if there are...
Summary: When entering an AlphaNumeric in COL A, I would like to check contents of all previous cells in COL A for IDENTICAL entry, and warn or prevent continu...
Summary: Question, I have a user that uses Excel XP and she has a really strage situation. For some reason the spreadsheet she created has made it self have o...
Summary: I have a complicated Excel sheet with some hidden columns and rows. Is there a way to delete these hidden columns and rows automatically. I mean with ...
Summary: I am using Excel to display a log for users to sign in/out, in order to track usage of a program. Currently, as the spreadsheet fills up, the user mu...
Summary: You're working too hard! ;-) Putting the 1 in column A of the target row is fairly easy. You don't need to determine what cell was selected. You coul...
Summary: Use the Excel Help File: Enter data in a cell from a list you specify You can create a dropdown list that gets its choices from cells elsewhere on t...
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: Hi, The simple answer is to use conditional formatting. Conditional formatting allows the cell pattern colour, font and font colour, and borders to b...
Summary: "I have checked the formula's that are being copied and these are all correct?" Do you mean to say that the formula in row 3 shows as '=0&A3' or as '=...
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 ...