A row is a horizontal line of something within a program. It can be a row of cells in excel, or a row of text in a text document. Rows are horizontally positioned and are generally read left-to-right.

learn more… | top users | synonyms

2
votes
1answer
11 views

How can I filter which colums will be shown on a spreadsheet?

I have filters set up for each column, however I also want to be able to filter which of the columns show. Eg: I have 70 different columns, all with different headings. How can I create a filter that ...
0
votes
0answers
18 views

Efficient removal of duplicate records across multiple Excel sheets

I have a workbook with 2 sheets. Sheet 1 has 3 columns (1A, 1B and 1C) and sheet 2 has 2 columns (2A and 2B). Now I need to delete rows from sheet 1 if 1A and 1B match any row in sheet 2 (i.e. 1A=2A ...
0
votes
2answers
38 views

Excel outer border around two rows

ID Date Code Price 9202188 04/11/2014 212015 29,47 212026 30,5 9202190 03/11/2014 813012 99,47 814027 60,5 I have ...
-3
votes
1answer
43 views

Different rows in to different columns(special case)

I have a excel sheet that contains hundreds of data like this.. Name 1 Name 2 Name 3 Name 4 A Aa Aaa Aaa Name 5 Name 6 Name 7 Name 8 B Bb Bbb Bbbb I need to ...
1
vote
2answers
33 views

How do I quickly insert many new rows into a table in Word (2010)

I have a table which is 9 rows. It needs to be 59 rows. I know the trick where you highlight say 3 rows then do insert and it gives you three new rows. That approach obviously does not work as well ...
0
votes
0answers
12 views

check for duplicates across rows NOT columns

I have a very large list of names that I need to compare across ROWS - not columns. Smith, John Smith, John Doe, John Doe, Jon As you can see John Doe is spelled ...
1
vote
2answers
180 views

Formula to conditionally format a cell if the cell value (text) is not in row above

I need a formula to format a cell if the value of the cell is not in the row above. I have to compare 100 rows of 10 columns sorted by date with the column above it. Column A has the date and ...
0
votes
2answers
580 views

How to merge rows with same Name merging data of each ?related column

I need to merge rows with same Name preserving data of each column. For example, if we have two rows with the name "Mr Bean" on the first column "Name" then merge data of each column related to rows ...
-1
votes
2answers
2k views

Excel 2010 Delete Rows with Locked Cells

I have a spreadsheet that has formulas that I want to lock, once the information in the row is completed, i.e. there is a discharge date, I want the end-user to be able to delete the row and insert it ...
0
votes
1answer
2k views

Excel - can't get the formula to copy correctly

Have an excel sheet. I want B3 = C3 * C2 So far everything is good. I want B4 = C4 * C2 Did these two manually. I have a lot of rows so I wanna copy the formula. The problem is, I select them ...
-1
votes
1answer
168 views

Hide rows until needed

I'm sure this has been asked before but I'm really struggling with it. I have a database that lists three companies and compares the prices of several products like this: Company ...
0
votes
3answers
3k views

Move every 7 columns into new row in Excel [duplicate]

I have a very large data set in Excel; all of the outcome scores are in a single column. I need these scores to be separated into rows so that every set of 7 scores (i.e., scores 2-8, 9-16, etc) are ...
5
votes
4answers
13k views

How to insert empty rows in Excel 2013 when I have copied rows in my clipboard?

This seems like something which should be painfully simple to do but I can't figure it out. So with an empty clipboard I can right click on a row header and say insert row, no problem, it inserts a ...
1
vote
1answer
402 views

Excel singlecolumn to multiple columns based on values

I have 1 column like below: AAA 999888 BBB 1111 BBB 2222 AAA 999777 BBB 3333 AAA 999666 BBB 4444 CCC Doit ... Consider above up to a few thousand rows. I want to convert it to below 3 column table ...
1
vote
1answer
2k views

How can I zebra-format rows in Excel 2010 automatically?

I've got a long list of data (export from MySQL) that I want to print out to tick each row after I've done stuff with it. Is there an easy way in Excel 2010 on Windows to make the table ...
1
vote
1answer
1k views

Sorting two non-adjacent columns without affecting any other column

I have two different columns on Excel. I want to create a script that will sort Column F, (Have a header) and will sort Column B based on where Column F's sort worked out. (Without affecting any ...
0
votes
1answer
1k views

Combine multiple rows into one

I am trying to combine multiple rows of data into one. Column A contains the value on which the groupings will be based -- rows whose Column A values match will be combined into one row. My range ...
0
votes
1answer
643 views

Ms excel 2007, how to Merge rows by removing duplicates

In my case i have a database of more than 30,000 How do i get the duplicates in one row and the last three criteria of puting x in one row of one person Like Manmeet abc 000 - - - x ...
0
votes
1answer
233 views

Delete rows in Excel based on returned value in row cell

I have a worksheet in Excel with values in some rows in column B that have been returned as zero (0) but still have a formula in the cell. I want to be able to delete just these rows using a macro.
0
votes
1answer
554 views

Filter rows with unique values on Microsoft Excel

I have got a set of rows in an microsoft-excel column_a column_b column_c column_d column_e r1 200 300 350 400 3 r2 200 ...
-2
votes
1answer
135 views

How do I create a range from a cell value?

For example: A B 7926 3 FROM =COUNTIF(AQ$7926:AQ7970,"=0") 7926 3 FROM =COUNTIF(AQ$7926:AQ7971,"=0") 7926 3 FROM =COUNTIF(AQ$7926:AQ7972,"=0") 7926 3 ...
2
votes
1answer
287 views

Adding custom rows to file using a shell script

I have a textfile with an arbitrary number of rows triplets like these: 4 5 2 12 16 6 Now I want to add related rows to the file. Let's say i want to add 4 additional rows per row which have ...
1
vote
2answers
44 views

MS Excel 2007 ref

How to transfer data Row to Columns?
2
votes
2answers
4k views

Excel row-wise multiplication

I would like to multiply, row-by-row, two columns in an Excel sheet (in order to take the median of the resulting column). 1 3 2 5 4 2 Should become 3 10 8 How can I do that in a formula ...
4
votes
1answer
294 views

Set a row to follow my cursor anywhere in Calc

How do I make a whole row follow wherever I am in the Calc document when I scroll down/up? I'm looking for something that keeps a row from moving, or to make it stay put. This is so that when I ...