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

0
votes
0answers
19 views

ctrl+ or ctrl- works only once in Excel 2007

I would like to use ctrl + or ctrl - several times in Excel 2007. It used to work properly but recently, after the first row the cursor returns to a cell instead of to the number of the row and pops ...
-3
votes
1answer
24 views

how to consolidate data from multiple excel rows all into one row

I have a list of IDs and corresponding variables. Since I have the same IDs listed in multiple rows in my ID column (ie ID 37 in A1, A2, A3), I want to have one row per ID in the column (ID only in A1 ...
1
vote
1answer
61 views

How to sort a spreadsheet by one column while keeping the contents of every 4 rows together?

The last column is a total of the second last column. I want them all to stay as they are but ordered by the last column. I want to sort by the last column in batches of 4 rows.
-3
votes
1answer
40 views

Deleting multiple rows selectively from Excel 2010 [closed]

I have 19,000 datapoints in each row, now my problem is how to delete 20 rows simultaneously after an interval of 10 rows?
0
votes
2answers
54 views

Sorting Data in Microsoft Excel

I have an Excel sheet that I use to keep my user's information. This is a huge file and I have multiple rows and multiple columns per username. I am trying to sort the user names alphabetically ...
-3
votes
2answers
63 views

Excel VBA Code to maniplate rows and columns

Hi can someone help with vba code in excel 2013 to do the following to a worksheet Current : sheet1 Filer ShareName IPAddress1 IPpaddres2 IPAddress2 ... ... .... ServerA ...
0
votes
1answer
430 views

Excel: Merging multiple Rows/Columns based on one repeated cell

I need to merge the information of multiple rows and columns based on a common value for an specific cell. I guess I can use a macro here, as the problem is I have to merge a lot of information, ...
0
votes
1answer
94 views

Excel Convert Row into Multiple Columns

I have a very long list of data that looks like this: User1 Item1 Item2 Item3 User2 Item1 Item2 #NUM! (This is a failed formula) User3 Item1 #NUM! #NUM! And I want to ...
1
vote
1answer
776 views

Copy multiline formatted text into a single cell in Excel

My question is similar to Copying a multiline text into a single cell in Excel, except that the text I want to copy contains rich text formatting - bold text, colored text, bullet items, etc... If I ...
0
votes
1answer
29 views

Match each row against all other rows

I have 53 rows with 25 columns nand it's all txt values. Is there a formula that will match each row against all other rows? I basicaly need a similarity matrix and am wondering if there is a shorter ...
0
votes
0answers
16 views

Copying row from one excel workbook to another based on column comparison

I am new to excel macros. I want have two workbooks, w1 and w2. w2 is a newer version of w1 and it has certain new columns as well as some column header is changed. I know which column headers are ...
1
vote
2answers
60 views

Excel: Format rows in sheet B based on value in sheet A

How do I shade an entire row on tab 2 when an "X" is placed in column "A" of the same row in tab 1?
0
votes
2answers
68 views

Select a number of rows from a set in Excel

I have a list of users in locations within my company. Vastly reduced from the 130,000 or so in reality, the data looks like the example at the end. What I need to do is to select a number of users ...
1
vote
1answer
2k 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
307 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 ...
-4
votes
1answer
83 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
383 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 ...
1
vote
2answers
541 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
2k 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
4k 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 ...
-1
votes
1answer
361 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 ...
2
votes
2answers
4k 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

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
1k 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
425 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
724 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 ...
-1
votes
1answer
140 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
337 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 ...
4
votes
1answer
304 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 ...