# Questions tagged [microsoft-excel-2016]

The 2016 version of Microsoft's spreadsheet application. Unlike previous versions, this Office Suite is cross-platform, working on both Windows and OSX. Because of this, when using this tag, it may be applicable to also tag your question with the Operating System you're on.

**1**

vote

**1**answer

30 views

### Find text in the textbox in Excel

I've come to realize the Excel "Find and Replace" dialog couldn't find text in the textboxes.
I think I need a macro to solve this.
How could I find text in the textboxes:
in the active sheet
in all ...

**0**

votes

**0**answers

21 views

### How to export Excel worksheet to another format without changing the original format

I do frequently export Excel worksheets to another format (for example, HTML or CSV), and always get annoyed by Excel changing the original format I was using (XLS or XLSM) to the one used for ...

**27**

votes

**7**answers

9k views

### In Excel, when I enter 22222.09482 then I see 22222.0948199999 number in the formula bar

Could you please help - as I have a weird situation that when I enter a number 22222.09482 in cell then I see a different number 22222.0948199999 in the formula bar. Below is the snapshot of the ...

**0**

votes

**1**answer

27 views

### Is there a way to access the built-in excel form via a shortcut?

Is there a way to access the built-in excel form via a shortcut? Macros/VBA and addins are disabled. Users are running either Excel 2013 or Excel 2016.
Search has yielded only custom toolbar ...

**0**

votes

**2**answers

23 views

### Sum row/cell values when multiple column conditions are fulfilled

I'm want to sum every row/cell range in a table where one of (multiple) conditions is fulfilled in one of the columns.
An example:
I want to find the sum of all cells where the two (or more) ...

**1**

vote

**0**answers

25 views

### How to switch which sheet another Excel sheet is looking at?

Excel (2016). Suppose I have some piece of Excel in AnalysisSheet that analyzes data in some other data sheet. And suppose the following:
There are actually several such data sheets. For example, ...

**0**

votes

**1**answer

14 views

### Find specific cells in column N, change value in column O

I am new to VBA coding and am trying to search for a name in column N and replace the value in column O.
I have tried to modify this code but I cant get it to replace the cell next to it.
Columns("N"...

**0**

votes

**1**answer

45 views

### If formula contains specific text/symbol/function

How can I detect if certain cells contains specific formula with specific text/symbols?
1. A formula which is =today(), or =date(), or =time()
2. A formula which starts with =(any alphabet letter)
3. ...

**0**

votes

**1**answer

13 views

### Is it possible to link 2 different cells to a ComboBox in Excel?

I have a ComboBox that's linked to a cell, R2. It outputs whatever value is entered into it in R2, but what I'd like (if even possible) would be to have the ComboBox output the value to two different ...

**0**

votes

**0**answers

8 views

### Excel formulas referencing cells within a range of data do not update when that data is sorted or filtered

After an hour of searching Google, the closest similar problem I could find to the issue I'm experiencing is the following linked post on this site. However, a viable solution for my application was ...

**1**

vote

**1**answer

55 views

### Excel 2016: 3D column chart with transparency and no gap

I'm trying to make a decent-looking chart using a 3d representation of three different datasets (3 years, 12 monthly values).
If I try with an area chart, I have peaks/valleys at the single data-...

**0**

votes

**1**answer

47 views

### How to format big numbers to show million separator in Excel?

Given the following number 11452610,20 (11452610.20), I would like to format it like that: 11.452.610,20 (11,452,610.20)
I already tried to check "Use Thousands separator" but it only shows as 11452....

**0**

votes

**0**answers

6 views

### return value (date) from most recent closest value

I am tracking daily balances from two accounts. Each row has a date in Column B. Totals for account balance is in Column O. I would like to return the corresponding date value in Column P from Column ...

**0**

votes

**0**answers

10 views

### Aligning scatter points to non-stacked bar charts for multiple series

I am trying to create a combination non-stacked bar and scatter plot, where the scatter plot is aligned to the top of the bar chart. My issue is I am comparing two data series for each identifier, in ...

**0**

votes

**1**answer

13 views

### How to lookup for NA value in Excel?

I have two sheets:
Contains form number and amount
Contains bill number and amount
I tried to reconcile which bill belongs to which form using simple lookup based on the amount, ignoring duplicate ...