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

**1**answer

### Alternative for a filter formula

**0**

**1**answer

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

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

**2**answers

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

**0**

**1**answer

### Excel CTRL-V not working properly

**0**

**2**answers

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

**0**

**1**answer

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

**-1**

**1**answer

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

**1**

**0**answers

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

**2**

**1**answer

### Excel graph not showing some x value labels

**0**

**2**answers

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

**0**

**1**answer

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

**0**

**1**answer

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

**1**

**1**answer

### LARGE function throws error

**0**

**1**answer

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

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

**2**

**1**answer

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

**1**

**0**answers

### Find Replace from excel to word template macro

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

**0**answers

### Excel file saved many times but version history is blank

**2**

**0**answers

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

**0**

**1**answer

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

**0**

**0**answers

### Excel 2016: How to find a specific name in sheet “A” and and get the adjoining cell's value to a cell in sheet “B”?

**0**

**2**answers

### Division calculation within pivot table values in excel

**0**

**1**answer

### #VALUE! error using excel 2016 nested IF statements

**0**

**1**answer

### How to return first non-blank value with LOOKUP function

**-1**

**1**answer

### Excel - How to delete the infinite blank rows?

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

**0**

**0**answers

### Excel: Writing a 'report' within a worksheet

**0**

**1**answer

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

**0**

**0**answers

### Excel Chart “Save as Picture” making dates into numbers

**0**

**1**answer

### Excel: Drop down with month instances

**0**

**1**answer

### Combining an Excel IF Statement with VLOOKUP

**1**

**1**answer

### COUNTIF across multiple sheets does not work with SUMPRODUCT

**1**

**0**answers

### Excel table.combine({Sheet1},{Sheet2}) erases data on an append

**0**

**2**answers

### Excel: Return all matches in columns using one criteria (from drop down)

**0**

**1**answer

### Changing the layout of an Excel Sheet

**0**

**3**answers

### How to split a string by certain length in excel and put it into columns

**0**

**1**answer

### Blocking certain rows for certain users when sharing an excel-sheet

**0**

**1**answer

### Conditional formatting for specific group of values/rows based on cell value(s)

**0**

**1**answer

### MSExcel: Is it possible to make an adaptive formula through reference?

**0**

**1**answer

### Cannot Reference Pivot Table headers due to header formatting

**0**

**1**answer

### Open Semicolon Delmited Text File in Excel Via Double Click

**0**

**1**answer