Use this tag for questions specifically about the 365 version of Microsoft Excel; otherwise use [microsoft-excel].
Excel is Microsoft's spreadsheet application; Excel 365 is part of Microsoft Office 365.
For more info, see microsoft-excel.
Questions tagged [microsoft-excel-365]
262 questions
8
votes
4 answers
Start Excel histogram X-Axis at 0
I'm charting the frequency of a range of numbers in a histogram in Excel 365. The numbers range from 236 to 1736 and I've got the bins at 250. Excel is automatically starting the histogram bins at the 236-486 range. I don't see an option anywhere to…
Kay
- 81
7
votes
1 answer
Enlarging the conditional formatting window in Excel
I use a lot of conditional formatting, often with relatively complex formulae to decide the format. Administering them, though, becomes a nuisance - the conditional formatting dialogue is too small and I have yet to find a way to resize it or the…
Andrew Perry
- 267
6
votes
1 answer
Excel Needs Key For Microsoft 365 Family Subscription
I have had a Microsoft 365 Family subscription for many years. It will renew on Dec-04-2024. So its active.
I just purchased a new laptop and successfully logged into the MS 365 subscription on that laptop. I downloaded the installer for a local…
Taptronic
- 1,121
6
votes
1 answer
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 (apart from the different menu options) is that, if I…
5
votes
1 answer
Making it so users that do not have macros enabled cannot see other sheets
I am working on a project that wants all users to have macros enabled. It is a shared sheet so I cannot simply hide everything as a baseline and unhide the sheets when Open_Workbook is ran. My goal is to make it so only my designated "BLANK" sheet…
4
votes
1 answer
Why this apparent orthogonality in Excel's INDEX() syntax?
TL;DR
In Excel 365:
Why doesn't a 0 in the second argument of INDEX(A1#,0,{1,3}) return all rows, when it does in each of INDEX(A1#,0,1) and INDEX(A1#,0,3)?
And is there a canonical way of getting it to do so?
DETAILS
Assume I have a dynamic array…
tkp
- 484
4
votes
4 answers
Excel keyboard shortcut to edit formula in formula bar
When I press F2 in a cell I can edit it inside the cell. However often it's just more convenient to make the edit in the formula bar.
I can switch to formula bar by mouse, just wondering whether there is a keyboard shortcut for that?
when editing in…
Máté Juhász
- 22,071
4
votes
2 answers
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 FALSE
I would like to create a pivot table that…
rs2345
- 41
3
votes
1 answer
Using concatenation operator (&) before ROUND and SUM function in Excel
I'm using Microsoft 365's Excel on Windows 7. I'm trying to understand why this formula:
="S/ "&ROUND(SUM(E39:E40),2)
Will not provide an output to 2 decimal places?
My intention is to concatenate "S/", the local currency, to the numerical string.…
Albert F D
- 135
3
votes
0 answers
Why does PowerAutomate now require me to have my document open?
I use PowerAutomate (Cloud, not Desktop) to read an email in Outlook.com and write a value to an Excel spreadsheet in OneDrive. This setup worked fine for months, but in mid-December, it started failing.
Through troubleshooting, I found that it will…
Midavalo
- 264
3
votes
2 answers
Excel 365. Splitting Cell into multiple rows whilst copying neighboring rows
Not sure if there is a way to do this but here goes.
I have a table with Columns named Vuln, Vuln type, Devices, Comments.
Each Devices cell has multiple values in it separated by a comma. I would like to split these out in tho the rows below, but…
3
votes
1 answer
How can I use Excel to calculate the number of recent, consecutive fiscal years someone has made a gift to my company?
I am working at a nonprofit and we are trying to get a project off the ground where we send people postcards celebrating how many years they have been giving to us.
I am working with Excel in Office 365 on my Windows desktop. My knowledge level of…
Sophie39DS
- 39
3
votes
1 answer
How to stop Text-to-Columns splits as default
I was copy-pasting some data from a PDF price book into Excel. I then then split the data into different columns along the $. However, when I then copy-pasted the next section of the PDF into Excel, it automatically split along the $. The problem…
Yehuda
- 270
3
votes
0 answers
Why is text typed into other cells appearing in a cell with no formulas in a workbook with no macros?
I have a workbook with a few sheets of data, one PowerQuery, a few pivot tables.
On one of the sheets, when I type into some cells at the top of the workbook, whatever I type is repeated in cell B3. It appears large at first, then the text shown in…
FlexYourData
- 7,631
3
votes
2 answers
MS Excel 365 Not Sorting
I have recently started experiencing a weird bug with excel, for some reason it has stopped sorting columns. It does not matter the way I try to sort, it just does not do it, however, filtering does work.
I have been googling for over an hour but…
EOZyo
- 31