**0**

votes

**3**answers

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

**0**

votes

**2**answers

3k views

### How to format excel cells that show duration in years and months?

I can't figure out how to do custom formating that would format input "1/5" as "1 year, 5 months", or "5,0" as "5 years". I do want the cell to retain original input of "1/5" but visually display "1 ...

**0**

votes

**2**answers

88 views

### Changing the format of cells

I have an Excel worksheet where one of the cells has the string "\xab\xcd\xef" etc. It seems as if Excel is taking this as the ASCII string "\xab\xcd\xef". How do I make Excel treat it as a binary ...

**0**

votes

**2**answers

601 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

38 views

### Shortcut to move to next new content (Excel)

I'd like to know if there is a shortcut to move to and select the last cell in a row or coumn with the same content as the current cell. I.e. ctrl + arrow moves to the edge of the data array, but I'd ...

**1**

vote

**1**answer

13 views

### Word: Make cells independent

I'm trying to make those cells (Title5 & Title6) separate from each other so I can resize one of them without moving second one, but I fail, whatever I do and apply to those cells.
This is what ...

**1**

vote

**1**answer

31 views

### How do I create a summary of the same few cells on many different sheets in Excel 2013?

I have an Excel workbook with 140 sheets. I'm trying to summarize the same 3 cells in each sheet on a summary sheet. How do I grab the value of the respective cells on each sheet without manually ...

**1**

vote

**1**answer

619 views

### Align header with cells whose text is oriented at an angle

Is there a smart way to align horizontal-text "header" cells with other cells below whose text is oriented at an angle?
This is what I tried. Obviously this looks awful. The "Benefits" and "Caution" ...

**1**

vote

**1**answer

401 views

### How can I protect and hide the data in a single excel cell using password?

My professor want me to send out an excel sheet which contains grades of all students.
And of course every student can only see his own grade. So he want me to set passwords for the grade cells. Each ...

**1**

vote

**1**answer

38 views

### MS Excel: custom money format

Need to represent decimal number as "## hrn. ## kop.".
Example:
1.2 => 1 hrn. 20 kop.
3 => 3 hrn. 00 kop.
I've created custom cell format:
0," hrn. "#0" kop."
Result is:
1.2 => 1, hrn. ...

**1**

vote

**1**answer

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

**1**

vote

**1**answer

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

**0**

votes

**1**answer

18 views

### Show a duplicate value on seperate excel spreadsheet

I have an two excel spreadsheets. One of the sheets is a summation of what is on the other sheet. I need to have a cell on the summation sheet that will tell me if i have a duplicate (more than 3 ...

**0**

votes

**1**answer

48 views

### How does the user make a selection in MSExcel that contains only those cells that contain data?

Got an MSExcel question for you.
he specs for my computer are: Intel Inspiron laptop i3-2.20ghz , 8GB DDR3, 400GB HDD, Win 7 Prem.
And the version I am using is MSExcel 2003.
My question has to do ...

**0**

votes

**1**answer

23 views

### different colors in cells as value increases

The conditional formatting that I am using right now is .. if cell equals 1 then this color .. if cell equals 2 then this color and so on.
Is there a way I can format it for more than just the 3 ...

**0**

votes

**1**answer

137 views

### Matlab extract numbers from cell with mixed contents

I have a cell array with different datatypes, from an excel sheet that I need to read in, but which is beyond my control.
[~, ~, raw] = xlsread(xlsFile)
raw is now a r-by-c cell vector, for ...

**0**

votes

**1**answer

2k views

### Conditional Formatting for one cell value in a list, another cell blank

Looking for how to do Conditional Formatting for the following rule:
If a number in a cell equals one of a list of particular numbers, then information MUST be entered into an additional cell. ...

**0**

votes

**1**answer

334 views

### How can I have only inner cell spacing? (Remove outer cell spacing)

I have a table in Word 2013 with 0.45cm cell spacing applied to the table:
For the purposes of this question, I've turned on some extra borders:
How can I remove the "outer" spacing, and just ...

**0**

votes

**1**answer

66 views

### Method to Consolidate Cell Contents from Two Excel Files into One Excel File

I translated an Excel file in Chinese into English with OmegaT, a CAT (Computer-Aided Translation) tool, and a pure English file was generate by OmegaT.
However, the customer wants me to submit an ...

**0**

votes

**1**answer

14k views

### Excel vba code for adding a value to existing cell of sheet

i have this code to add value of a cell to existing value of other cell which is below
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Not (Intersect(Target, Range("E3")) Is Nothing) ...

**0**

votes

**1**answer

2k views

### Updating another Excel spreadsheet from current spreadsheet

I used the VBA code in "How do you write an Excel formula that will paste a specific value in a different cell?" posted here in May 2013 and it works well to populate/fill another cell in the same ...

**0**

votes

**1**answer

46 views

### I've deleted some cells and cleared everything out and it keeps reverting back to DATE format

I've never changed formatting to date: I always keep it in General unless I need to make it different.
Since my last Update, everything now changes to date when I either copy, paste, or when I ...

**0**

votes

**1**answer

685 views

### Excel - compare names in two cells in different order

I need to compare the following
Cell 1 John Peter henderson
Cell 2 peter John Henderson
Result Match
Cell 1 Anne jolie ...

**0**

votes

**1**answer

59 views

### Formating my Excel Cell Formulas

What formula can I format my cells to so that when I input a number it will have a u after it (I have it set to ###,###u now) and if it is blank it will have "N/A" in the cell? Thank you in advance.

**0**

votes

**1**answer

950 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

82 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

43 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

904 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

**0**answers

31 views

### Cell with 2 options and I want to add a third

So I have this excel file where when i select a particular cell a little box with an upside down triangle appears to the right of the cell. When I click on this there is a small list of options to ...

**1**

vote

**0**answers

53 views

### If Data Allready Exists In A Cell Overwrite It With New Data

I have an excel sheet with IDs beside cases. When I work the case and get a reply I want the excel spreadsheet to work out its the same case and update the original without adding a new case onto the ...

**1**

vote

**0**answers

29 views

### Trying to combine 3 of 4 cells in a square in a table in word

I am trying to merge specific cells in a table. The table is setup like this:
1 2
3 4
I am trying to merge cells 3, 4, and 2. However, it will not allow me to do that. If I wanted to combine ...

**1**

vote

**0**answers

45 views

### How to copy and paste between cells without overwriting what would be in between in excel?

The wording is a bit complicated, but essentially the problem I am having is I have something like:
A| blank cell |C
B| blank cell |D
and I want it to be A|B|C|D all in one row.
Doing it manually ...

**0**

votes

**0**answers

5 views

### Fade all the un-selected cells in excel 2013

I have a long table in Excel 2013 and it is very hard to read and focus on a specific cell. I want to know if there is any way to automatically fade all the un-selected cells?
By fade, I mean when I ...

**0**

votes

**0**answers

15 views

### Excel: Reference a number in a concatenated string

Below is my formula in cells B7, B9, and B11 for three separate ranges of numbers: B7 = C6:N6, B9 = C8:N8, ... .
B7 = "Average: " & round(average(filter(C6:N6,C6:N6>40)),2) &" Total: " ...

**0**

votes

**0**answers

24 views

### Is there a way to enter negative time into cell in Excel?

I am trying to enter a negative time value into a cell and receive the error "The formula you typed contains an error." I have tried changing to the 1904 date system but receive the same error. The ...

**0**

votes

**0**answers

11 views

### Failing to use a split cell range as data source for a pivottable

I want to create a pivot table from this table I have, but I want to leave out some of the rows. So, suppose I want to keep the header row, leave out the next ten rows, and use the next 10 rows. This ...

**0**

votes

**0**answers

56 views

### How can I select two data points on line graph and return its corresponding values?

I have a simple line chart and I want to select any two data points of line and wants in return its corresponding value.
For example, my 11 different points are below. Simple line graph can be drawn ...

**0**

votes

**0**answers

11 views

### adjust target cell in formula — target cell will change location when rows are sorted

I have a sum in cell B10. in C1 I want to show the value of B10, but rows 5-10 change each time the worksheet is used as a result of sorting. Is there any way to link the formula in C1 to a specific ...

**0**

votes

**0**answers

41 views

### Capture user ID of last updated cell in Sharepoint

I want to track who is changing what values in a spreadsheet I have uploaded to Sharepoint. Is it possible to capture the id of a user who last updated a particular cell?

**0**

votes

**0**answers

8 views

### Automatic transmission the remaining contents of one cell to Specific cell on the next page in microsoft word

How can I automatically transfer remaining contents of a cell to a specific cell on the next page in microsoft word?
For an example please look at the picture :

**0**

votes

**0**answers

148 views

### LibreOffice calc; is it possible to automatically make cells coloured according to the HTML code entered into them?

I am creating a LibreOffice calc spreadsheet designed to be basically be a customized version of the table entitled "Default element colors, by atomic number:" on this page ...

**0**

votes

**0**answers

132 views

### Label distribution and scaling in Numbers

I'm currently working in OS X Numbers on a document with two columns and 1078 rows.
Using this data, I have constructed a simple 2D line graph which I am fairly happy with.
The issue that I'm having ...

**0**

votes

**0**answers

193 views

### Change Excel cell value on each saved revision

Is there a way of increasing cell values on each file save? I have a version number on a macro-enabled spreadsheet, and I want it to increase by say 0.1 each time I save the file. I would rather not ...