19,725 questions with Microsoft 365 and Office | Excel | For business | Windows tags
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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…