**0**

votes

**1**answer

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

**2**answers

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

**0**

votes

**1**answer

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

**-2**

votes

**3**answers

568 views

### Why does Excel allow me to select the same cell multiple times?

I was selecting cells in Excel, and accidentally selected a cell twice. With a cell selected twice I am no longer able to copy the selection, and I have to cancel the selection and do it again.
Why ...

**0**

votes

**1**answer

35 views

### How to add prefix or suffix to range of cells in Excel?

I have cell A in excel full of images name without the extension I want to add ".jpg" as a suffix to these ranges of cells however I need to skip non text cells by not adding anything. Any help to ...

**0**

votes

**1**answer

15 views

### How to identify 2 duplicate cells next to each other only in Excel

if someone can help me with this question please. How to identify duplicate cells next to each other not in adjacent column but adjacent row like my sample below. Thank you.
4/30/2016
5/12/2016
4/5/...

**0**

votes

**4**answers

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

**0**

votes

**1**answer

55 views

### Formula or VBA for cell formatting using value based on a cell but formatting from an other cell

I have a fixed set of values, (0%,20%,40%,60%,80% and 100%) in column E.
If I fill a cell in column E with any of the above values, the cell G should pick formatting from another cell.
For example,
...

**0**

votes

**2**answers

78 views

### What is the difference between 3 cells, 4 cells and 6 cells battery

I am going to buy new laptop but there is some confusion in battery capacity.
I found that 3 cells battery backup is good than 4 cells battery laptop but I read somewhere that more cells means that ...

**0**

votes

**1**answer

37 views

### Multiplication of cells containing words

I'm making a finance plan, where I have the columns 'Quantity', 'Cost' and 'Total'.
The quantity column will contain how many of the item I buy.
The Cost column will have the individual cost of the ...

**0**

votes

**1**answer

97 views

### click on a cell change the value of another cell

I can not achieve to do what looks like an easy process...
I would like to give a value ("Hello") to a cell (named "ClInfo") in sheet named "Hardware" by a click on a cell (C47) in sheet named "1".
I ...

**0**

votes

**1**answer

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

**1**

vote

**1**answer

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

**0**

votes

**2**answers

57 views

### Excel counting “A”'s with cell values of “A,B” “R,A” etc

Trying to count the number of individual variable in Excel but Countif doesn't seem to fit my needs
For example individual cells have "A","A,B", "A,J", etc and I want to count the number of "A"s - is ...

**13**

votes

**6**answers

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

**1**

vote

**7**answers

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

**0**

votes

**2**answers

39 views

### How to use a button to clear multiple cells in excel? [closed]

How can I clear many cells at once.
If I want to clear A1, A10, B10, B20 by just using one button or link.
Only clearing those 4 specific cells in my example.
I want to have a button that will ...

**1**

vote

**1**answer

875 views

### Call on a cell in Excel up to the first semi-colon

I am using the =CONCATENATE function, and one of the cells I'm calling on I only want to take the value in the cell up to the first semi-colon. Is this possible, and if so how?

**0**

votes

**3**answers

394 views

### Excel - Referring to a certain cell based off of data in another

I have a spreadsheet where there is one table with the headings:
Coordinate, Lat, Long
Another with headings
Triangle, Coordinate 1, Coordinate 2, Coordinate 3, Area
What this is for, is taking ...

**0**

votes

**0**answers

16 views

### Conditional formatting based om specific text

I have a Excel calendar and trying to get Excel automatically set left border in columns on every monday to indicate new week. I have managed to use conditional formatting on the cells with M (H3:NI3),...

**0**

votes

**1**answer

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

**0**

votes

**0**answers

24 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

21 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: " &...

**1**

vote

**3**answers

76k 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
Rows("51").EntireRow....

**1**

vote

**1**answer

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

**0**

votes

**1**answer

104 views

### excel: how to place rows at the bottom of list in sort and filter options?

Here is what I have at the moment:
Click on home ribbon button
click sort & filter drop down box
I have a sort option as follows:
As you can see the rows have been commanded to go to the top ...

**0**

votes

**1**answer

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

**21**

votes

**5**answers

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

**9**

votes

**1**answer

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

18 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

134 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

**1**answer

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

**1**

vote

**0**answers

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

**0**

votes

**0**answers

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

**3**

votes

**3**answers

3k views

### Excel - Lock cells based on color?

I have this excel sheet where i want to protect some cells from formating and editing. All these cells are colored with a specific color.
The sheet is very big and therefor i am looking for a way to ...

**1**

vote

**0**answers

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

**0**

votes

**1**answer

96 views

### Count based on multiple alternate conditions in Excel

I need a formula to count any trailers that are due in but do not have a cell that says "yard" or have a date next to that trailer. Please see screenshot. I tried the COUNTIFS formula and was ...

**2**

votes

**3**answers

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

**1**

vote

**1**answer

59 views

### Formatting date from decimal in Excel [closed]

How do I format a decimal value like 1.30 as "1 year & 3 months" in Excel?
The value needs to remain the same but just needs to be displayed as 1 year & 3 months.
I need to do this just ...

**0**

votes

**1**answer

76 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

**6**answers

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

**0**

votes

**1**answer

19 views

### Excel changes typed formula

Why does excel change cell entrys
Example:
Initial entry +20+20
Next time I click on cell the contents of cell now is 40
It is not consistent on all cells

**0**

votes

**1**answer

38 views

### Excel 2010 Array (CSE) Formula: How to remove a part of contiguous (adjacent) range

I would really appreciate help on the following question:
Is there a way to write a formula that removes a segment from a contiguous range?
For example, say there is a formula =COUNTIF((A1:A100),">1"...

**1**

vote

**2**answers

286 views

### Excel 2010 Array Formula (CSE) Dynamic cell range/reference; index? offset?

This might be an easy question to some but I am completely lost so I would really appreciate any help out there!
A
1 10
2 20
3 30
4 40
5 50
6 60
7 70
...

**1**

vote

**1**answer

39 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

**0**answers

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

**1**

vote

**1**answer

3k views

### How to copy and paste a cell in a table in Word without losing the formatting?

I have a table in a document, in WordÂ 2010.
How can I copy and paste a cell? The whole cell, not its content.
I copy a cell, it has a grey background with hatching ("shading"). Then I paste it over ...

**0**

votes

**2**answers

133 views

### In excel, I want the word “Name” to display but not print

I have a census sheet in excel that has to list peoples name in a specified area. There are a set number of rooms that can contain people, but they are not all full at all times. I would like to have ...

**1**

vote

**3**answers

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

**1**answer

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