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

Sort by: Updated
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,665 Reputation points Microsoft External Staff Moderator
2 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
answered 2026-04-07T22:03:17.7466667+00:00
Hendrix-C 13,665 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 0 Reputation points
commented 2026-04-07T21:18:50.0766667+00:00
Hendrix-C 13,665 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,665 Reputation points Microsoft External Staff Moderator
2 answers

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
answered 2026-04-07T15:41:20.5633333+00:00
Henry-N 11,650 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,300 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,575 Reputation points Microsoft External Staff Moderator
1 answer

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
edited an answer 2026-04-07T15:10:23.5666667+00:00
Helen Luu 250 Reputation points Independent Advisor
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
commented 2026-04-07T13:42:00.0233333+00:00
Jay Jones Garlejo 20 Reputation points
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
浅田 隆二 20 Reputation points
edited an answer 2026-04-07T13:13:08.4566667+00:00
浅田 隆二 20 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,575 Reputation points Microsoft External Staff Moderator
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
answered 2026-04-07T07:49:44.4233333+00:00
Tamara-Hu 13,300 Reputation points Microsoft External Staff Moderator
3 answers One of the answers was accepted by the question author.

ADDING TOTAL HOURS AND MIN WORKED FOR A MONTH IN AN EXCEL COLUMN

EXCEL CALCULATING WORK HOURS: How do I work with excel on calculating total hours and minutes worked in a month? Do I need to format the columns on: START TIME/END TIME . HOW TO CALCULATE THE HOURS AND MINUTES WORKED PER DAY. HOW TO CALCULATE THE…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-04-06T02:42:27.7633333+00:00
ANGELIQUE LARET 20 Reputation points
commented 2026-04-06T23:32:20.18+00:00
Huy-K 10,695 Reputation points Microsoft External Staff Moderator
2 answers

update excel to latest riyal symbol (saudi arabian currency) released 2025

The currency symbol in my Microsoft 365 Excel for Saudi Arabian Riyal (SAR) is the old version. The approved version is ⃁ written before the number, not ر.س.‏ written after it. The central bank had requested Microsoft make the new currency symbol…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-04-06T21:56:06.8+00:00
Wendy Boustani 0 Reputation points
answered 2026-04-06T22:47:47.4333333+00:00
Hendrix-C 13,665 Reputation points Microsoft External Staff 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-06T16:26:05.2733333+00:00
Hendrix-C 13,665 Reputation points Microsoft External Staff Moderator
3 answers

Conditional Formatting regarding expiry dates

Hello All :) I am working on a training matrix for all our employees in Excel. I would like to use some conditional formatting on all the dates. For example, I would like to highlight expiry dates within the next three months And highlight expired…

Microsoft 365 and Office | Excel | For business | Windows
asked 2024-01-18T17:14:27.11+00:00
Nicola Eades 0 Reputation points
commented 2026-04-06T14:36:26.1666667+00:00
JOSH 92 0 Reputation points
2 answers

overwritten file of excel

dear, i replaced my original file with the old file i want that actual file now i am getting 6 month old data and i cant see any date of yesterday for restore pls. help how to get tht current data this i did today

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-04-01T11:53:32.8566667+00:00
H L Jain 0 Reputation points
commented 2026-04-06T14:16:48.06+00:00
Nam-D 3,395 Reputation points Microsoft External Staff Moderator
2 answers

“Excel worksheet cells and gridlines not visible when opening a workbook”

Hello Community, I’m facing an issue where Excel cells are not displaying properly (grid/cells not visible even though the file opens). I’ve tried basic troubleshooting, but the problem still persists. Requesting your guidance or any known resolution…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-04-03T02:54:13.38+00:00
Anuj Kumar Singh 0 Reputation points
commented 2026-04-06T13:12:15.02+00:00
Vivian-HT 14,945 Reputation points Microsoft External Staff Moderator
2 answers

I can't open an excel file I created because I don't have permission..

I created an Excel file back in 2022 in a shared network and added restricted access so only me and another person could edit it and everyone else could open it in read-only mode. The file has been blocked for a couple of days now and now no one can…

Microsoft 365 and Office | Excel | For business | Windows
asked 2023-07-11T18:23:09.9766667+00:00
Francisco 0 Reputation points
commented 2026-04-05T23:11:27.9733333+00:00
Judy PMSI 0 Reputation points
3 answers

cannot share or save as pdf when connected to the internet on excel

I am able to share as pdf or save as pdf when not connected to the internet, and when connected it freezes everything up and I get the spinning wheel. I've tried 2 different connections, and still having the same problem. Seems like there is no hiccup…

Microsoft 365 and Office | Excel | For business | Windows
asked 2026-04-02T21:56:36.8566667+00:00
Travis Toller 0 Reputation points
commented 2026-04-03T20:31:26.67+00:00
Ryan-N 11,875 Reputation points Microsoft External Staff Moderator