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:

1433 questions
4
votes
1 answer

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

(Excel 2016 on Windows 10) Suppose one or more workbooks are open, but they have been minimized. When I open another workbook, for example by double-clicking on it in Explorer, one of the minimized workbook window always restores (pops up) before…
Sue D. Nymme
  • 151
  • 2
  • 6
3
votes
1 answer

Slow shortcuts on Excel 2016

I have just installed excel 2016 on my computer for work. I am processing a fairly average data set. However, I am finding the keyboard shortcuts much slower than in Excel 2013. For example, when I use "ALT-A-T" to create filters, the workbook…
user2666391
  • 31
  • 1
  • 3
3
votes
1 answer

How to disable excel suggestion of conditional formatting

On 2016, every time you select/copy/paste a range, there's a little icon at right-side lower corner of the selection, giving you some options. If you use they keyboard extensively to navigate throughout Excel, you can unintentionally focus on these…
Emwat
  • 149
  • 2
  • 9
2
votes
2 answers

Excel sum different numbers than the ones in the cell

I'm trying to keep track of my worked hours and translate it in billable days (I bill on a day basis, not hours) while calculating my monthly hours balance. I've got cells corresponding to each day of the month in which I place my worked time with…
Laurent S.
  • 135
  • 1
  • 8
2
votes
1 answer

Convert alphabet to numbers?

How do I convert the alphabet to number? For example: I have the letter A, B in a column and I want him to think these letters are numbers, eg A = 1, B = 2, I want him to think they are numbers if I am going to use the " Small() "I want him to…
2
votes
1 answer

Microsoft Excel Axis Options sidebar

Could I check what is the keyboard shortcut to select the various options in the Axis Options side tab? e.g. for Bin width, the 'B' is underlined and in older excel version where axis options are in dialog boxes, you could simply type 'B' to jump to…
L.Koh
  • 41
1
vote
1 answer

How to edit a cell without using the mouse

I am trying to use the insert shortcut to insert words into and excel cell. Ex, I have need to do in the cell. But I want to add by June 30th I have tried cntrl or fn plus insert or insert or just insert alone and nothing happens. Can anyone please…
Mia
  • 11
1
vote
1 answer

Microsoft Excel has Black background

How do I get the black background changed back to the default setting? The original cell color was white. I didn't see an answer to this question in the blogs.
1
vote
0 answers

Chart format option not available for Excel web app

I have a subscription of Office Home and Student 2016. When I upload my excel file with a chart to Excel web app, I am unable to see the 'Format' option for the chart. Please see the snapshot below. Without 'Format' option I experimented around a…
Samresh
  • 11
1
vote
0 answers

Dynamic and alphabetized list of first 25 unique instances

I have an XLS file with a column A containing many name entries. It looks somewaht similar to the following: I am looking for a way to dynamically create a list in column B of the first 25 unique entries in column A, and to do so in alphabetic…
Rachel
  • 111
1
vote
1 answer

Color the columns based on group and column value

I am using excel 2016, where I need to do some coloring based on group and a value in a particular column. My input record is given below enter image description here My requirement is that within a group(Grouping is done based on COLA and COLd),…
1
vote
1 answer

How to manipulate hierarchical breakdown in Excel

Please consider below screenshot We can see that the tasks and corresponding items under it are properly grouped in a tree hierarchy. I wasn't able to figure out how I can manipulate this hierarchy in excel or create one from scratch. Please…
pOrinG
  • 135
1
vote
1 answer

Finding the top 10/15/20 percent (excel 2016 or google sheets)

I have an alphabetical list of students in Column A. In Column E is the total number of award dollars they have earned. I need to find the top 10% award earners, top 11-15%, and then the top 16-20%. I really would rather not reorder them based on…
BBATL72
  • 11
1
vote
1 answer

Comparing 3 columns to 3 other columns for a match?

I am trying to compare 3 columns of data: NPI#, month, and Year to 3 other columns with the same data looking for an exact match on all three. If and/when all 3 match then I want to return the original NPI# and if not then return N/A. So for…
1
vote
1 answer

How to count unique values in a table with several criteria?

I work for a small charity, and I'm trying to write a formula which will tell me each month how many unique individuals have donated in the last two years. A sample set of data is below, but the full data set is over 10 000 rows and is formatted as…
1
2 3 4 5 6 7