3,297 questions with Microsoft 365 and Office | Excel | Other | Windows tags

Sort by: Updated
3 answers

Microsoft Excel 2016 Crashes When I Try to Change the Font

I have Microsoft Professional Plus 2016 and I know that it was phased out by Microsoft. I do not want an online Office 365. Anyway, all of a sudden, it started to crash every time I tried to change the font in an Excel spreadsheet. Please advise.

Microsoft 365 and Office | Excel | Other | Windows
asked 2025-12-04T22:15:21.42+00:00
Rachel 0 Reputation points
answered 2025-12-04T23:00:58.9133333+00:00
Manoel Barros 16,265 Reputation points Independent Advisor
2 answers

I have a text cell one the first sheet of a workbook (Time Card) that i want to show up on the last sheet (WK), I tried =if('Time Card'!E6"","",'Time Card'!E6) the formula shows up

its a memo field i need to show up on the other sheet. Moved from: Microsoft 365 Insider | Excel | Windows

Microsoft 365 and Office | Excel | Other | Windows
asked 2025-12-04T16:05:32.51+00:00
Bill Tregunna 0 Reputation points
answered 2025-12-04T21:28:40.85+00:00
Francisco Montilla 23,935 Reputation points Independent Advisor
2 answers

An _xlfn. prefix is displayed in front of a function in a formula. When the formula is calculated, it displays the #NAME? error value.

An _xlfn. prefix is displayed in front of a function in a formula. When the formula is calculated, it displays the #NAME? error value.

Microsoft 365 and Office | Excel | Other | Windows
asked 2025-12-04T14:53:39.6766667+00:00
_Deni 0 Reputation points
answered 2025-12-04T15:29:28.0066667+00:00
DaveM121 810.4K Reputation points Independent Advisor
1 answer

How to fix my Ms ecxel

why my ms excel is not responding? its showing me to repair.

Microsoft 365 and Office | Excel | Other | Windows
asked 2025-12-04T07:11:19.8333333+00:00
fazil monangat 0 Reputation points
answered 2025-12-04T07:46:13.4733333+00:00
DaveM121 810.4K Reputation points Independent Advisor
1 answer

How to fix this error #CALC! in excel

Help me fix this error in the below formula. Objective is to extract individual barcode numbers and list all the barcode numbers.

Microsoft 365 and Office | Excel | Other | Windows
asked 2025-12-04T00:29:07.6766667+00:00
Jane Nguyen 0 Reputation points
answered 2025-12-04T01:47:26.09+00:00
Randy Baroja 18,655 Reputation points Independent Advisor
3 answers

Excel - rows too narrow to see

We have an excel spreadsheet that has worksheets that has rows which are too narrow to see - you can see that the row numbers skip numbers. These hidden rows have data in them (very similar to the rows above/below) I can manually pull down the rows to…

Microsoft 365 and Office | Excel | Other | Windows
asked 2025-12-03T11:00:49.48+00:00
Susan Watkins 0 Reputation points
answered 2025-12-03T14:11:27.04+00:00
Edward Schlobohm01 9,070 Reputation points Independent Advisor
2 answers

How to fix Excel automatically closing

Hi, Why does my excel close automatically upon copy or pasting some text using ctrl + c or ctrl + v? Thanks

Microsoft 365 and Office | Excel | Other | Windows
asked 2025-12-03T06:52:41.47+00:00
De Leon, Rizzalyn 0 Reputation points
answered 2025-12-03T07:28:07.1333333+00:00
DaveM121 810.4K Reputation points Independent Advisor
2 answers

how to fix a notice Unlicensed Product notice

I keep getting a notice of an Unlicensed Product and cant use excell any more. Moved from: Windows for home | Previous Windows versions | Performance and system failures

Microsoft 365 and Office | Excel | Other | Windows
asked 2025-12-02T20:58:38.28+00:00
Tom Gregan 0 Reputation points
answered 2025-12-02T21:51:03.3366667+00:00
EmilyS726 184K Reputation points Independent Advisor
2 answers

how to fix Microsoft 365 error

excel showing error in running , may be 365 I have important documents in it

Microsoft 365 and Office | Excel | Other | Windows
asked 2025-12-01T13:59:17.9366667+00:00
Nisha Chhatri 0 Reputation points
answered 2025-12-01T14:42:48.5166667+00:00
Edward Schlobohm01 9,070 Reputation points Independent Advisor
4 answers One of the answers was accepted by the question author.

move cursor using vba code

I have previously used ACTIVECELL.OFFSET(x) to move the cursor around but that method has a disadvantage. I believe it simply amends the Ry,Cy by moving the cursor to Ry+x,Cy e.g. from R1C1 to R2C1. Strictly speaking this is amending the active cell…

Microsoft 365 and Office | Excel | Other | Windows
asked 2025-12-01T09:59:19.5366667+00:00
Foulds Andy 20 Reputation points
commented 2025-12-01T10:39:56.5933333+00:00
Foulds Andy 20 Reputation points
1 answer

setting the function language in Excel

Hello. We ask for help in setting up the language of the functions, unfortunately we cannot do this ourselves. scr lang.png The language of the function should be displayed in the same way as the interface language. thanks Moved from: System Center…

Microsoft 365 and Office | Excel | Other | Windows
asked 2025-11-28T11:30:29.0033333+00:00
Рівне техгаз 0 Reputation points
answered 2025-11-28T13:12:48.7466667+00:00
Jhun Buala 2,410 Reputation points Independent Advisor
2 answers

excel to outlook

how to copy data from excel and paste in the outlook email

Microsoft 365 and Office | Excel | Other | Windows
asked 2025-11-28T05:29:29.27+00:00
edited the question 2025-11-28T12:38:51.73+00:00
Gérard Oomens 113.2K Reputation points Volunteer Moderator
1 answer One of the answers was accepted by the question author.

Excel: Index/ match across multiple tabs using headings from a row to search tab

I am using the index/ match function to pickup data from different tabs to draw the data into a summary tab, however I have a data set with lots of tabs and would like to automatically search the tab based on the heading in the summary tab. So looking at…

Microsoft 365 and Office | Excel | Other | Windows
asked 2025-11-27T22:17:53.05+00:00
Chris 20 Reputation points
accepted 2025-11-28T03:03:17.37+00:00
Chris 20 Reputation points
4 answers

Excel missing 1 function, a small one but important

In the latest version of Excel, the subtotal function was given a small change when it was Bold face the selection you did in the subtotal. However there is one piece of that missing. The bolding of all the information on that line. If that was added…

Microsoft 365 and Office | Excel | Other | Windows
asked 2025-11-27T16:52:45.54+00:00
martin shaff 0 Reputation points
commented 2025-11-27T19:48:20.96+00:00
martin shaff 0 Reputation points
1 answer One of the answers was accepted by the question author.

How to write criteria in the SUMIFS function to evaluate a date range

👋 Column A has date values. Column B has numbers. Want to sum those numbers between two dates. If the end date is in cell C1, and I want to sum values for the week ending on that date, looking for the correct criteria1 and criteria2 in the below…

Microsoft 365 and Office | Excel | Other | Windows
asked 2025-11-25T02:55:00.0866667+00:00
gh 20 Reputation points
accepted 2025-11-25T14:49:26.8866667+00:00
gh 20 Reputation points
2 answers

Hi Team, greetings, how can I fix a #N/A error for index match formula in Excel?

I am receiving an # N/A error while using an index match formula, seems to be a format issue but I can find it nowhere.

Microsoft 365 and Office | Excel | Other | Windows
asked 2025-11-24T18:14:54.8966667+00:00
Gustavo Jimenez 0 Reputation points
commented 2025-11-25T02:24:01.62+00:00
Barry Schwarz 4,786 Reputation points
2 answers

Do you have any suggestions on how to deactivate the old device if I reinstall Windows?

Do you have any suggestions on how to deactivate the old device if I reinstall Windows? I encountered a problem with duplicate SID due to cloning, so I need to reinstall Windows. How can I deactivate the old device before reinstalling?"

Microsoft 365 and Office | Excel | Other | Windows
asked 2025-11-24T06:25:56+00:00
doa0002 doa0002 0 Reputation points
answered 2025-11-24T07:01:42.49+00:00
DaveM121 810.4K Reputation points Independent Advisor
2 answers

Excel formula help

Having issues getting an excel formula to work. Across two sheets within a register, I need to match rows (Column B3:B235 and Column B3:B235 in Sheet 2 ('Risks') in a formula in a cell in Sheet 1 (to be drag down so calculations occur for all business…

Microsoft 365 and Office | Excel | Other | Windows
asked 2025-11-24T01:51:16.98+00:00
RE 0 Reputation points
answered 2025-11-24T06:15:32.2466667+00:00
Barry Schwarz 4,786 Reputation points
1 answer

excel not working

we are sorry, but excel has run in to an error that is preventing i from currently, excel will need to closed as a result.

Microsoft 365 and Office | Excel | Other | Windows
asked 2025-11-24T02:48:07.0466667+00:00
Rahul Vishwakarma 0 Reputation points
answered 2025-11-24T03:22:56.0333333+00:00
Ferdinand Nanalig 25,925 Reputation points Independent Advisor
1 answer

In excel/vba/userform, i wish to add a spreadsheet control. i cannot find it. what do i need to do so that i can select it?

I do not find the spreadsheet control in the Toolbox. What should I do so that it gets included. Thanks.

Microsoft 365 and Office | Excel | Other | Windows
asked 2025-11-21T16:55:06.6866667+00:00
JV Krishna 0 Reputation points
answered 2025-11-21T17:29:51.1466667+00:00
JC 6,540 Reputation points Independent Advisor