A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
20,274 questions with Microsoft 365 and Office | Excel | For business | Windows tags
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
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Required help for install excel LTSC 2024 & activation
Required help for install excel LTSC 2024 & activation
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data