Questions tagged [microsoft-excel-365]
The microsoft-excel-365 tag has no usage guidance.
46
questions
1
vote
0answers
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
0answers
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
0answers
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
0answers
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
1answer
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
0answers
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
1answer
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
2answers
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
1answer
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
0answers
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
2answers
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
0answers
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
1answer
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
1answer
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
0answers
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
0answers
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
2answers
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
1answer
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
0answers
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
0answers
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
1answer
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
0answers
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
1answer
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
0answers
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
2answers
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
1answer
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
3answers
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
1answer
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
3answers
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 ...
