# Questions tagged [microsoft-excel]

A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function.

**1**

vote

**0**answers

13 views

### In Excel, how can I center a column, align decimal points, and not show decimal places with zeros to the right?

In Excel, how can I center a column, align decimal points, and not show unnecessary decimal places or decimal point?
Example:
| 0.12 |
| 122 |
| -12.2835 |

**0**

votes

**1**answer

12 views

### How can I center a column in Excel, have the decimal points aligned, and show only the necessary decimal places for each number, but at least one?

How can I center a column in Excel, have the decimal points aligned, and show only the necessary decimal places (i.e. not use unnecessary zeros to the right of the decimal point) for each number, but ...

**0**

votes

**0**answers

5 views

### Excel: Problems with the calculated field option in pivot tables

I would like to use the calculated fields option for pivot. But it doesn'calculate the columns, I would need.
In the first screenshot you can see the pivot table
Summe = Sum => It sums up the values, ...

**0**

votes

**0**answers

14 views

### How do I match a specific word in a cell with that word in an array?

The first column is for the ITEM TITLES of random items and the third and fourth columns are for the CATEGORY ID and CATEGORY NAMES, respectively, that the item could fit into. The second column, ITEM ...

**0**

votes

**0**answers

15 views

### Flip the legend horizontally in Microsoft excel chart

I am using Microsoft excel with Arabic language, I would like to flip the legend horizontally, the color on the left and label on the right (figure).

**0**

votes

**2**answers

35 views

### Comparing two columns, if similar return values from third column to another column

In excel I have 2 different sheets, sheet 1 and sheet 2. If in sheet 1 column A and B matches sheet 2 column A and B, I would like to copy the value for column C and D in Sheet 2 back to column C and ...

**0**

votes

**1**answer

23 views

### Adding an item to a drop down list for data validation when the initial list is a named range

I have a table that contains the list of values that I want to use in my named range - A, B, and C.
Fairly simple to have them be the named range - =Indirect("Table1[Column1]")
However, I would like ...

**0**

votes

**1**answer

15 views

### Excel: check multiple cells for specified values, name the ones that do not match

Ok, so I've tried writing my own formula to make this doable but am drawing a blank.
I want to check multiple columns in a row to see if they contain a specifief value, let's say "V". Then in the ...

**0**

votes

**1**answer

34 views

### Excel: Conditional formatting if cell is not equal to one of multiple values

Using Excel, I would like to conditionally highlight a cell, if the value of the cell itself is not one of several values.
The cell should be contain of the following percentages – 0%, 6%, 12% - or ...

**0**

votes

**1**answer

22 views

### Not using a cell as variable, whilst inserting a (excel-)formula in several cells

I'm facing a small, basic little problem, for which I can't find the solution:
I'd like to insert the same formula in several cells at once. Quickly googling this problem provides a solution:
Either ...

**0**

votes

**1**answer

25 views

### Excel: How to generate dynamic tables, based on values of another table

In Excel, I would like to generate a dynamic table, based on the values in some other cell.
I have never done this before, so I don't know the terminology or the techniques involved. I'm also not ...

**0**

votes

**0**answers

20 views

### Pivot Table, Subtotal Date Formatting, Format Cells does not work

In pivot table A I have the date like so 10/10/2018 when I subtotal it goes to, 10/10/2018 Total which is what I want.
The "format cells" in these subtotal cells are _(* #,##0.00_);_(* (#,##0.00);_(*...

**0**

votes

**2**answers

23 views

### Looking for formula to update dates in other cells when I update a cell

I want to change just Mondays date and have the rest of the cells change sequentially.

**2**

votes

**1**answer

26 views

### Excel Data, Why does formula change dd/mm/yyyy to #####

I have the date 10/10/2018 in cell A2. In B2 I have =A2&" Total" which comes as 43383 Total. But for my vlookup I need it in 10/10/2018 format.
How can I format this to stay at dd/mm/yyyy?
I ...

**1**

vote

**0**answers

12 views

### Excel filter vanishes after change in sheet

I have a excel-file with multiple sheets.
Sheet1 (Lagerliste) holds a bunch of logistics-data. Mainly: WHAT is WHERE
In a seperate sheet I want to filter all lines containing a certain value (...