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

**52**

**2**answers

### Excel number type changes 1.25 to 43125

**30**

**2**answers

### What is the significance of the number of columns (16384) in MS Excel 2016?

**28**

**7**answers

### In Excel, when I enter 22222.09482 then I see 22222.0948199999 number in the formula bar

**18**

**2**answers

### How to remove the tell me what you want to do search box in Ms Office Excel 2016

**17**

**3**answers

### How to remove Document Inspector warning in Excel

**12**

**3**answers

### How to disable snap/jump scrolling in Excel 2016 for Mac

**11**

**3**answers

### Creating a “grouped” bar chart from a table in Excel

**10**

**7**answers

### Why do all my Excel 2016 files open to the size of a postage stamp?

**9**

**3**answers

### Multiple instances upon opening multiple Office Documents

**8**

**2**answers

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

**8**

**2**answers

### Microsoft Excel 2016 Mac: Smooth cell transition

**7**

**3**answers

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

**7**

**4**answers

### How to replace with leading zeros in Excel?

**7**

**2**answers

### Excel: Graph square wave using time ranges for y=1, and a lack of them for y=0

**7**

**3**answers

### Count with grouping in Excel

**7**

**2**answers

### Excel function to insert variables into string

**7**

**5**answers

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

**7**

**1**answer

### How do I remove or disable downloadable fonts in Microsoft Word and Excel?

**6**

**1**answer

### How can I click on an inactive Excel window and have Excel move to the cell I clicked on?

**6**

**2**answers

### Excel bug? Inconsistent behavior when Cut/Copy-Pasting across filtered data

**6**

**5**answers

### How to export a spreadsheet to a UTF-8 .csv from Excel 2016 on mac?

**5**

**3**answers

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

**5**

**3**answers

### Find keywords in paragraphs of text (in Excel)

**5**

**1**answer

### As a US user, how can I change the default date format in Excel 2016 (Mac) to YYYY-MM-DD?

**5**

**2**answers

### Excel Power Query date format messup

**5**

**4**answers

### Avoid cell resizing when creating a table using excel

**5**

**1**answer

### MS Excel: Displaying custom lower error bars

**5**

**0**answers

### Change keyboard shortcuts in Microsoft Excel 2016 in Windows [duplicate]

**5**

**2**answers

### Inactive window scrolling not working with excel

**4**

**1**answer

### Excel format from mm/dd/yyyy to mm-dd-yyyy

**4**

**9**answers

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

**4**

**1**answer

### How to move columns with drag and drop in Excel 2016?

**4**

**2**answers

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

**4**

**3**answers

### Calling a Sheet Sub from a Userform

**4**

**2**answers

### Conditional Formatting: Min Value Across Multiple Columns in Excel

**4**

**1**answer

### Always open 'Blank Workbook' when clicking (File) > (New), and when Excel first opens

**4**

**1**answer

### Excel treating text as numbers in a COUNTIF for duplication highlighting

**4**

**1**answer

### Custom cell format for IP address to force leading zeros?

**4**

**2**answers

### How to import CSV into Excel 2016

**4**

**2**answers

### Range mapping in Excel

**4**

**2**answers

### Identifying different permutations of some field in Excel holding others constant

**4**

**1**answer

### How can I dynamic change separators configuration in Excel 2016 for CSV files?

**4**

**2**answers

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

**4**

**2**answers

### How to create an Excel chart with no numerical labels?

**4**

**1**answer

### Force Excel to re-parse a whole column of dates

**4**

**1**answer

### Summing array in Excel

**4**

**2**answers

### How to protect worksheet with writeable cells that retain formatting and comments

**4**

**1**answer

### How to apply the same conditional formatting to other cells?

**4**

**1**answer

### Sort an Excel range that is greater than an Excel table

**4**

**4**answers