57,041 questions with Microsoft 365 and Office | Excel | For home | Windows tags

Sort by: Updated
2 answers

How to SUM different cells (criteria: '>0') within a column

I have a column of 45 numbers (ranging from -100 to 100) and I need to get the SUM of 8 separate cells within that column that are '>0'. I just can't seem to get a formula to work. Every formula that I've tried gives me an error (usually a 'VALUE'…

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-03-09T18:15:03.9066667+00:00
Donald Cartin 0 Reputation points
commented 2026-03-12T22:16:47.5666667+00:00
Donald Cartin 0 Reputation points
0 answers

How to Fix Excel Keep on asking for a key

I have downloaded microsoft office. I am trying to use excel and every time i use it keeps prompting me to sign in or use a product key. I have done multiple times and am yet still unable to use excel. I tried to download office on a different device…

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-03-12T20:59:50.3566667+00:00
FYRE CRYSTAL 0 Reputation points
1 answer

Signing in to Excel

I suppose my key question is - why is it that Microsoft seems always determined to make life as difficult as possible? Don't they at some stage get bored of causing unnecessary problems? But the more specific question is - why on earth is Microsoft…

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-03-12T20:54:36.6566667+00:00
Patrick Cox 20 Reputation points
answered 2026-03-12T20:54:51.59+00:00
Q&A Assist
1 answer

unblock macro on excel file

Received an email from trusted site with excel file and macros are blocked

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-03-12T18:31:54.51+00:00
John Huggins 0 Reputation points
answered 2026-03-12T19:10:19.1433333+00:00
John Jefferson Doyon 61,635 Reputation points Independent Advisor
3 answers

Can I ask Microsoft to call me? If yes, then what is the process?

Can I ask Microsoft to call me? If yes, then what is the process?

Microsoft 365 and Office | Excel | For home | Windows
asked 2025-11-28T12:16:56.7866667+00:00
QSK637 5 Reputation points
edited an answer 2026-03-12T17:57:40.7+00:00
Don Varnau 19,745 Reputation points Volunteer Moderator
0 answers

Some Excel (.xlsx) files which open fine in Office 365 fail to open in Excel 2024 LTS (32Bit) and need to be repaired

I have certain excel (.xlsx) files which open fine in Excel 365 but not Excel 2024 LTS(32Bit) When I try open the file in 2024, I get a message saying Excel found a problem with some content and offers to recover the file. If I say yes then the…

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-03-12T17:50:24.09+00:00
Mark Stevens 0 Reputation points
edited the question 2026-03-12T17:53:35.17+00:00
Clover-L 5 Reputation points Microsoft External Staff Moderator
2 answers

Excel auto populate

Hi there, I am trying to organise a spreadsheet where column C will autopopulate with a particular word depending on the information provided in column A. For example if 'TRT' is part of the text in A2, I would like 'toast' automatically put in C2. If…

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-03-12T13:27:54.2866667+00:00
Excel Gott 0 Reputation points
answered 2026-03-12T16:55:13.3566667+00:00
IlirU 1,936 Reputation points Volunteer Moderator
2 answers

Lines across characters in the sheet in my Excel 365

Why do i have lines across all characters in Excel 365?

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-03-11T19:02:29.7766667+00:00
Ben N 0 Reputation points
commented 2026-03-12T16:46:54.03+00:00
Viorel 126.7K Reputation points
2 answers

I can't see data type option in my excel ribbon

I want to calculate the distance between zip code

Microsoft 365 and Office | Excel | For home | Windows
asked 2025-07-30T04:46:47.5066667+00:00
TARUNESH Garg 5 Reputation points
edited an answer 2026-03-12T16:20:45.3633333+00:00
Mike A 0 Reputation points
1 answer

excel column headings won't print on each page

when email excel to myself and open it the column headings won't print on each page

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-03-12T14:56:16.57+00:00
SB 0 Reputation points
answered 2026-03-12T14:56:30.5233333+00:00
Q&A Assist
3 answers

On Error statement in VBA not working

I have a macro that wants to test whether a worksheet is visible or hidden. Here is the code I am using: On Error GoTo NEXT Sheets("MyTab").Select On Error GoTo 0 ```(MyTab is visible) NEXT: (MyTab is hidden) HOWEVER, this code does not…

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-03-05T15:22:58.19+00:00
Albert Kremer 0 Reputation points
commented 2026-03-12T14:45:06.1433333+00:00
JeovanyCV 465 Reputation points Volunteer Moderator
1 answer

Clipboard used by another application

Hi, this blocked me from copy paste excel table to another application, lower down working efficiency.

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-03-12T08:50:03.09+00:00
CHEN QJ 0 Reputation points
commented 2026-03-12T12:23:17.93+00:00
Viorel 126.7K Reputation points
0 answers

Microsoft Office 2024 Excel freezes at launch

Hi All Appologise if i post this in the wrong place I just installed Office 2024 and for some reason Excel will freeze/hang/go not responding as soon as it's launched, all other programs still work as normal tried launching excel in safe mode - it still…

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-03-12T07:22:33.5833333+00:00
Walter Stibbe 0 Reputation points
commented 2026-03-12T10:28:23.06+00:00
Walter Stibbe 0 Reputation points
1 answer

please fix repairing issue in Microsoft word or excel both

when I open my excel or word within 5 minute repair box is popup and when I click on repair then automatically within two minutes my word and excel closed I have tried multiple times to repair but nothing happens how i fix this problem

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-03-12T06:03:41.47+00:00
jiya dua 0 Reputation points
answered 2026-03-12T06:49:17.3366667+00:00
DaveM121 851.1K Reputation points Independent Advisor
1 answer

excel spreadsheets are being automatically put into tmp files and disappear

Windows 11 Home excel spreadsheets are being automatically put into .tmp files and disappear. I save many times but they disappear and can't be retrieved

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-03-10T18:20:47.42+00:00
Betty Vonderohe 0 Reputation points
commented 2026-03-12T06:35:15.69+00:00
Kai-H 12,610 Reputation points Microsoft External Staff Moderator
2 answers

Unable to run excel vba macros in a file on a trusted intranet share

Have tried all suggested options but am still unable to get past "Microsoft has blocked macros from running because the source of this file is untrusted" <Learn More> which leads to steps which do not do it for me.

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-03-12T02:42:58.74+00:00
Mukesh Sundaram 0 Reputation points
answered 2026-03-12T03:31:01.6433333+00:00
Sumit D - IA 160.7K Reputation points Independent Advisor
2 answers

how to resolve: Excel ran out of resources while attempting to calculate one or more formulas.

I am working on about 14 spread sheets, I went to Formulas, kept automatic calculations (sheets are too complicated to go for manual), cannot get Excel to calculate any more. Yikes!

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-03-11T16:44:50.58+00:00
christine kelsey 0 Reputation points
edited an answer 2026-03-11T23:10:48.6666667+00:00
Katerina-N 6,775 Reputation points Microsoft External Staff Moderator
2 answers

Need tech agent by phone - March 10, 2026 Update - cannot open protected spreadsheets - tried everything

Need tech agent by phone - March 10, 2026 Update - cannot open protected spreadsheets - tried everything

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-03-11T15:40:47.6733333+00:00
JULIANNE SIMONS 0 Reputation points
edited an answer 2026-03-11T22:59:19.97+00:00
Katerina-N 6,775 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Excel - file date now large, so automatic calculation not working correctly

Is there a way to get auto calc to always work or calc when I want? Alternativily which button is used to activate manual calculation? Cannot find in help as file locks out, thanks

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-03-11T04:53:37.13+00:00
shane cundy 20 Reputation points
accepted 2026-03-11T20:39:35.3833333+00:00
shane cundy 20 Reputation points
2 answers

excel will not print

From my windows-based laptop, I cannot print any excel sheet. I can print word docs and PowerPoint docs, buy not excel.

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-03-11T16:15:43.28+00:00
Shelly Smith 0 Reputation points
answered 2026-03-11T16:59:53.0733333+00:00
Diana Mariz 6,315 Reputation points Independent Advisor