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.

Applications Included in Microsoft Office 2016

Unless your question pertains to Microsoft Office as a whole or the integration between Microsoft Office programs, it is best to use one of these tags instead:

Related Microsoft server programs

These programs may support one of more of the user desktop applications for the Microsoft Office suite, and are installed on a central server:

Other Versions of Microsoft Office

If your question pertains to the entire Microsoft Office suite, or your question pertains to different versions of Microsoft Office, you should use one of these tags instead:

1415 questions
52
votes
2 answers

Excel number type changes 1.25 to 43125

When I open a plain new Excel sheet (2016), change the type of the cell to Number and enter the number 1.25, it will change the entered number to the value 43125,00. I get similar results when I enter 1.01 or 1.9, but not if I enter 1.99 – that is…
Croo
  • 603
  • 5
  • 7
32
votes
2 answers

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

I just noticed that the MS Excel column count increased from ZZ to XFD, i.e., 16,384 columns. What is the significance of this particular value? Why didn’t MS go further, up to ZZZ? Why did they stop at XFD?
Karth
  • 431
  • 1
  • 4
  • 5
28
votes
7 answers

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

Could you please help - as I have a weird situation that when I enter a number 22222.09482 in cell then I see a different number 22222.0948199999 in the formula bar. Below is the snapshot of the problem. I see the same behavior when I enter the…
user954171
  • 305
  • 1
  • 3
  • 3
22
votes
3 answers

How to remove Document Inspector warning in Excel

I'm running VBA scripts on a series of files that are XLSM type. While I'm trying to automate my processes, I'm getting stopped by this warning about the Document Inspector, meaning I have to click OK for every file. Is there a script I can run on…
Tess in Oz
  • 251
  • 1
  • 2
  • 7
18
votes
2 answers

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

Is it possible to remove the annoying search bar in Excel 2016?
user222864
15
votes
3 answers

Count with grouping in Excel

I want to count a number of rows for each value appearing in a column. Is there an easy way to do this in excel? Let's say I have the following table: A B C 1 Cat A 3 Cat A 3 Cat B 4 Dog A 5 Cat B I want to get the…
user194076
  • 353
  • 3
  • 4
  • 9
14
votes
3 answers

Creating a "grouped" bar chart from a table in Excel

Firstly, I have almost no experience with Excel charts. :) I'm trying to create a fairly simple chart from a fairly simple table. But I'm having more problems than I thought I would have and spending too much time on it. So, this is the table: And…
morgoth84
  • 243
  • 1
  • 2
  • 5
12
votes
3 answers

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

I'm desparately looking for a way to disable snap-scrolling in Excel 2016 for Mac. Basically as you scroll Excel will continually try to keep the cell you're focused on in the centered. So when you're working on a large spreadsheet and try scrolling…
Sandro
  • 121
  • 1
  • 1
  • 5
11
votes
7 answers

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

The start of each day all my Excel files open very small. After I maximize them, they will open and close just fine for the rest of the day. But the next day they all open small again. Here are some details I'm not using a shortcut. I've tried…
JimDel
  • 1,964
  • 11
  • 33
  • 48
10
votes
3 answers

Multiple instances upon opening multiple Office Documents

Starting with Version 16.0.8625.2121 of Office (tested with Word and Excel) - when you select multiple documents in the Explorer and hit Enter to open them, you will end up with instances to the count of the previous selected documents. To reproduce…
9
votes
1 answer

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

Can I customize Excel so that when the Excel window is not active, and I click on a cell, Excel will move to that cell? Clicking on a cell activates the window, but Excel does not move to the cell. I must click a second time on the cell to cause…
MetaEd
  • 349
  • 2
  • 14
8
votes
2 answers

Microsoft Excel 2016 Mac: Smooth cell transition

Changing cells in Excel 2016 Mac by clicking arrow keys results in smooth (i.e., painfully slow) transitions. Is there a way to disable this? (Note: distinguish this, I think, from 'smooth scrolling')
idunno
  • 183
  • 1
  • 3
8
votes
2 answers

How to create custom shortcuts in Excel 2016 for mac

I recently updated to Excel 2016 from Excel 2011 for mac, and I'm missing a very important feature which saved me a lot of time: custom keyboard shortcuts, i.e. being able to create new shortcuts for commands, or edit existing shortcuts. I have…
8
votes
7 answers

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

If you want to paste a format, you can copy and use the keyboard shortcut to paste special (Ctrl + Alt + V). MS Excel also has a useful format painter tool. You can select it using a keyboard shortcut (Using the hotkeys for the ribbon tools and then…
WorldGov
  • 1,332
  • 5
  • 19
  • 35
8
votes
2 answers

Inactive window scrolling not working with excel

Inactive window scrolling: With windows 10 there is a new feature called inactive window scrolling, which means if your mouse hovers over a window you can scroll on it, without it needing to be the active window. Problem: This feature is pretty…
1
2 3
94 95