Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
1answer
31 views

Use Excel INDEX to create a series of text labels

I am using this Excel template to create a calendar. I am trying to add additional text next to the Julian Day. The text comes from a range with values "D", "P", "L". Starting on Monday, the value ...
-1
votes
0answers
25 views

Increase space between labels on Y Axis

I'd like to increase the spacing between the ticks (labels) on the Y Axis so that the label within each small bar graph segment is more legible. I've found a spot to increase/decrease bar width, but ...
0
votes
0answers
22 views

Making line chart respect time?

I have a line chart with dates as axis X, and there's a gap in the data (e.g. there's data until the 8th, then no data, then data from the 20th). Excel displays all this on the same scope, ergo the ...
1
vote
0answers
12 views

Excel formula to find date in given range (entire column)

I was actually trying to write a formula to match and find a date in the entire column. So say suppose I have something like this in sheet1: A | B -------------------- ID | Date1 ---...
0
votes
0answers
15 views

Group by , sort and difference

Please help me derive formula to calculate the difference in Excel after group by and sort by, In the above excel want to group the columns values "Process Unit,Process Name" and sort by "Time", and ...
1
vote
0answers
35 views

Microsoft Excel Fuzzy Lookup add-on - set too big?

The data I'm comparing is a set of cataloged items (90k items) with an old list of items we thought were missing (about 11k). I need to see if any of the "missing" items actually show up in the ...
0
votes
1answer
21 views

Is it possible to create a chart based on a single cell that contains two separate numbers?

I'm currently combining two workbooks and then exporting a comparison of the data there. If I'm exporting a table this leaves me with something like so.. +----+---------+ | 1 | 2 | +----+------...
1
vote
0answers
7 views

Creating Excel Sheet using Slicers - Keeping data in specific order

I'm creating an excel sheet using slicers to populate a particular set of questions for scoping projects in IT. Is there a way to make the data show up in a specific order (generally the order in ...
0
votes
0answers
5 views

How to use a ComboBox with autocomplete in the drop down and search as you type

I have a ComboBox embedded in a worksheet that references a list of items. Ie: small cat cat big cat small dog dog big dog Right now when I type in 'cat' i only get 'cat' as the suggestion in the ...
0
votes
0answers
17 views

VBA - A message “Delete?” comes up by itself while looping to protect sheets

During a loop (For Each ws in ThisWorkbook.Worksheets, code below)... There are 38 sheets. Two of them has this message popped up..?? It's a message from Excel, not me.... why? What does this mean? ...
0
votes
1answer
27 views

VBA excel why the word “EnableEvents” is not capitalized in my VBA coding?

The "e" is not capitalized: My code: Application.enableEvents Should be: Application.EnableEvents ... right? Why my "e" is not capitalized automatically? My codes: Private Sub Workbook_Open() ...
0
votes
0answers
12 views

Mouse scroll dropdown list of ComboBox in Excel 2016 64-bit

I have a ComboBox dropdown list that has 150+ lines. I was wondering if there's a way to control the scrolling with the mouse wheel over the lines so you don't need to use the bar on the right.
0
votes
1answer
22 views

VBA - How to disable “record macro”?

Lower left corder of screen (in status bar), there is a squar icon for "record macro". Wow, that's dangerous for my secret macro codes. How to disable this? Could not find a satisfactory answer on ...
0
votes
1answer
44 views

If a cell contains a certain text, then assign a value to it

I have a drop down menu with 10 different text options. These options represent different statuses on a project. (i.e.: Not started, Information Gathering, Speaking with Contacts, Development...) I ...
0
votes
1answer
29 views

Adjust row height in excel from INDEX formula

I have some cells whose content is determined by an INDEX formula. They are horizontally merged cells, on a single row. The content they can show is quite variable in length, so the cells are set to ...

15 30 50 per page