# Questions tagged [microsoft-excel-365]

The microsoft-excel-365 tag has no usage guidance.

46
questions

**1**

vote

**0**answers

16 views

### Office 365 — sheet view

When you add a filter to Excel 365 file opened in a browser (not in a desktop app) there is a menu item called "Sheet View", but it is grayed out.
I wonder if it is something similar to Google ...

**1**

vote

**0**answers

20 views

### Paste as Values is wrong

My Paste as Values is giving me a strange answer:
All cells have Number format
Cell L12: 123,139.10
Cell C12: 123,132.94
Formula: =C12-L12
Formula's answer: -6.16
Paste as values: -6....

**0**

votes

**1**answer

30 views

### Extract current YEAR from sheet name which contains months

=MID(CELL("filename",AM4),FIND("]",CELL("filename",AM4))+1,255)
Hey all,
Im Using the above to get the sheet name which are months, but to return the current year. For example we are currently ...

**0**

votes

**1**answer

21 views

### Firefox: open Files directly in MS Excel 365 (app)

I'm using Firefox Quantum (V68) (Windows 10 1809) to access Google Mail through their Web-Interface (gmail.com).
When I choose to "download" an attached file, Firefox gives me the option either to ...

**2**

votes

**1**answer

24 views

### Filtering empty cells

Notice that B2 and B3 are merged and a filter is created on the B column
When I'm going to apply the filter it shows Empty (Vazias in Portuguese) as one of the options as there are merged cells in ...

**0**

votes

**2**answers

85 views

### Date filtering in Excel Online

I might be completely overlooking the feature, but i've been trying to filter a range of dates to only display today and future days in Excel Online (365).
At first sight it appears that there is ...

**0**

votes

**1**answer

18 views

### ActiveX Comboboxes in Excel 365 don't work

I have a sheet with some activeX comboboxes. They work properly in Excel 2013. Now I have an Excel - office 365 - version 1808 - build 10730.20264. When I open this very sheet, comboboxes do not ...

**0**

votes

**1**answer

15 views

### Excel - Office 365 formula loss on refresh

I have a query of external data, with a date range parameter. Included in the table are several columns which make calculations based on the queried data. My issue is when I change the dates or ...

**1**

vote

**0**answers

23 views

### Excel display more sheets in the sheet overview [duplicate]

We are using an Excel file that contains numerous worksheets.
Navigating these sheets has become a tedious task, we are currently sitting at 43 sheets that need to be navigated to relatively ...

**1**

vote

**1**answer

20 views

### How to alter axis points on a simple stacked bar chart in Excel

Using Office 365, I created the second type of stacked bar chart using the following data:
10.3
4.133333
0.25
9.316667
The axis marks are automatically set from 0 to 30.
On changing the maximum ...

**0**

votes

**0**answers

38 views

### Numerical information loss due to numerical format in Excel

On my excel the numerical format is "123456,789".
I download data from a website where the format is "123,456.789" .
More exactly the numbers are either "XXX,xxx" (XXX thousands), eather "XXX,xxx,xxx" ...

**0**

votes

**1**answer

37 views

### How to place insert shapes to upper level in Excel 365?

Until Excel 2016, the GUI allows easy access to the Insert > Shapes in the top level of the ribbon buttons. But starting Excel 365, the location was moved to Illustrations.
Insert ribbon group > ...

**0**

votes

**0**answers

25 views

### How to calculate values as percentage of values in other column in pivot table?

I'd like to get a percentage of the number of "TRUE" values in one column (z) compared to the number of "TRUE" values in another column (y) using a pivot table (used for filtering).
How do I do this ...

**0**

votes

**0**answers

20 views

### PowerPivot get the last value recorded for a date

I have a PowerPivot query where I have 3 columns: ID, Date and a Value. Every day is possibly recorded multiple values each on new row. so it looks like:
ID Date Value
1 1/1/2019 654594
...

**1**

vote

**1**answer

17 views

### Replace structured table name with cell reference?

Is there a way to take a formula...
tbl_hours[@SUN] and replace the SUN with the contents from another cell?
The user would would type a day of the week SUN, MON, TUE (or a cell would contain the ...

**0**

votes

**0**answers

30 views

### Excel time formatting

Excel 365, formulas sometimes display as small scientific notation instead of zero . The formula cell is set to “general”. Only with time math after 3:55 am.
A1=start time
B1=end
C1=hrs spent on ...

**0**

votes

**1**answer

397 views

### Add a trendline to a stacked bar chart

In Excel I have a stacked bar chart like this:
for which I want to add a trendline for the total (ie the full vertical bar).
The instructions I have found are for old Excel versions. One problem (...

**0**

votes

**2**answers

75 views

### Excel workday function to skip custom array of holidays

I am trying to use the Excel "workday" function to assist with handling a large list of public and organisational holidays when scheduling education courses in a multi-state country (Australia). ...

**0**

votes

**1**answer

23 views

### Better way to calculate string formula in excel 2016/O365?

GOAL: evaluate "2 Days 16 Hours 30 Minutes" to seconds.
I searched the web and found no fitting answer, i desire a 100% formula solution. Limitations: no VBA, avoid name manager, only day/hour/minute,...

**0**

votes

**0**answers

55 views

### Excel 365 Map Charts dont show all countries

When I try to create a chart map with countries like Egypt, Djibouti and Eritrea, their data is not printed on the map.
To reproduce, use this sample data in a sheet, countries are in ISO 3166 alpha ...

**0**

votes

**2**answers

94 views

### Excel: Split a string on a delimiter and determine the length of the resulting array

I have an Excel sheet including columns like this:
| 143 | 423 | | | 423;234 | 134;234;143 | =SOME_FORMULA() |
The data have the following characteristics:
Although numeric, they should be ...

**0**

votes

**0**answers

18 views

### Cell styles - change order of list

90% of the time, I want my number formats to show up as 1,234,567. There is a simple cell style for this (Comma [0]). However, I cannot get this style to show up as a default in the unexpanded ribbon ...

**0**

votes

**1**answer

705 views

### Count TRUE values in pivot table (without power query)

I have some data in Excel 365 for Mac that is formatted like so:
USER GROUP IN_SCOPE
1 GroupA TRUE
2 GroupA TRUE
3 GroupA FALSE
4 GroupB TRUE
5 GroupB ...

**0**

votes

**1**answer

41 views

### How to set value of height or width of cell precisely? - ms excel Office 365

I'm going to make labels for pasting in MS Excel Microsoft Business 365. I have version 1903 (compilation 11425.20228). But they should made precisely and perfectly.
Now when I begin editing the ...

**0**

votes

**0**answers

32 views

### Graphing actual months in excel

I have been looking on the forum to the best of my ability and I can't find the exact answer to my question. It seems trivial though so if I have missed it I do apologize.
I have a graph were I am ...

**1**

vote

**0**answers

108 views

### Show CSV format in MS Excel open file dialog by default

When opening files from within Excel using the Open file dialog and browsing to my data, the default setting is to list "All Excel Files (*.xl*;*.xlsx;<etc>)". However, this listing of options ...

**0**

votes

**1**answer

237 views

### Excel 365 Slow Scrolling due to Notes and Comments

An Excel spreadsheet containing any 'notes' (previously known as 'comments' in some earlier Excel versions) is slow to scroll up and down when holding down the up/down arrow keys. For example, even ...

**1**

vote

**1**answer

50 views

### Excel : Summation of data that belongs to certain id

It is easier to illustrate the problem based on the following example:
I have two sheets: mapping and data.
The Mapping sheet contains a (one-to-many) mapping table between a country name and the ...

**1**

vote

**1**answer

13 views

### How do I add incremental numbers in the middle of a sequence?

MPP1-302-US - I want to easily make the column go
MPP2-302-US,
MPP3-302-US, etc.
without having to split the data. Is this possible? If so, what is the formula?

**1**

vote

**0**answers

31 views

### Last filled row Function behaves strangely based on column it's in

Function is acting very strange depending on column it's in.
Data start at row 7 (headers in row 6)
Column A has item name B Max Qty. C and D have simple functions and everything afterwards is the ...

**2**

votes

**1**answer

134 views

### Excel error charts and drawings

I'm experiencing an odd issue with Excel. Whenever I open an Excel file (both xlsm or xlsx, Office 365) I receive back an error message about drawings and I cannot see any chart or drawing inside, ...

**0**

votes

**1**answer

217 views

### Excel 365 - Pivot tables ungroup dates when refreshed; not an issue in Excel 2016

I have an Excel workbook that is pulling data from MS SQL Server into a PowerPivot data model and then about a dozen pivot tables. These tables contain date information that is grouped by year and ...

**0**

votes

**0**answers

41 views

### Manually updating Excel worksheets through VBA doesn't work when automatic calculating is disabled

In our daily work we disable automatic calculation in Excel by VBA,
and decide when a cell or sheet is updated.
Worksheets("Sheet1").Calculate does not seem to work any more after the update released ...

**0**

votes

**2**answers

62 views

### How to customize line charts in Excel

In an Excel line chart, how do you do the following (if it can be done):
have different colours within the line,
insert an arrow pointing to an area of the line with a caption
with text explaining ...

**1**

vote

**1**answer

48 views

### Name the first item from a list that is not in another list

I am working with a list of articles in one spreadsheet files as the data source. The data is split into a source reference code in columns A to E, the title of the article in column F and the author ...

**0**

votes

**0**answers

248 views

### Excel, Refresh RTD data from VBA Macro

I am trying to bring RTD data from Interactive Brokers trading application into excel using RTD links. I trade options, and the goal is to be able to build a list of strikes for a product I haven't ...

**1**

vote

**0**answers

34 views

### After copying in Excel, can't copy anything outside of Excel

I'm experiencing a frustrating issue with copying and pasting with Excel. I haven't been able to word it exactly so I haven't found much online except for an old "Keep Copy" function.
When I copy ...

**0**

votes

**1**answer

39 views

### Is there an equivalent of the CTRL+. shortcut key in Excel 2016 and Excel 365?

It seems that this shortcut key was removed and I haven't been able to find a ribbon based replacement for it.
CTRL . is the Move active cell clockwise in selection which is quite key for efficient ...

**0**

votes

**0**answers

34 views

### Unlock Sheets via VBA

I have an excel with a lot of formulas running and it goes to an executive team. Naturally I have locked the two summary pages to prevent formulas from being deleted accidentally but on some systems ...

**0**

votes

**1**answer

26 views

### Excel: Have X-axis formatted to show ranges of values

I'm attempting to graph values using a PivotChart, but the values range anywhere from 1 to 1000 and the specific values aren't too important, so I want them to be grouped from 1 to 100, 101 to 200, ...

**0**

votes

**0**answers

8 views

### Form Control Combo Boxes do not update linked cells when input range changes

I have a workbook containing various worksheets each with about two dozen Form Control Combo Boxes.
The input range for the Combo Boxes is on a worksheet within the same workbook and will be ...

**0**

votes

**2**answers

792 views

### Excel 365: Cannot paste values to visible cells only

In Excel 365, I've selected visible cells only from a filtered selection. Cell count is 285, which is factual. I've tried copying and pasting from a different workbook a list which also counts 285 ...

**0**

votes

**1**answer

143 views

### Trouble with INDIRECT formula [closed]

This is my formula:
=IF(ActualsThrough<F$5,SUMIF('209Budget'!$F:$F,'209ActBud'!$C7,'209Budget'!I:I),-IFERROR(OFFSET('Month TB'!$D$1,MATCH($C7&+"-"&+$C$2,'Month TB'!$B:$B,0)-1,MATCH(F$5,'...

**0**

votes

**3**answers

78 views

### Finding highest numerical value from a range of hybrid data in Excel

I have a row of 6 alpha-numeric values as in the picture. I need a formula that will determine the three highest numerical values across each row, and then display the letters associated with those ...

**1**

vote

**1**answer

42 views

### autofill a reference of a column to a row in steps

I have the formula =IF(Jan!$L6="w",Jan!$L6,"") in the cell A2.
in the cell right next (B2) to it I'd like to have the formula 3 rows further down so
=IF(Jan!$L9="w",Jan!$L9,"") and then in C2 ...

**0**

votes

**3**answers

1k views

### How can I format a character string in Excel to insert hyphens?

I have a string in a cell that is 8 characters. E.g. ABCDEFGH, can I use a custom number format for the cell to have it displayed as AB-CD-EF-GH?
Currently my method is to have another cell reference ...