19,725 questions with Microsoft 365 and Office | Excel | For business | Windows tags

Sort by: Updated
2 answers One of the answers was accepted by the question author.

Trying to Sort by two different columns while using the FILTER function.

I am currently sorting by one column (see below) and it is working as needed. =SORT(FILTER('Score Calculations'!B9:Q38,('Score Calculations'!E9:E38>44)*('Score Calculations'!F9:F38>44),""),16,-1) Here is the source sheet: Here is the…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-11T16:18:10.5166667+00:00
Wright, Paul@CHP 5 Reputation points
edited an answer 2025-12-12T13:57:29.1+00:00
Dana D 0 Reputation points
1 answer

restore a calendar

I had created a calendar within office and deleted it by mistake, now I cannot alter invites associated to that calendar, can you help

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-12T13:15:50.4733333+00:00
Goodacre, Mark SUKEP-UPC/T/O 0 Reputation points
answered 2025-12-12T13:15:59.9666667+00:00
Q&A Assist
1 answer

Recover a deleted Autorecovered file

Hi, I opted to not save an auto recovered version of one of my file, and I deleted it. Is there any way I can recover the same file?

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-12T06:40:58.16+00:00
Sharique Azizi 0 Reputation points
edited a comment 2025-12-12T12:02:37.5333333+00:00
Allison-H 5,040 Reputation points Microsoft External Staff Moderator
1 answer

error'1004': We couldn't copy this sheet

After changing my laptop system language from Chinese to English, I am unable to copy worksheets in an .xlsm file that was created in a Chinese environment. Excel shows the error: If I switch the system language back to Chinese, the issue does not…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-12T08:40:10.04+00:00
Sandy 0 Reputation points
answered 2025-12-12T11:57:20.4533333+00:00
Tamara-Hu 8,635 Reputation points Microsoft External Staff Moderator
2 answers

Issue Opening Embedded Excel Object in Word Document

Hello, I am experiencing an issue when trying to open or edit an embedded Excel object inside a Microsoft Word document. When I double-click the object, Word shows the following error: “The program used to create this object is Excel. This program is…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-11T12:57:25.5433333+00:00
Amrit Kaur 0 Reputation points
commented 2025-12-12T11:39:00.3833333+00:00
Amrit Kaur 0 Reputation points
0 answers

Product deactivated warning when i am licensed

Hi, Even if my company just renewed the license, Microsoft 365 apps give warning in the attached picture. Only i am getting that warning inmy team. Here is a view from office > ofice account page: Another view from subscription page: I tried to…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-12T11:16:41.8+00:00
Elif İntizamoğlu 0 Reputation points
1 answer

Nie mogę wprowadzić zakupionego klucza licencji do Office 365 Business Standars

Kupiłem klucz licencji do Office 365 Business Standard - [Uwaga moderatora: usunięto dane osobowe] i nie mogę go aktywować

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-12T09:56:25.56+00:00
Adam Barlak 0 Reputation points
answered 2025-12-12T10:48:00.7+00:00
Henry-N 6,405 Reputation points Microsoft External Staff Moderator
2 answers

Excel has locked me out of my protected sheet when I am certain I am using the correct password.

I have an excel spreadsheet in which one of the sheets I have protected with a password. Recently I tried to access the protected sheet but it now says the password is wrong - which I know it is is not as I have accessed the sheet in the past. So i then…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-12T03:00:52.8633333+00:00
LZ 0 Reputation points
answered 2025-12-12T04:23:32.5133333+00:00
Darren-Ng 5,800 Reputation points Microsoft External Staff Moderator
4 answers

Smart View is not downloading on my machine

I have tried multiple times to download Smartview and while the download works, its not showing up on excel. I look into add-ins and its not there either. Can you please help with a proper install?

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-09T14:25:03.77+00:00
Bodiwala, Nirali 0 Reputation points
commented 2025-12-11T23:35:47.43+00:00
Bodiwala, Nirali 0 Reputation points
2 answers

How can I get Excel to import data from a site using SSO to log in?

My team has an important tool made of an Excel workbook running on a VBA script. Basically what this tool does is import data from our ServiceNow site and format it into a Word document or an Outlook email. A couple years ago, my organization pushed for…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-10T22:35:34.54+00:00
ALH 0 Reputation points
commented 2025-12-11T23:25:46.5133333+00:00
Sophie N 8,515 Reputation points Microsoft External Staff Moderator
2 answers

Copy data from cells on info sheet to cells on data sheet based on date.

20251128_141429.jpgSo, I have cycle counts on certain departments that need to be done on a weekly rotating schedule(52 weeks). I want to be able to type in "week 44" or an actual date would work, for example...and have it fill 5 rows on the…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-11-28T19:21:07.5166667+00:00
CASEY BRYANT 0 Reputation points
commented 2025-12-11T23:23:51.1733333+00:00
Hendrix-C 8,560 Reputation points Microsoft External Staff Moderator
2 answers

Editing in cell - Disable "Home" key closes cell when text first entered

This has been the default behavior forever, but my muscle memory from Word still has me struggling in Excel. I frequently use the Home key to move to the beginning of a line. In Word, it always performs that behavior the same. In Excel, if text if…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-11T17:14:39.0366667+00:00
Andrew Cecka 0 Reputation points
commented 2025-12-11T23:21:24.7366667+00:00
Hendrix-C 8,560 Reputation points Microsoft External Staff Moderator
2 answers

HOW TO CORRECT #N/A ERROR IN XLOOKUP #EXCEL

HOW TO CORRECT THE #N/A ERROR IN XLOOKUP WHEN ADDED A NEW SHEET TO A WORKBOOK WITH PRE-EXISTING WORKSHEETS

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-10T20:25:21.32+00:00
Alicia Garcia 0 Reputation points
commented 2025-12-11T23:07:16.38+00:00
Hendrix-C 8,560 Reputation points Microsoft External Staff Moderator
1 answer

insert multiple jpegpics in one 1 cell

Hi, Is there a way to insert multiple photos from jpeg files into 1 excel cell? TY

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-10T15:32:51.0933333+00:00
Therence Valdez 80 Reputation points
commented 2025-12-11T23:06:30.83+00:00
Hendrix-C 8,560 Reputation points Microsoft External Staff Moderator
3 answers

how to list names in a column in excel in a row

How can I take names listed in a column and paste them in a row?

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-11T16:19:53.3866667+00:00
Young, Kevin P 0 Reputation points
answered 2025-12-11T22:59:40.71+00:00
Ashish Mathur 100.8K Reputation points Volunteer Moderator
3 answers

This is the Result of an Excel Sort Today on the Total Column, How? Why?

ID Total 4008 $16.99 4419 ($0.27) 5067 $19.99 8365 $59.97 8680 $55.97 7325 $19.99 3322 $221.85 3166 $39.98 4270 $190.80 8275 $19.99 8282 $128.86 8208 $44.46 7436 $88.29 4112 $108.25 10790 $27.47 8121 $137.68 8524 ($0.40) 6599 $100.48…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-08T19:04:19.3933333+00:00
Glenn Harris 20 Reputation points
commented 2025-12-11T22:13:03.4366667+00:00
Hendrix-C 8,560 Reputation points Microsoft External Staff Moderator
1 answer

How to setup notifications for excel spreadsheet

Is there a way to setup to receive notifications when changes are made to an excel spreadsheet?

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-11T15:55:16.13+00:00
Moua, Vood 0 Reputation points
edited an answer 2025-12-11T21:39:08.3933333+00:00
Hendrix-C 8,560 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

EXCEL IF Formula Error for graded Supplier Performance Incentive Payments

=IF($G16<$Q16,150,IF($G16>=$P16,IF($G16<=$O16,($G16-$O16)/($P16-$O16)*100,""),IF($G16>=$Q16,($G16-$P16)/($Q16-$P16)*50+100,"")))/100 In Cell V16, is the result multiplier of Contractor Performance. Either 0%, 100%, or up…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-10T08:49:54.54+00:00
Rino Quirante 40 Reputation points
commented 2025-12-11T19:58:56.7566667+00:00
Rino Quirante 40 Reputation points
3 answers One of the answers was accepted by the question author.

Weird excel behaviour when pressing shift + arrow keys for selecting multiple cells in a column

In the microsoft excel, when i press the shift key and arrow down for multiple cells in a column, the view is kind of messing up instead of moving down as moving down the cells. NO SCREEN LOCK IS ON. Additionally, when pressing shift key and arrow up…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-10T14:42:55.5766667+00:00
Giazitzoglou Angelos 20 Reputation points
commented 2025-12-11T19:55:18.75+00:00
Hendrix-C 8,560 Reputation points Microsoft External Staff Moderator
3 answers One of the answers was accepted by the question author.

User intermittently can't open emailed Excel files on one specific computer

Good morning, I have a rather complicated issue that I'm try to fix without replacing the user's computer. This user receives emails with the same report in Excel a few times a week, but sometimes she gets the error "The operation failed". some…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-10T16:58:14.6566667+00:00
Chris Dalton 0 Reputation points
accepted 2025-12-11T19:11:06.78+00:00
Chris Dalton 0 Reputation points