**0**

votes

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**2**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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 ...