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

Sort by: Updated
1 answer

Excel generates odd reference when a formula in one sheet refers to a cell in another sheet iin the same workbook

Case: Multiple sheet workbook A summary sheet (which has panes frozen) formula generated by clicking on the referenced workbook and cell refers to cell AJ2194 in another sheet which has panes frozen at B2. When I double-click on the cell in the summary…

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-10-04T03:11:26.09+00:00
Al Waschka 5 Reputation points
answered 2026-10-04T07:33:24.8833333+00:00
Hendrix-V 19,485 Reputation points Microsoft External Staff Moderator
1 answer

Excel Desktop chart selection issue – 2 data points do not show selection handles

I am experiencing a chart selection issue in Excel Desktop. I have a column chart with a Target series containing 18 data points. When I select the Target series in Excel Desktop, 2 data points do not display the selection handles, even though they are…

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-10-03T16:15:15.3766667+00:00
Moustafa Cherif 0 Reputation points
answered 2026-10-04T06:37:32.9166667+00:00
riny 21,520 Reputation points Volunteer Moderator
2 answers

Data in power uqry does not updated when source file cahnges its data

DATA IS FAKE & NOT REAL --> ONE EXAMPLE ONLY There is one pronlem-- The souce file have data having array formula like which is a short tabular data (i named is as FINAL FILTER containg data from cell C13 to E935)…

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-10-01T08:30:03.33+00:00
Chaturvedi, Santosh 450 Reputation points
answered 2026-10-04T06:26:44.67+00:00
Thomas4-N 22,380 Reputation points Microsoft External Staff Moderator
2 answers

Recent problem saving Excel 365 files due to (purported) file sharing issues (no file sharing has been knowingly established)

I have two larger additional monitors attached to my Windows laptop PC for visual purposes. One monitor mirrors the laptop and the second monitor is independent. When opening and updating an Excel 365 spreadsheet residing on Onedrive via the independent…

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-10-01T22:45:56.46+00:00
Bob Thomas 0 Reputation points
commented 2026-10-04T05:36:11.3433333+00:00
Hendrix-V 19,485 Reputation points Microsoft External Staff Moderator
1 answer

windows PC, excel not opening properly. displays white screen and tabs behind tabs.

“Excel is not opening properly. When I open any workbook or a new file, Excel shows a large white screen and only a Sheet1 tab in front, with an endless series of alphabetic tabs behind it. My data appears in Print Preview, but not in the normal grid…

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-10-04T02:04:51.9666667+00:00
Peter Massos 0 Reputation points
answered 2026-10-04T02:50:11.25+00:00
John DeV 170.4K Reputation points Independent Advisor
3 answers One of the answers was accepted by the question author.

Excel Substitutions

In col A, I have old1 old2 old3 ... In col B, I have new1 new2 new3 ... In D1, I have: =substitute(C1,A1,B1) so that text entered in C1 is shown in D1 with old1 substituted by new1. But, for that single cell C1, I want to apply every listed sub. E.g.,…

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-09-29T18:07:20.93+00:00
Richard Tillman 405 Reputation points
commented 2026-10-03T23:21:30.5733333+00:00
Richard Tillman 405 Reputation points
2 answers

COMO RECUPERAR MI CLAVE PARA ACTIVAR OFFICE

Debido a que robaron mi pc no tengo la clave para la activación del office, en el computador que adquirí después inicie mi sesión de Microsoft y me estaba funcionando normal pero recientemente me pide cambiar la clave del producto y no se como hacer eso

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-02-24T13:49:38.2966667+00:00
commented 2026-10-03T17:50:05.7233333+00:00
daniskaa 123 0 Reputation points
4 answers

Since this weekend the formatting goes away in my old .xls files

MS Excel 2019. Since college in 1997, I have been a user of MS Excel. You changed something in Excel. I always saved my files in .xls so they would be compatible with my old computer that is not online. Since this weekend: I open a spreadsheet and make…

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-09-22T11:53:36.6966667+00:00
Warren R 0 Reputation points
edited an answer 2026-10-03T13:20:26.15+00:00
Warren R 0 Reputation points
3 answers One of the answers was accepted by the question author.

My banned account and microsoft excel.

I got banned for no reason and now i unbanned my self but for somereason microsoft excel is not allowing me in it keeps saying 'Please sign in again Please wait a few minutes and then sign in again to access your documents." it is really annoying.…

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-10-02T03:30:53.3233333+00:00
Eeshan Gupta 25 Reputation points
accepted 2026-10-03T02:20:30.6766667+00:00
Eeshan Gupta 25 Reputation points
0 answers

Microsoft stopped me using my Office 2019 program today.

I have had a legitimate licensed copy of Office 2109 since 2021, today (Oct 2, 2026) Microsoft stopped giving me access to the programs.Can you help me to find my product key as that is what they are asking for? Thank you

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-10-02T22:58:53.5566667+00:00
B2B PRO 0 Reputation points
commented 2026-10-03T00:26:29.41+00:00
B2B PRO 0 Reputation points
5 answers

Print from excel

I can't print whole page from excel only prints heading.

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-09-27T00:20:37.1233333+00:00
Jenny Craw 0 Reputation points
commented 2026-10-02T14:37:12.3266667+00:00
Thomas4-N 22,380 Reputation points Microsoft External Staff Moderator
1 answer

The Excel Stock tool doesn't return the proper data

The Excel Stock tool doesn't return the proper data for the Berkshire Hathaway stock symbol, BRK.B, trading on the NYSE

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-10-01T18:32:39.3966667+00:00
Mark Weisman 0 Reputation points
commented 2026-10-02T13:30:45.23+00:00
Mark Weisman 0 Reputation points
1 answer

I bought MS/Office on 6/15/2023 as a lifetime subscription and can't log on

I have the invoice here and when I go to find any product key or subscription online it tells me I have a subscription that ran out in 2025! and wants me to upgrade. What do I do and how can I get on? UP until today have been running Word and Excel…

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-10-02T12:43:54.25+00:00
Tzvi Yisrael 0 Reputation points
answered 2026-10-02T13:18:42.13+00:00
DaveM121 936.6K Reputation points Independent Advisor
3 answers

How to copy without hidden lines

I am trying to copy visible cells only to another worksheet. I have done the go to special and selected visible cells only, but it still copies the hidden cells. I am trying to filter columns. When I filter by one column, it unfilters another column.…

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-05-21T00:57:54.2133333+00:00
Vickie Leon 0 Reputation points
answered 2026-10-02T09:31:21.9833333+00:00
Simão, Tiago 0 Reputation points
2 answers

Undo rounding in spreadsheet cells

Some cells in my spreadsheet show rounded numbers but I am unable to undo this function. The cell is large enough to accept to accept the number function with 2 decimel places.

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-10-02T01:52:34.5133333+00:00
Ron Coleman 0 Reputation points
answered 2026-10-02T02:38:21.4333333+00:00
TaoLi 114K Reputation points Independent Advisor
2 answers

Fix error and repair now

When I open my excel spreadsheet a message comes up saying excel has run into an error and has to close. Would you like us to repair it now? I click on repair now and can work in the spreadsheet, but the message still comes up every time I open excel. …

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-10-01T22:27:45+00:00
Linda Breeden 0 Reputation points
answered 2026-10-01T23:02:09.5+00:00
John Jefferson Doyon 88,900 Reputation points Independent Advisor
3 answers One of the answers was accepted by the question author.

I have an error message saying Your organization's administrator turned off the service required to use this feature.

I have an error message saying Your organization's administrator turned off the service required to use this feature. I am working in Excel. I have a Microsoft Family Plan. Can I change my plan so I am the administrator?

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-09-29T18:07:38.7966667+00:00
Douglas Hupp 40 Reputation points
accepted 2026-10-01T22:10:21.02+00:00
Douglas Hupp 40 Reputation points
2 answers One of the answers was accepted by the question author.

Convert text to number in Excel

Data in a range is marked with a green triangle to indicate that it's text - it's been exported from another application. When I select the cells, I expect a function to appear alongside the top left cell to 'convert text to numbers' but the function is…

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-09-16T17:57:09.0466667+00:00
Richard Curtis 100 Reputation points
accepted 2026-10-01T15:36:42.71+00:00
Richard Curtis 100 Reputation points
2 answers

You've reached your limit for today

I have an active Microsoft 365 Family subscription. Copilot works in Word and at copilot.microsoft.com. Excel Copilot displays "You've reached your limit for today" in both Excel Desktop and Excel for Web. The issue has persisted for more than…

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-09-26T09:12:13.5+00:00
ASHISH SHAH 0 Reputation points
commented 2026-10-01T14:12:41.72+00:00
Thomas4-N 22,380 Reputation points Microsoft External Staff Moderator
2 answers

How to evaluate Excel formulas step by step instead of only final result?

I am working with Microsoft Excel and often deal with complex formulas involving multiple nested functions. The issue I face is that Excel usually gives only the final result, and it becomes difficult to debug where the mistake is happening. I know about…

Microsoft 365 and Office | Excel | For home | Windows
asked 2026-08-31T14:58:46.8033333+00:00
alkohi 0 Reputation points
edited an answer 2026-10-01T13:24:19.8466667+00:00
alkohi 0 Reputation points