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

**4**

**2**answers

### excel - activate addin through a Group Policy object

**2**

**2**answers

### Dynamic Charts In Excel

**2**

**3**answers

### Return sum of multiple vlookups

**1**

**3**answers

### Strange residue on cell with Data Validation when using Excel VBA

**0**

**1**answer

### Align two columns in excel based on 1 criteria

**7**

**3**answers

### Left trim: Remove characters after last instance of a number

**4**

**9**answers

### Excel chart formatting lost when Refresh All or individual Right Click on Data > Refresh

**8**

**2**answers

### How to create custom shortcuts in Excel 2016 for mac

**5**

**3**answers

### Stop Excel formula from changing when inserting/deleting rows

**3**

**1**answer

### Autocomplete with Excel with any data in the same column

**2**

**1**answer

### How to have Office 2013+ Applications Open to Blank (Workbook, Document, etc) automatically?

**2**

**2**answers

### Excel - pivot table does not group dates

**1**

**1**answer

### Attempting to transpose two column table in excel using first column to group values in second column

**0**

**3**answers

### Calculate the median of the 20 peers that are closest in terms of total assets

**3**

**1**answer

### Match with interval

**3**

**2**answers

### I want to count IF both condition are true Logically count by AND excel

**3**

**2**answers

### Numbers in scientific notation imported to Excel 2016 as text

**2**

**1**answer

### How to conditional format based on cell color

**2**

**1**answer

### How can I use Excel Formulas to return multiple values using nested IF statements if I need one of the returnable values to be blank?

**2**

**0**answers

### Excel rows of data suddenly disappeared after undoing deletion of unrelated rows. Version history suddenly blank. Get my data back?

**2**

**1**answer

### Auto-populate cells in Excel

**2**

**1**answer

### Transpose unique rows to columns while IF statement conditions are met but do not consolidate

**2**

**1**answer

### Change cell color when a different value is encountered

**2**

**2**answers

### Is it possible to convert MCQs on excel into Word?

**1**

**1**answer

### MS Excel - Combine tables with only some matching data

**1**

**1**answer

### How to ignore column values under a certain threshold when making a chart in Excel

**1**

**1**answer

### Improving Excel poor filtering performance [closed]

**1**

**1**answer

### How to automatically import data from csv file and append to existing Excel table

**1**

**1**answer

### Dynamic Excel Formulas For Ranges

**1**

**0**answers

### Localized shortcuts for official US, not working ones

**1**

**2**answers

### View Source code Microsoft Excel

**1**

**1**answer

### Extract Unique Substring from Range of Excel

**1**

**1**answer

### Reinstate worksheet protection upon save and close

**1**

**1**answer

### Finding the top 10/15/20 percent (excel 2016 or google sheets)

**0**

**1**answer

### Excel bar chart with gradient values (not percentages) and value lines

**0**

**2**answers

### Check if parent row has corresponding values

**0**

**0**answers

### Get data from the cell of next row in a table, if a cell is found empty

**0**

**2**answers

### Extract numbers after a specific word in a cell

**0**

**2**answers

### Excel 2016 Macros - Windows/Mac Issue

**0**

**2**answers

### Keep only one copy of the duplicated data

**0**

**2**answers

### Split text at last instance of character (retain left hand side)

**0**

**1**answer

### Excel prevent cell and its content from being deleted (no sheet protection)

**0**

**2**answers