A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
20,385 questions with Microsoft 365 and Office | Excel | For business | Windows tags
excel glitch
For my job I use spreadsheets to keep track of data. When reporting this data, I save my password protected document as a new file and remove passwords via File-->Save As-->Browse-->Tools-->General Options and then I remove the password. For…
Microsoft 365 and Office | Excel | For business | Windows
Excel 365 a different cell being selected than the one clicked
Issue: In Excel for Microsoft 365, clicking on a cell occasionally results in a different cell being selected than the one clicked. The issue occurs intermittently. Workaround: Switching between worksheet tabs temporarily fixes the problem, but it…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Conditional Format By Date
Hi. i am trying to conditional format column D of my spreadsheet based on how many days have passed from the date in the cell. E.G. Cell D3 has 18/3/26 in it so i would want that to be filtered orange but cells with more recent dates would be green.
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Excel changed link location
I have a workbook with hundreds of links. Recently Excel changed all of these links to read from C:\user\myname\roaming.........andonandon. The file names are the same but as the files don't exist in this location, this broken all the links. My…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Formulas not supported anymore
Hi, My office version is Microsoft Office Professional Plus 2021. On my Excel files, I have used the formula XLOOKUP. Since today (2026-04-08), I do not know what happened, but this formula now have a "xlfn." as a prefixe and can't use it…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Who do I ask, Microsoft, SharePoint, Excel Online experts, OneDrive....?
I have a large Excel Online file that about 20 people use daily. I created this from scratch, and its been working for about 2 years without any problem. Multiples use/edit/share from it daily. It seems today I lost the Automate top menu tab/button, of…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Interactive dashboard for the data
want to create an interactive dashboard. this is an example of data and the line can go upto 100000 lines. We currently present with values, now looking to present in terms of graphical presentations with following Flux: a Month on Month : Say, if we…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
VBA code needed for matching 3 columns of data in 2 worksheets with 2 anomalies
Hello, I was wondering if someone could help with some VBA code for the following I have 2 worksheets each with 3 columns of like data in Column A, B, C and the data is from 2 different sources but is supposed to be the same. I need to find the Project,…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
How to get Word & Excel to Forget Old Sharepoinnt Sites
Hi, When searching for a file in Word & Excel it sometimes comes up with old Sharepoint folders for clients who i haven't worked for in over 6 years. I have tried all the fixes that the internet suggest but not of them work. Being 6 years old they…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
#UNKNOWN! error
In excel, document prepared by another person in our organization, clipped picture which is set in excel by inserting fit in cell shows #UNKNOWN! when I open the doc. We both have latest 365.
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
How to recognize strike-through text in Microsoft Excel?
I would like to add a column in a table to recognize cells with strike-through text. #Excel #strike-through text
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
When I click the Copilot icon in my Excel the underlying menu is empty
The user has a co-pilot license. It suddenly turn in to empty suggestion. I have done this so far check Essential File & Storage Fixes Verify Account and License Update and Check Channel Enable Privacy Settings Clear Cache and Restart repair…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Return to blank #N/A in Excel vlookup
How do I return #N/A to Blank in VLOOKUP in Excel below formula i used =(VLOOKUP(@$E$7:$E$105,'2025 Material'!$A$2:$E$21,5,FALSE)/VLOOKUP(@$E$7:$E$105,'2025 Material'!$A$2:$E$21,4,FALSE))*H7
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
I am trying to use the AND function with structured references and keep getting errors. I have tried everything in the help notes and I continue to get the same errors.
I am trying to use the AND function with structured references and keep getting errors. I have tried everything in the help notes and I continue to get the same errors.
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
New Excel windows open a little lower
Is there a way to get new Excel windows to open at the top of the screen, like every other app? I have to go looking for them, drag them to the top, and that weird (and unhelpful) window positioning tool pops out of the top of the screen to confound my…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Excel formulas disappearing when selected with live data?
I have a basic spreadsheet with some live RTD data links. I believe the links are the issue as sheets that do not update or recalculate don't have any issues. I noticed that if I select a cell, after a few seconds, the formula filed switches from showing…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Password Protecting/Locking Specific Cells in a Spreadsheet (some but not all)
Hello community! I am stuck on a problem locking some, but not all of the cells (columns) in my excel spreadsheet. It is a tracker and we want the general staff to be able to access the first set of columns so they can input data. For the second part of…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
How to move data from one row to another withing the same column
How can I move the data in one column and one row to the next row withing the same column?
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Excel 2024 version change
2025年6月にExcel2024 MPSAを購入し、当時はダウングレードしてExcel2019で使用しておりましたが、Excel2021にする必要があり、Excel2019をインストールしたPCをExcel2019を削除して、Excel2021に入れなおすことはライセンス的に問題ありますか。 購入したExcel2014の内容 商品コード:[モデレーター注:個人情報は削除しました] 商品名Excel [モデレーター注:個人情報は削除しました] 移動元: Microsoft 365 と Office |…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Windows shortcut Ctrl + + or - is not working in specific file.
There is no protection in sheet,file or cells. Windows 11 and excel version LTSC pro plus 2024. shortcut only doesnot working in one file. Other files is ok. File is not shared,protected or having macro. Could you please help me identify the cause and…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data