A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
20,652 questions with Microsoft 365 and Office | Excel | For business | Windows tags
Excel 365 Desktop version crashes when opening files directly from Edge
Hi Team, Currently, on my organization's laptop, I am using the M365 application. I frequently use the Excel 365 application. I have observed that many a times the Excel 365 application crashes and only shows the blank screen without the cells and the…
Microsoft 365 and Office | Excel | For business | Windows
How To Copy / Paste Multiple Data "Blocks" Using Paste Special / Transpose - Need Advice
Hello, Excel Community... I've got a situation that hopefully someone can direct me on. The scenario: Column A represents 2 lines (in this test) from a 3rd-party program - hence, two "data blocks" for lack of a better term. For each line /…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
how can is stop security blocks from my excel
secu security risk is blocking me from doing some work so i work like to remove it or stop it
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Filter formula with address of range data
I want to link the address in of sheet by one cell in following filter formula =FILTER( 'Q:\Presentations\PE_31\O_Analysis and calculation\Fatigue[DB_Data_Collectives_1.xlsx]3365'!TABLE_S3365, (BYROW( 'Q:\Presentations\PE_31\O_Analysis and…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Hyperlink the address from one work book tpo other in excel
Hello I have requirement as mentioned below.. I have one work book sheet with list of hyperlinked cell in one table. This hyperlinked table shown above is copied and pasted in separate work book excel sheet. shown below In this work book i have…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Remove "Quick Access" Locations in Open
How do I remove "Quick Access" locations from the left pane of Excel's Open dialog box? I know how to pin locations, but my favorites only appear in 'Show More,' where pinning isn't an option.
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
How do I turn off speak cells in Excel?
The Speak Cell on Entry and Stop Speaking buttons will not turn it off.
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
VLOOKUP trolls me in work
Hi folks, I am doing data analysis (massive one) using VLOOKUP thru multiple files, the file was saved under company One Drive. I completed the analysis on 6:22pm and my superior access the file on 9:38pm later on her laptop. She feedback to me that the…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
hyperlinks in excel
how do i enable hyperlinks in an excel spread sheet.
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
every excel open read only
when some share me excel file then in my excel showing read only whenever sender already given access to me for edit. i reinstalled the office and repair the office. also i reinstall the os win 11 25 h2. however i facing same issue please guide how to…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
#VALUE! error in excel when trying to find the difference between 2 date/time cells
Hello, I am trying to calculate the work duration (in mins) for a job. The following snippet shows selected rows for Cols K:M. The formula in Col K & L are using text and concat functions to create a date and time cell. Col M is simply calculating…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
How to format data in a formula bar for Concatenate in MS Excel
How to format data in a formula bar for Concatenate in MS Excel E.g. ?
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Excel does not copy images when moving sheet to another workbook
I spent some time today creating some annotated images in Excel. I was worried I would lose the work I had done so I dragged the sheet into an existing workbook to save it there. Once I had moved it, the images and annotations I had made on them using…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Matching index to populate value
I am having issues on my formula for Column A. I want the column to return yes if there is a value in the intersect of I2:H5, return no if there is no values (cell blank), and return N/A if the match doesn't exist. Cell A5 is returning yes, but the…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Microsoft blocking Excel macros
"Microsoft" has suddenly decided to block macros on all my Excel files -- files that I created! I've tried every fix suggested by the Microsoft website and Chat GPT. Nothing is working!
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
How to Fix Issues with Sensitivity Labels Applied to Macro-Enabled Excel Files on Windows 11 After a Windows Update?
We applied sensitivity labels to macro-enabled Excel files in April, and they worked without issues initially. However, after a Windows update, some devices began freezing, causing users to experience problems while working with these files. Till now we…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Dupicate sheet with new name which is as per master list.
Hello -- There is one requirement that i have to duplicate this sheet 30 times criteria as shown below.. I have to duplicate this sheet S1....> 30 times. The content of S1 sheet shall remain same for all 30 sheet The name of the new sheet shall be…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Automatically making individual tables in Excel
Hi there, Below (Image 1) is a draft excel spreadsheet with random figures that I generate from the payroll system at work. Is there a way to automatically create a table for each employee that is formatting like 'Image 2'? Image 1: Image 2: …
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Run-time error '1004': Application-defined or object-defined error
Open Excel and it said: Run-time error '1004': Application-defined or object-defined error Please help solve this.
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
The "Total Row" within the "Table Design Options" box is greyed out and not clickable.
I am requesting urgent help with the table design tab for my work project. For the past several days, I have tried to go online, use so forth to figure out why the "Total Row" within the "Table Design Options" box is greyed out and…
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data