**0**

votes

**1**answer

127 views

### I need to know how to swap the contents of two adjacent cells in Excel based on the content of a third cell

I am trying to swap the content between two cells in Excel based on the content of a third cell. So, I have a column in Excel - say Column C. I want to swap the values of the corresponding cells in ...

**1**

vote

**1**answer

261 views

### Make Excel Row Height Stay when Sorted

I have an Excel 2007 spreadsheet and need to make some rows bigger than others so there is vertical space for a signature.
These cells are colored differently, but the height doesn't stick with the ...

**0**

votes

**1**answer

639 views

### Adding Subsequent Cell Values For Each Row in Excel

I'm new to excel so this might be a simple question. I have around 100 rows with 7 columns. Out of those, 4 column needs to have the value computed by 3rd and 2nd columns' value of the same row.
I ...

**0**

votes

**1**answer

107 views

### Can I get the properties of the color of a Microsoft Excel cell in numbers/text?

I want to count the yellow, red and white (no color) cells in a column (range) within a Microsoft Excell sheet.
The colors are equal (i.e. only one RGB value of yellow is used, not light/dark yellow ...

**0**

votes

**1**answer

487 views

### cell array of strings to matlab structure

I need to create a matlab structure as such ds=struct('name',{{'my_name_is'},{'matlab_thining_hair'}}) which stores as a 1x2 structure array with a field name. A call to ds.name generates the output:
...

**0**

votes

**2**answers

400 views

### I need to arrange my data cells in excel in a way that rows are rearranged as shown

1 2 3 4 5 6 7 8 9 10
(this is my initial data)
my output
1 2 3 4 5
6 7 8 9 10
is there anyway i can do this? i have around 400 rows of similar data
many thanks

**2**

votes

**1**answer

3k views

### How to check if cell contains a value of another cell

Here is the scenario:
On column A each cell has random text within it (names, address, account numbers, etc). Column A extends down to over 40 thousand rows.
On column B I have a list of (account) ...

**5**

votes

**1**answer

44k views

### Make some cells in an Excel sheet password protected?

I have an Excel 2010 file that I do not want to have a password for, but I do want to lock certain cells so that I do not accidentally edit them.
Can certain cells be made read-only without a ...

**0**

votes

**1**answer

75 views

### Excel Formula For Re-arranging Numbers

I have got a bit stuck with trying to make a formula in Excel, and last time I asked a question here I got great help, I have come back again. At the moment I have column A with sets of product id's. ...

**0**

votes

**1**answer

39 views

### Printing data in Excel ver 14.0 in a maxed cell

I have set the cell to the maximum size (column width of 255 and row height of 409.5). In order to view all of the data in the cell, I have to use up/down arrows. I don't need to necessarily view all ...

**0**

votes

**1**answer

742 views

### Excel - Mirror Specific Cell Range

Is it possible to mirror or replicate a cell range from one worksheet to another?
For example:
----------------------------------------------
| CELL01 | CELL02 | CELL03 | CELL04 | CELL05 |
...

**1**

vote

**5**answers

16k views

### Microsoft Excel 2007 - Cannot Fit All Text Into Cell

Is it possible to fit a large amount of text within a cell in Excel 2007?
I have 1,890 words - consisting of 10,110 characters (without spaces) - that I need to put into a single cell in Excel. I ...

**1**

vote

**3**answers

13k views

### Add drop down list / combo box into excel cell

How would I add a drop down list (or combo box) into a cell on Excel 2010?

**3**

votes

**2**answers

101 views

### Can I insert rows next to a locked column in Excel?

If I lock cells A1:A3000, is there a way to insert rows in columns B-Z?
I highlight them and I don't get the option to insert even though it is selected in the lock options. (Bottom line is that I ...

**1**

vote

**1**answer

250 views

### Delete cell content in Libre (Open) Office based on the cell value

I have a huge csv file (tens of thousands of rows) that I need to filter based on different criteria. After trying to find a proper CSV editor, I decided to use LibreOffice Calc. CSVed is great, but ...

**1**

vote

**3**answers

1k views

### Create a hyperlink from URL and title in Excel

I'm trying to construct a hyperlink from a URL and a name in different cells.
a1 = http://www.example.com/
b1 = example
c1 = <a href="http://www.example.com/">example</a>
What I want ...

**1**

vote

**2**answers

158 views

### How to keep Excel from using absolute addresses when clicking a cell while in a “range selection” window?

In any version of Excel (since 2000, at least), you can enter = into a cell to indicate that a formula is about to be entered and then click cell A1 so that the formula says =A1. This is a relative ...

**0**

votes

**1**answer

3k views

### Excel - Displaying a value in a cell dependent on another cell having text

I have an excel file with 2 sheets. The first sheet is a user input sheet with cells that are properly formatted for us. The second sheet pulls the raw data into table format so that we can inport ...

**1**

vote

**3**answers

6k views

### Remove data from a cell in Excel

I want to remove data from multiple cells in a spreadsheet using Excel 2010, so I only have the email address left.
They are in the current format:
M: 04545 545 545 e: test@email.com h: 01187 475 ...

**0**

votes

**3**answers

5k views

### Sum only if any one of six cells have a value

I would like a cell (total) to sum 6 other cells only if one of those 6 cells have a value. If none of the six have a value i do not want anything to appear.

**17**

votes

**4**answers

8k views

### How to remove a plain text protecting single quote from all the selected cells in LibreOffice Calc?

I've imported a CSV file having the first column to be date-time values in ISO 8601 format like
2012-01-01T00:00:00.000Z
for the first moment of the year 2012.
Then, willing to make ...

**0**

votes

**1**answer

485 views

### excel time difference if a cell is not formatted as time

I just can't solve this!
Excel 2010, I have a timesheet where I write day by day the entry time, exit time, lunch time.
A cell computes the worked hours, say:
A B C D
entry ...

**2**

votes

**2**answers

4k views

### Make Excel cell save formula results and not the actual formula?

I have C1 that needs to combine C2 and C3. The problem with this is that is that if I'm importing with SQL it doesn't combine C2 and C3, but instead imports nothing or the actual formula. Is there a ...

**1**

vote

**3**answers

787 views

### Methods to clear a cell in Excel 2010

I'm taking a certification course for Microsoft Excel 2010. I'm taking a class that goes over it and we all just got hit with this question:
61. In Excel 2010, which of the following can you use ...

**4**

votes

**4**answers

714 views

### Can I recharge a cell phone battery using USB?

Is it possible to recharge a cell phone's battery even if USB is disabled or blocked on the system?

**3**

votes

**1**answer

104 views

### Excel find cells by formatting?

The countif function has a criteria argument ā how do I specify a criteria based on the formatting of cells?
I have a list of math homework questions containing per-page the questions numbers (e.g. ...

**8**

votes

**4**answers

20k views

### Excel: How do I reference an entire row except for a couple of cells?

I want to be able to sum together the values of an entire row except for the first 2 cells. So something like this:
=sum(A3:A*infinity*)
How do I do this?

**0**

votes

**3**answers

525 views

### Select the value of a cell above an empty cell

How would I select a cell that is above an empty cell? I have a feeling it is going to be something super simple, but I haven't done any excel since 2004.
Here is a simple single column sheet.
data1
...

**4**

votes

**1**answer

3k views

### OpenOfficeOrg Calc: enter data into all selected cells?

I want to enter the same data (e.g. "superuser") into multiple cells in OpenOffice.Org Calc (version 3.3.0). In order to do so, I select all the cells I want the data to be entered in. However, only ...

**0**

votes

**1**answer

228 views

### Excel: while merging column contents using ampersand I “lose” zeros

I need to merge different columns like:
AB 0054 00000137
I do it this way
=A1&B1&C1
It works but my Zeroes get lost.
The text in my columns has been formatted in "personal" with zeroes ...

**1**

vote

**1**answer

3k views

### Convert from seconds to minutes in Open Office

I have several cells with a time value in seconds e.g (23, 102, 543, ...)
I am not very familiar with the formula functions in Open Office. How do I address the same Cell-Box with the value in it? I ...

**1**

vote

**2**answers

767 views

### A way to call someone from PC via a cellphone

Is there a way to use a cell phone as a modem and then use a phone software like Classic PhoneTools to call another (cell) phone?

**0**

votes

**3**answers

802 views

### PC outgoing sound to a cellphone input

Instead of putting a cell phone near a PC speaker :
Is there a way to stream outgoing sound from PC (the so called Stereo Mix in Windows)
to a cell phone input (an iPhone for example) and then to a ...

**1**

vote

**4**answers

7k views

### Comma separated values (literally, not csv) in the same cell in excel, put in individual cells

I have a column of cells in excel which contain mails, some only contain one mail as they should but others, have more than one email per cell in this format:
one@example.com, two@example.com, ...

**5**

votes

**3**answers

9k views

### Excel: Custom number formatting

I don't know much about the rules on custom number formatting in Excel, and I need to learn more. When I open the related window (Format Cells > Numbers > Custom), there are some predefined ...

**4**

votes

**1**answer

1k views

### Why do cell phones disturb my speaker?

Sometimes when I receive a incoming call on my cell-phone which is kept very near to my speakers , it disturbs the speaker sound . why does this happen , isn't it safe to keep mobiles near my speakers ...

**1**

vote

**1**answer

918 views

### Copy & paste a cell along with its name in Excel

Is there a way to copy a cell that also has a "name", and paste it somewhere else so that the new cell also has the same "name"?

**2**

votes

**1**answer

10k views

### Using Excel, How do I Make a Column of Cells Equal One Other Cell?

I have a column of cells, all of which I want to equal the value in another cell. I highlight the cell and type = and then do that again below, and then I highlight the cells and drag down but the ...

**1**

vote

**3**answers

834 views

### How can I detect if a range of cells contains only identical values or not in Excel?

I have a range of cells and I want a formula that says if all these contains the same values or not.
Usually for two cells I would use if but I want a solution that would work for ranges. I don't ...