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

**2**

**1**answer

### Excel: MATCH() formulas with no wildcard matching

**1**

**1**answer

### Comparing 3 columns to 3 other columns for a match?

**0**

**2**answers

### Change the specific text become a number in excel

**0**

**1**answer

### Excel For Mac 2016 Scatter Plot Multiple Series in Rows

**0**

**1**answer

### How do I disable Excel touch scroll bounce at top of sheet?

**0**

**0**answers

### One Specific Row on an Excel Worksheet Not Being Sorted Correctly

**-1**

**1**answer

### Excel 2016 formating

**0**

**1**answer

### Excel - How can I probe all the precedents of a given cell?

**3**

**3**answers

### Add only working days in grid style using Microsoft Excel

**0**

**1**answer

### How to Nest VLOOKUP properly in Nested IF statements

**0**

**0**answers

### Why are the totals of my Pivot Table wrong?

**0**

**3**answers

### Excel: how can I find a cell being referenced?

**0**

**0**answers

### Saving an Excel 2016 document without changing its content changes its hash

**0**

**1**answer

### Conditional remove duplicate in excel

**0**

**2**answers

### Excel 2016 time formatting cells

**0**

**1**answer

### Excel - Is it possible to make a drag and drop function to save files directly into a folder?

**0**

**0**answers

### Comparing multiple columns in excel 2016 for exact matches and returning a list.

**0**

**0**answers

### Excel Sorting dilema

**0**

**1**answer

### Aggregate spreadsheet data based on date-time ranges

**1**

**1**answer

### How to make MS Excel cells display dark background with white text instead of the reverse which is default?

**0**

**0**answers

### Microsoft Excel365: Equation value is turning zero while editing any cell

**1**

**1**answer

### How to disable/enable office clipboard

**0**

**1**answer

### Excel language change from local to english - win7

**1**

**2**answers

### Filtering Excel Data by Column Value and Saving Columns to Individual Files

**1**

**1**answer

### Why does a downloaded spreadsheet not automatically calculate?

**1**

**0**answers

### How to plot timeline chart with start and end date columns

**0**

**1**answer

### Counting t-shirt sizes in a column but also separated by commas

**2**

**2**answers

### Convert a text string with a leading dash to a negative number

**0**

**1**answer

### How do I use keyboard shortcuts to enter a value into a cell that has a list data validation entry?

**0**

**0**answers

### Primary and Secondary axis in Excel 2016

**1**

**1**answer

### Assign Nested Sequential unique numbers for items in Excel Table

**0**

**1**answer

### Copy a hyperlink from one sheet to multiple other sheets

**0**

**1**answer

### How do I use Ctrl + End to go to the last formatted cell?

**0**

**1**answer

### Simple Excel bar Graph [closed]

**1**

**1**answer

### Background color of text, including overflow

**1**

**2**answers

### How do I select a cell range using the keyboard while editing a formula?

**0**

**1**answer

### How can I use “Format as table” option in Excel 2016 without losing my data format?

**0**

**0**answers

### How to convert plain text into hyperlink in Excel?

**1**

**1**answer

### How to fix the location of a comment with pane freeze?

**3**

**2**answers

### MS Excel: How to use format painter with just the keyboard?

**0**

**2**answers

### Match a column header (of nonspecific location) against column contents, and get all row headers

**0**

**0**answers

### Is it possible to distribute between start and end date a quantity with Pivot Tables?

**-1**

**1**answer

### Turn off Excel Compatibility Mode

**0**

**1**answer

### How can I modify the “Applies To” property of a Cell's Conditional Formatting rule using VBA?

**0**

**1**answer

### How to perform the same operation on multiple excel files

**1**

**1**answer

### How do you round a time and date back to a previous day with a formula in excel?

**0**

**0**answers

### Update Values to an Existing Sheet from every new Sheet created by Macro

**1**

**0**answers

### Excel highlighting selected cell

**0**

**0**answers

### On Excel right click on Sheet tabs is disabled

**0**

**1**answer