**0**

votes

**1**answer

9k 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) ...

**1**

vote

**3**answers

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

**1**

vote

**3**answers

49 views

### How to show negative time in excel?

Is it possible to show negative time in a cell?
eg: if I need to calculate work hours balance
day 1 : from 8:00 to 16:00 (8:00 hours = standard)
day 2 : from 8:00 to 19:00 (+3 hours)
day 3 : from ...

**0**

votes

**1**answer

15 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

**2**answers

30 views

### How do I create an excel formula to pick out differences in 2 cell values?

I have a column of company names (column A), a column of the 2014 revenue (column B) and a row of the 2015 revenue (column C).
I want to somehow pick out which companies had zero revenue in 2014 and ...

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

**0**

votes

**2**answers

33k views

### VBA code to hide or unhide rows based on a cell value

Heres my code, but its not really doing anything, I dont see anything wrong with it:
Private Sub PG1(ByVal Target As Range)
If .Range("E50").Value = "Passed" Then
...

**0**

votes

**0**answers

12 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

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

**1**

vote

**6**answers

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

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

**0**

votes

**2**answers

40 views

### How to delete MS Word table cell contents but not cells

I am running MS Word 2007. Is it possible to delete the contents of a table without deleting the actual cells? I've tried highlighting a bunch of cells and hitting the Backspace button but with this ...

**0**

votes

**1**answer

118 views

### How to have excel paste a value in a specific cell according to another data table

I'm working with excel 2010,
I have an excel sheet with two tables. The primary table contains a calender and each calender day has a specific numeric value in the cell below the date.
The numeric ...

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

**1**answer

152 views

### How to Mirror cells in excel 2013 [closed]

I want to make an excel file for sales management of my company. the excel I have created has 4 sheets and every sheet is handled by different persons.
I want to dedicate the first column of these ...

**0**

votes

**0**answers

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

**2**

votes

**1**answer

31 views

### Excel - Exclude Cells from Computation

Say I have 5 columns of data with 100 rows (so from A1 to E100). For each row I want to compute the averages of the 5 entries while I always exlude one of the entries. E.g. for the first row I would ...

**0**

votes

**1**answer

85 views

### minimum of non-zero non-adjacent cells in MS Excel

I know that for finding the minimum of non-zero cells in Excel, I can use
min(if(A1:A10>0,A1:10))
But what if I would like to find the minimum of non-zero & non-adjacent cells?

**1**

vote

**1**answer

2k views

### How to bulk replace links that are embed to words in Excel cells

I have a huge list of words that have links. All the URLs have text that repeats. I want to mass replace this text with another. Right now, "Replace all" only searches between words, not through the ...

**-1**

votes

**1**answer

178 views

### Referencing a cell in Excel using values from other cells in different worksheet (tab)

I'm trying to set up a Excel sheet for a running log.
What I'm trying to do is to get info from a cell that is 7 rows dowm from cell H8 on worksheet Log. This is so that I can just drag the forumla ...

**2**

votes

**1**answer

94 views

### Excel: extracting a number from mixed content cell [duplicate]

How would one extract a number starting with a "£" sign from a cell containing alphanumeric characters?
Example: extracting £450,000 from A1 and placing in B1. See image for example text
...

**0**

votes

**0**answers

59 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

26 views

### Combining address function and cell function in Excel

In MS Excel 2013, when I write
=CELL("contents",$B$1)
It is okay, but when I write
=CELL("contents",ADDRESS(1,2))
It results in error. I would like to access the contents of an address. I have ...

**1**

vote

**3**answers

15k 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?

**6**

votes

**1**answer

50k 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

**0**answers

67 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

**1**answer

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

**1**

vote

**3**answers

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

**0**

votes

**5**answers

13k views

### How do you add extra value to a cell that already has an existing number in it

I find this hard to explain, but I'm stocktaking beers, spirits, and liqueurs and I want to keep one column for my ullage count for each product. However, as I go through the days, I often come across ...

**1**

vote

**1**answer

243 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

78 views

### Use space bar to input a value in an excel cell

Could someone help me with a macro code/formula to enable space bar to input a value in a cell? For e.g., if I hit space bar when I am on a cell, I would like to print "x" in it. Is it possible?

**0**

votes

**2**answers

42k views

### How do you write an Excel formula that will paste a specific value in a different cell?

So basically I want to write a formula that will check a condition, and if that condition is met, then I want to paste a specific line of text in a different cell. I should note that I do not want the ...

**4**

votes

**4**answers

722 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?

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

**0**

votes

**0**answers

23 views

### Linking a cell to a specific part of an ActiveX textbox

Is there a way in Excel to have a cell refer to a specific part of an ActiveX textbox? I have a large list of references in one ActiveX text box, and in another sheet I need to input various ...

**0**

votes

**1**answer

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

**1**

vote

**1**answer

56 views

### How can retrieve cell address that match criteria?

In column A are various products (A2:A100), in column B are different numbers (B2:B100).
In cell G2 is criteria from column A.
With the formula {=MAX(IF($A$2:$A$100=G2;$B$2:$B$100))}, I can find ...

**3**

votes

**2**answers

103 views

### Excel 2010: Find duplicate entries in one cell

I have data imported from a literature database (.txt format) into Excel. Unfortunately, in most cases, the authors are listed double in one cell, e.g.:
"Smith, Miller, Patty, Smith, Patty, Miller"
...

**0**

votes

**1**answer

33 views

### Excel reformatted numbers to times

I have a spreadsheet stored on a company sharepoint site. Only one person in my team will use it at any time, when they're finished it saves and is available to another user. Periodically when someone ...

**1**

vote

**1**answer

219 views

### Dragging a cell reference in intervals

I have data as follows (simplified) in two worksheets on a document:
Sheet 1 data:
A1=1 -- B1=(Blank) -- C1=(Blank) -- D1=2 -- E1=(Blank) -- F1=(Blank) -- G1=3 ...
Sheet 2 data:
A1='Stage ...

**0**

votes

**1**answer

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

**1**

vote

**1**answer

233 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

461 views

### Excel 2010 VBA only affecting last row in range

I have some VBA code written in Excel 2010 to force padding around the rows in a table, but part of the code only affects the last row in the range. Here's the full code:
Private Sub ...

**1**

vote

**1**answer

293 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

**2**answers

2k 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

607 views

### Excel function for calculating total spent time

I have an excel sheet, where in some columns I have cells of the type "integer,integerM" or "integer,integerH", for instance "1,30m" or "5,2H". For all the column I would like to get an expression ...

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

680 views

### Formula to display text from multiple cells from one sheet in another

I have a list of sales reps and the names of the customers they've sold product to, on one sheet. I have tried VLOOKUP, but it will only return one set of text from the cells. I would like to know, ...

**10**

votes

**4**answers

23k 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?

**18**

votes

**4**answers

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