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

**0**

**0**answers

### How to find last digit IF next column has a condition?

**1**

**2**answers

### Extract the latest data in an Excel worksheet

**1**

**1**answer

### Alternative for a filter formula

**0**

**2**answers

### PivotTable Change Data Source broken in latest version (1706)?

**0**

**2**answers

### How to bulk convert numbers to text in Excel without formulas?

**0**

**1**answer

### VBA - How to Delete Hidden Rows Efficiently [closed]

**1**

**1**answer

### Excel 2016 New Window grayed out

**2**

**2**answers

### Not able to sort columns

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

**0**

**1**answer

### VBA - Setting Side Borders in Varying Columns and Rows

**0**

**3**answers

### Find all missing dates between two dates in excel 2016

**1**

**1**answer

### Calculate average ignoring blank cells which also contain formula

**1**

**2**answers

### VBA Excel - Checking Text Similarity in Same Column

**0**

**1**answer

### Excel CTRL-V not working properly

**0**

**3**answers

### Excel “Can't find Project or Libary” - but which one?

**1**

**1**answer

### Getting the error: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

**0**

**2**answers

### Excel - Combining multiple cells in a single row

**0**

**1**answer

### Excel - automatically updating cell reference when applying conditional formatting to range

**0**

**1**answer

### Excel file opens file on second double click only

**2**

**3**answers

### Find text in the textbox in Excel

**0**

**1**answer

### Show data label on error bars

**3**

**1**answer

### How to disable “marching ants” from overriding my external clipboard data in Excel 2016?

**2**

**1**answer

### Excel graph not showing some x value labels

**-1**

**1**answer

### Unable to see the cells in the Excel workbook

**1**

**0**answers

### Issue with mail merge rejecting high-content rows

**0**

**1**answer

### How do I separate these rows from the second column?

**0**

**2**answers

### Excel - Conditional format cells based on a column and duplicate and another column's value

**1**

**2**answers

### Excel - Automatically changing to all-bold or no-bold on save

**0**

**1**answer

### Excel: insert rows in multiple tables (not plain cellsheets) simultaneously, sans macro

**3**

**2**answers

### Missing Paste (P) option in Excel 2016

**2**

**1**answer

### Excel: Find the earliest/latest values for each date in a list of dates & times

**1**

**1**answer

### LARGE function throws error

**0**

**1**answer

### How to change Data Source in Power Query for Pivot Data? (Browse Button missing)

**1**

**1**answer

### Save Excel Sheet as CSV in UTF-8 Using VBA

**0**

**1**answer

### How to create “workaround” MAXIFS and MINIFS formulas in Excel?

**3**

**2**answers

### Excel 2016 Freezing when entering data into a spreadsheet with multiple formulas

**0**

**0**answers

### Excel error: “No more new fonts may be applied”

**2**

**2**answers

### Excel - pivot table does not group dates

**0**

**0**answers

### Show window contents while dragging is not working in MS Excel

**0**

**2**answers

### How to highlight trends in time records? (system errors)

**0**

**0**answers

### VBA Screen Update in Excel 2016 freezes Excel

**0**

**1**answer

### Convert table image to excel using excel

**0**

**0**answers

### ios- excel formulas from 2019 to 2016 [duplicate]

**0**

**2**answers

### Is there a way to copy all empty cells in a data set on one sheet and paste the empty cells into a data set on a different sheet?

**2**

**1**answer

### How to Change Orientation of Multi-Level Labels in a Vertical Excel Chart?

**2**

**2**answers

### In Excel, how can I round or display numbers to 2 significant figures (the two leading non-zero digits of a decimal number)?

**0**

**1**answer

### How can I delete a column in sheet 2 based on sheet 1?

**0**

**1**answer

### Excel formula changes itself - bug or intended behavior?

**1**

**0**answers

### Find Replace from excel to word template macro

**2**

**0**answers