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

**5**

**1**answer

### MS Excel: Displaying custom lower error bars

**4**

**1**answer

### Excel 2013/2016 not updating values while workbook is minimized

**3**

**1**answer

### Why does Windows Defender slow my Excel file saving, even if the xlsm file type is excluded?

**3**

**1**answer

### TEXTJOIN() on an array incorrectly returns a blank

**3**

**2**answers

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

**3**

**1**answer

### Define Name for Worksheet Scope in Microsoft Excel for Mac V15.38

**3**

**0**answers

### When customizing the Ribbon in Excel 2016 on Windows, what governs Group layout within a Tab?

**3**

**1**answer

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

**3**

**2**answers

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

**2**

**0**answers

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

**2**

**0**answers

### Efficient way to concatenate row titles based on column indicator?

**2**

**0**answers

### I am unable to enter 6E029 in a cell in Excel

**2**

**1**answer

### Excel Chart - X-axis values stopping at a certain point

**2**

**0**answers

### Calculating and rendering a complex report in Excel

**2**

**2**answers

### Excel: Formula that supports more than 15 digits

**2**

**1**answer

### Need Auto Increment number beginning with Alphabet in Excel

**2**

**1**answer

### Microsoft Excel Axis Options sidebar

**2**

**1**answer

### What is the easiest way to insert data with the wrong decimal separator into Excel?

**2**

**0**answers

### How to change the format of a date in a Pivot Table?

**2**

**1**answer

### How to keep already-opened workbooks minimized from restoring when opening another workbook?

**2**

**1**answer

### Sending specific email based on cell values in Excel 2016?

**2**

**1**answer

### Auto-populate cells in Excel

**2**

**0**answers

### “The system cannot find the file specified” error for CreateObject(“Excel.Application”)

**2**

**1**answer

### How can I embed an Excel workbook with multiple worksheets into another Excel workbook?

**2**

**0**answers

### Automatic update of powerpoint graphs from a linked excel

**2**

**2**answers

### Creating a ranking in Excel by matching values in non-contigous cells

**2**

**2**answers

### Excel - pivot table does not group dates

**2**

**1**answer

### Show MS Excel Syntax as you type Formula

**2**

**3**answers

### Find text in the textbox in Excel

**1**

**0**answers

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

**1**

**0**answers

### Find Replace from excel to word template macro

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

**1**

**1**answer

### Excel 2016 - How Do I Change The Border Line Color from Default Black to Another Color

**1**

**1**answer

### Excel conditional formatting matching text in other cell that may include other text as well

**1**

**0**answers

### Importing Entity Relationships from Excel into Visio

**1**

**1**answer

### Excel: Dependent drop-down + calculations through multiple sheets (with different columns position)

**1**

**0**answers

### Deleting table rows in Excel VBA by cell value - doesn't delete all rows, why?

**1**

**1**answer

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

**1**

**1**answer

### Extracting data from one Excel sheet to another, with no spaces in rows

**1**

**0**answers

### How can i compare 2 columns row by row in excel and then extract unique information?

**1**

**1**answer

### Dynamic Excel Formulas For Ranges

**1**

**1**answer

### How to group in Power Query such that group headings show above items in the rows

**1**

**1**answer

### How do I flip a bar chart?

**1**

**0**answers

### Excel: Random select within table that meets with a condition

**1**

**0**answers

### Loading new data from a CSV file into an Excel table

**1**

**0**answers

### Microsoft excel security warning excel 2016

**1**

**1**answer

### Microsoft Excel has Black background

**1**

**2**answers

### Suspect behaviour getting cell width in Excel

**1**

**0**answers