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

Sort by: Updated
2 answers

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
asked 2026-04-08T14:37:32.46+00:00
Jessica McGahan 0 Reputation points
commented 2026-04-09T15:27:54.0733333+00:00
Jessica McGahan 0 Reputation points
3 answers

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
asked 2026-04-08T13:13:07.9433333+00:00
Neudecker, Sebastian 0 Reputation points
edited a comment 2026-04-09T14:05:56.5466667+00:00
Julie Huynh 740 Reputation points Independent Advisor
3 answers One of the answers was accepted by the question author.

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
asked 2026-04-07T13:50:29.86+00:00
Ben Foubister 40 Reputation points
accepted 2026-04-09T13:15:21.8966667+00:00
Ben Foubister 40 Reputation points
1 answer

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
asked 2026-04-08T14:11:00.0266667+00:00
Ben Mawson 0 Reputation points
commented 2026-04-09T11:07:08.55+00:00
Ben Mawson 0 Reputation points
2 answers

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
asked 2026-04-09T02:09:39.2433333+00:00
Marcos S. Mendez, CPA 0 Reputation points
edited an answer 2026-04-09T03:57:03.17+00:00
Jade Ng 10,495 Reputation points Microsoft External Staff Moderator
3 answers

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
asked 2026-04-07T21:03:03.6433333+00:00
BrainStain00 5 Reputation points
edited a comment 2026-04-08T23:10:19.8833333+00:00
Hendrix-C 13,915 Reputation points Microsoft External Staff Moderator
2 answers

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
asked 2026-04-08T18:49:59.4333333+00:00
Abdul Razack 0 Reputation points
commented 2026-04-08T22:44:13.4066667+00:00
Ashish Mathur 101.7K Reputation points Volunteer Moderator
2 answers

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
asked 2026-04-02T21:03:31.1066667+00:00
BudZ 141 Reputation points
commented 2026-04-08T20:49:47.0266667+00:00
Hendrix-C 13,915 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

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
asked 2026-04-07T12:36:17.32+00:00
Darren Male 20 Reputation points
commented 2026-04-08T14:36:04.16+00:00
Helen Luu 405 Reputation points Independent Advisor
1 answer

#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
asked 2026-04-07T06:30:50.96+00:00
Minna Lahtinen 0 Reputation points
commented 2026-04-08T13:46:57.79+00:00
Tamara-Hu 13,305 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2026-04-08T10:33:01.08+00:00
Yoboua Jean-Jacques 0 Reputation points
answered 2026-04-08T12:03:37.78+00:00
Marcin Policht 85,255 Reputation points MVP Volunteer Moderator
3 answers

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
asked 2026-03-23T11:57:49.8033333+00:00
Jay Jones Garlejo 20 Reputation points
edited an answer 2026-04-08T07:44:39.4333333+00:00
Alina Le 1,065 Reputation points Independent Advisor
1 answer One of the answers was accepted by the question author.

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
asked 2026-04-08T06:23:53.5566667+00:00
Orlando S. Jimenez 20 Reputation points
answered 2026-04-08T06:43:10.6566667+00:00
Vivian-HT 15,025 Reputation points Microsoft External Staff Moderator
2 answers

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
asked 2026-04-06T18:54:28.7966667+00:00
Coffman, Brandi [HHS] 0 Reputation points
commented 2026-04-07T22:07:27.58+00:00
Hendrix-C 13,915 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

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
asked 2026-04-07T18:13:15.9433333+00:00
Guthrie, James 20 Reputation points
commented 2026-04-07T21:18:50.0766667+00:00
Hendrix-C 13,915 Reputation points Microsoft External Staff Moderator
2 answers

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
asked 2026-04-07T17:53:59.06+00:00
Michael Elkin 0 Reputation points
answered 2026-04-07T20:53:15.7933333+00:00
Hendrix-C 13,915 Reputation points Microsoft External Staff Moderator
2 answers

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
asked 2026-04-06T12:33:09.41+00:00
Megan Pérez 0 Reputation points
edited an answer 2026-04-07T15:23:20.12+00:00
Tamara-Hu 13,305 Reputation points Microsoft External Staff Moderator
2 answers

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
asked 2026-04-04T13:07:26.58+00:00
Ed Gonzalez 0 Reputation points
commented 2026-04-07T15:14:20.86+00:00
Jess-Q 9,585 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2026-03-26T00:07:40.6666667+00:00
浅田 隆二 0 Reputation points
edited an answer 2026-04-07T13:13:08.4566667+00:00
浅田 隆二 0 Reputation points
2 answers

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
asked 2026-04-06T07:27:56.0866667+00:00
Farid S. Isgandarli 0 Reputation points
commented 2026-04-07T09:36:06.01+00:00
Rin-L 17,650 Reputation points Microsoft External Staff Moderator