**0**

votes

**2**answers

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

**0**

votes

**0**answers

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

**0**

votes

**0**answers

8 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

18 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

32 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

**2**answers

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

**1**

vote

**1**answer

19 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

40 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

**1**answer

47 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

**0**answers

12 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

80 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

20 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

76 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

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

**1**

vote

**0**answers

35 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

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

**1**

vote

**1**answer

56 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

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

**-1**

votes

**2**answers

282 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

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

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

**1**

vote

**1**answer

34 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

**2**answers

227 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

**0**answers

55 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

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

**3**

votes

**3**answers

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

**0**

votes

**2**answers

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

**0**

votes

**1**answer

27 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

73 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

**0**answers

45 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

**2**answers

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

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

162 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

**1**answer

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

**2**

votes

**1**answer

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

**-1**

votes

**1**answer

470 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

374 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

**1**answer

171 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

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

**0**

votes

**0**answers

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

**1**

vote

**1**answer

761 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

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

**2**

votes

**1**answer

39 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

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

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

**1**

vote

**1**answer

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

**0**

votes

**1**answer

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

**0**

votes

**1**answer

358 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

**1**answer

428 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

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