20,274 questions with Microsoft 365 and Office | Excel | For business | Windows tags

Sort by: Updated
2 answers

Selecting a cell in Excel goes to an incorrect cell

Amazing how long this has been an issue. It started in Tech Community and now resides here in "Ask a Question". While I understand that some questions will not be answered, This one is unbelievably growing in frustration. I am not a coder BUT I…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-03-11T15:59:54.11+00:00
LesemannCPA 0 Reputation points
commented 2026-03-12T22:57:14.96+00:00
Hendrix-C 12,120 Reputation points Microsoft External Staff Moderator
2 answers

Error issues when sharing an excel spreadsheet created with a query.

[DataSource.Error] Can't load data from this source because it's protected. I have checked that no protection is applied to the worksheet or workbook. How do I trace the error.

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-03-11T14:57:16+00:00
Jane Appleby 0 Reputation points
edited a comment 2026-03-12T22:49:51.89+00:00
Hendrix-C 12,120 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Formula that returns the second to latest date

Hi. I have a list of many dates and many names. I can get the latest date related to a name, but I need the second latest date.

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-03-12T16:25:21.1266667+00:00
Holly Beazley 0 Reputation points
commented 2026-03-12T22:43:11.21+00:00
Hendrix-C 12,120 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Filter formula with multiple lookups over multiple columns

I'm trying to use the FILTER function formula to list a consolidated view of lease agreements, by office locations, to separate out the different leases by location instead of all the leases being shown under just the Data | Filter option on the sheet. …

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-03-12T20:10:51.94+00:00
Laura Walker 0 Reputation points
answered 2026-03-12T20:58:28.3+00:00
Hendrix-C 12,120 Reputation points Microsoft External Staff Moderator
2 answers

Can I change the General Ledger with a Budget Comparison from a calendar year to a fiscal year

Is there a way to change the General Ledger with a Budget Comparison from a calendar year to a fiscal year? My calendar runs from July to June.

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-03-12T17:16:03.0566667+00:00
Olsen, Beth E 0 Reputation points
answered 2026-03-12T18:28:20.81+00:00
Hendrix-C 12,120 Reputation points Microsoft External Staff Moderator
2 answers

Formulas No Longer Working

Hello! This spreadsheet is used to: 1) maintain a queue for services, 2) track services as they are completed. Originally, I had input a few functions when this document was shared with the team about a year ago, and it had been working well for a while,…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-02-27T15:20:07.1133333+00:00
Eric Cartagena 0 Reputation points
commented 2026-03-12T15:09:44.15+00:00
Ryan-N 10,885 Reputation points Microsoft External Staff Moderator
1 answer

Change the scrolling axis

I need to change/switch/reverse the function of my mouse wheel, so that by scrolling, the sheet moves horizontally without having to press CTRL + SHIFT. It would also be good if I could retain the vertical scroll function by pressing CTRL + SHIFT.

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-03-12T09:32:25.4333333+00:00
LastWeek's Homework 0 Reputation points
edited a comment 2026-03-12T12:45:15.6766667+00:00
Alina Le 315 Reputation points Independent Advisor
1 answer

Spreadsheet Compare installation

How do I troubleshoot, install or reinstall Spreadsheet Compare on my PC. It is not currently functioning.

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-03-08T06:05:24.2733333+00:00
Tim Overton 20 Reputation points
commented 2026-03-12T11:10:48.08+00:00
Tamara-Hu 11,970 Reputation points Microsoft External Staff Moderator
2 answers

Copying information to register

I have filled in all the information for the VBA and when I try to run it I get zeros where amounts and invoice number should be. The customer name copies correctly.

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-03-10T15:22:19.11+00:00
Heather Brock 0 Reputation points
commented 2026-03-12T07:42:47.72+00:00
Nam-D 2,410 Reputation points Microsoft External Staff Moderator
2 answers

graphs in excel - bar chart changes from nice thick bars (Vertical) skinny lines. 2 images attached showing how 1 chart changed.

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-03-11T04:30:48.01+00:00
Paul Gailiunas 0 Reputation points
commented 2026-03-12T05:53:30.6633333+00:00
Paul Gailiunas 0 Reputation points
2 answers

sumproduct - add two cells together and then multiply by the value of a cell off another sheet

I'm adding column J (OUT) and K (IN) together and then multiply it by value of L2 The value of Cell L2 can be found on the Billing Tab Column B So if Ashley had 4 outbound calls and 2 inbound calls, 4+2=6*0.050785130 So the Cell L3 should have…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-03-11T01:32:36.9+00:00
KARL HEINE 20 Reputation points
commented 2026-03-12T05:41:45.58+00:00
Jade Ng 9,370 Reputation points Microsoft External Staff Moderator
3 answers

Excel SORT/SORTBY function

Nice to have possibility to allow negative numbers in SORT sorting array - meaning sort order =SORT(array;{3;-2;5;-1}) equals =SORTBY(array;chooscol(array,3;1;2;-1;5;1;1;-1)) I know that with REDUCE I can create this but compact SORT might…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-03-01T19:41:07.3333333+00:00
Henn Sarv 46 Reputation points
edited an answer 2026-03-11T22:54:55.6133333+00:00
Hendrix-C 12,120 Reputation points Microsoft External Staff Moderator
4 answers

Excel - Consolidate IDs and display data horizontally

I have a dataset that is not useful to me in its current format, and I lack the Excel knowledge to automate what I'd like to accomplish. The current data set contains: Column A: An ID number. Columns B, C, and D: A single row of data that corresponds…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-03-10T15:49:54.0166667+00:00
Joe Daniel 0 Reputation points
commented 2026-03-11T22:52:14.93+00:00
Hendrix-C 12,120 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Excel Question

I have to calculate a rebate that has three criteria to determine the % that is applied. The 1st criteria is if it belongs to specific groups (there are 9), if the do they get 2% of sales $ The 2nd criteria if the 1st isn't valid (as in they don't don't…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-03-11T18:56:41.08+00:00
Bev Keller 20 Reputation points
accepted 2026-03-11T19:13:53.26+00:00
Bev Keller 20 Reputation points
1 answer

How to disable Comment/Note pop-out on hover, but leave the indicators in Excel

Hello, I have been finding the auto comment pop-out function to be very intrusive on some document templates my company uses. I cannot delete these comments as they are part of the template, so I've been searching for a way to disable them from popping…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-03-11T14:08:54.9033333+00:00
Bryan Morris 0 Reputation points
commented 2026-03-11T18:33:49.0133333+00:00
Bryan Morris 0 Reputation points
2 answers

Billing Error

I had an account with the email [Moderator note: personal info removed]. That was my old company and i no longer have access to that email. I received a charge on December 24, 2025 for $129.99. How do i cancel that account

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-03-11T15:29:56.43+00:00
Tony Persichilli 0 Reputation points
answered 2026-03-11T16:21:10.55+00:00
Alexis-NG 13,535 Reputation points Microsoft External Staff Moderator
9 answers

Update of Office LTSC from 2016 to Office Ltsc 2024

I had an Office 2016 LTSC active suite. I recently upgraded to Office 2024 LTSC and all components work OK. My account however, is still saying that Office 2016 is activated and the Excel software is saying it is unlicensed. All other office…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-03-07T07:09:28.2633333+00:00
Joe Taranto 0 Reputation points
edited a comment 2026-03-11T15:56:31.5+00:00
Henry-N 10,540 Reputation points Microsoft External Staff Moderator
2 answers

Required help for install excel LTSC 2024 & activation

Required help for install excel LTSC 2024 & activation

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-03-10T10:13:37.37+00:00
Praveen Manaula 0 Reputation points
commented 2026-03-11T14:09:00.9833333+00:00
Jess-Q 8,550 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Change default bright red color of the note indicator in Microsoft Excel

Is there a way to change the note indicator color which is defaulted to bright red color in Microsoft Excel? I want to change the color to green. Please guide on the steps to change it. If the above is possible, is it possible to do this through POI API…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-03-11T07:08:50.63+00:00
Vaibhav Mittal 25 Reputation points
accepted 2026-03-11T12:27:34.0066667+00:00
Vaibhav Mittal 25 Reputation points
2 answers

blocked macro in xlsx file

how to unblock an xlsx file to run trusted macro in windows 11

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-03-10T12:19:44.9233333+00:00
Keith T. Terry 0 Reputation points
commented 2026-03-11T06:09:32.77+00:00
Nam-D 2,410 Reputation points Microsoft External Staff Moderator