130 questions with Microsoft 365 and Office | Excel | For business | Android tags

Sort by: Updated
Updated Created Answers
1 answer One of the answers was accepted by the question author.

how do i fix this problem 'you cannot add cells because the last row or column contains formulas or formatting blocking' - i have tried going to the last row and column and clearing contents

I have a spread sheet that i am trying to re - format and add columns to upon attempting to insert a cut column this message appears you cannot add cells because the last row or column contains formulas or formatting blocking that are blocking new…

Microsoft 365 and Office | Excel | For business | Android
asked 2025-07-31T04:00:42.23+00:00
Carla Denham 20 Reputation points
accepted 2025-08-04T21:51:12.39+00:00
Carla Denham 20 Reputation points
1 answer

Unable to scroll in Excel mobile Android

Since the last few updates of Excel mobile, scrolling has stopped working. The solution is to go to Excel settings and uninstall all Excel updates and reset Excel to the initial version. Scrolling now works again. Don't install updates until Microsoft…

Microsoft 365 and Office | Excel | For business | Android
asked 2025-07-31T16:07:19.91+00:00
Rod Lamont 0 Reputation points
edited an answer 2025-07-31T20:16:01.06+00:00
Hendrix-C 1,120 Reputation points Microsoft External Staff Moderator
3 answers One of the answers was accepted by the question author.

Average value of Excel cells containing text that are the subject of individual weightings

Hi Community, I have a scenario whereby I have a column of 7 Excel text cells (let's define them as D4: D10). Each cell is driven by an Excel formula that will generate an outcome of either "A", "B" or "C". Please note, the…

Microsoft 365 and Office | Excel | For business | Android
asked 2025-05-08T06:31:32+00:00
Anonymous
3 answers One of the answers was accepted by the question author.

Can't scroll sideways in Excel for Android.

No gesture works for left or right scrolling. Plus the scroll buttons appear randomly and are inoperable.

Microsoft 365 and Office | Excel | For business | Android
asked 2025-06-02T23:57:25+00:00
Anonymous
2 answers

Filter Data from Mastersheet to other sheets

I am trying to filter data from one sheet(master) to another sheet based on the column that has a list of the months. I've tried using this formula but it is returns as value? 1.    =filter(mastersheet!k3:k500=A1, "no match") …

Microsoft 365 and Office | Excel | For business | Android
asked 2025-05-02T17:20:17+00:00
Anonymous
5 answers One of the answers was accepted by the question author.

Count Unique Values with Criteria

Hi, I have a table that shows species names and material. Some species appear more than once for each substrate type. How can I make a formula that counts the number of species on each material without counting the repeating names? I have species in…

Microsoft 365 and Office | Excel | For business | Android
asked 2025-05-31T12:30:33+00:00
Anonymous
0 answers

Transfer Data automatically to Envelopes

I have one sheet A with two collums (Name and Last Name), which can have over 200 Names/Rows. Then I have another sheet B with DL-Envelopes Layout. I have already formated everything to the way i want to have it, however when I want to copy or duplicate…

Microsoft 365 and Office | Excel | For business | Android
asked 2025-06-28T14:41:57+00:00
Anonymous
2 answers

Unable to convert Text to Number in Excel

I have a downloaded excel file from FTA. The numbers in the file appear to be in Text format. I have tried multiple options to convert it into Number format, but none are working. Appreciate help. Attaching the screenshot.

Microsoft 365 and Office | Excel | For business | Android
asked 2025-04-21T13:46:01+00:00
Anonymous
9 answers

Excel IF OR and AND formula continues to deliver a zero result

Hi Colleagues, I have created an Excel drop down list in Cell B19, containing the options: Excellent, Strong, Reasonable. I am trying to write an Excel formula in Cell D19 that will return a respective "A", "B" or "C" result…

Microsoft 365 and Office | Excel | For business | Android
asked 2025-05-07T20:13:33+00:00
Anonymous
1 answer

Excel crash

We have an ongoing issue of Excel file crash whenever we copy/paste, cut/paste or do insert since a long time. We tried everything mentioned in troubleshoot but it doesn't solve the issue. Can you please help.

Microsoft 365 and Office | Excel | For business | Android
asked 2025-06-27T11:40:07+00:00
Anonymous
2 answers

How to recover replaced file !

Hello, Mistakenly i replaced file with my new version and the name of both files are same, but now i want my old version file, how can i recover it !

Microsoft 365 and Office | Excel | For business | Android
asked 2025-06-23T06:29:58+00:00
Anonymous
11 answers

How to switch the creator of a form from editor to respondant

https://answers.microsoft.com/en-us/msoffice/forum/all/i-am-creating-a-form-within-teams-but-cannot/992a81da-24e3-4e50-99ee-75f44b7b3e45 except, my question is - How do I switch it so I can enter responses on the form myself?It always defaults me to my…

Microsoft 365 and Office | Excel | For business | Android
asked 2025-07-10T05:12:17+00:00
Anonymous
4 answers One of the answers was accepted by the question author.

reference to other cell

Hello, I would like for a certain value to fill the cell with another value,as an example; if the result of the sum (F5) is equal to a value of H:H then the answer becomes J:J, so sum is 4 then 5, sum is 5 then 15, sum is 6 then 25, etc.

Microsoft 365 and Office | Excel | For business | Android
asked 2024-12-04T11:11:42+00:00
Anonymous
1 answer

If formula

Hi all, I have taken over a spreadsheet from someone who left and although I understand the if formula there is something don't understand. It is a very simple formula which says if cell (A<0, "not done","done) however when I would…

Microsoft 365 and Office | Excel | For business | Android
asked 2025-01-20T20:29:26+00:00
Anonymous
1 answer

Not open excel file

we found a problem to open excel file

Microsoft 365 and Office | Excel | For business | Android
asked 2025-02-27T11:00:49+00:00
Anonymous
1 answer

I want to make my business software in Excel

I wanna make a business software in Excel. I had it in Microsoft Framework but it seems outdated. I tried tally but the interface doesn't seem good. My family business is basically broker of livestock (goats). Where the seller brings stock and we sell to…

Microsoft 365 and Office | Excel | For business | Android
asked 2025-03-16T10:42:42+00:00
Anonymous
4 answers

IFERROR with Let Function

How do I do a IFERROR if II590 is blank to leave J1590 blank =LET(d, DATE(5+YEAR(I1590), MONTH(E1590), DAY(E1590)), IF(d <= EDATE(I1590, 5*12), EDATE(d, 12), d))

Microsoft 365 and Office | Excel | For business | Android
asked 2025-01-07T16:24:50+00:00
Anonymous
3 answers

Cross report drill through with in same tab

We're trying to implement a cross-report drill-through in Power BI where users can navigate between two reports (one with a chart view and another with a table view). However, the challenge is that the drill-through option either requires a right-click…

Microsoft 365 and Office | Excel | For business | Android
asked 2025-02-23T14:30:16+00:00
Anonymous
1 answer One of the answers was accepted by the question author.

Date Calculation

If an Application Approved Date is in A2 and a person's Birthdate is in B2, How can I have C3 auto calculate 5 years from the application date on the subsequent birthday? Application DateBirthdateExpiration Date12/15/202410/9/1969

Microsoft 365 and Office | Excel | For business | Android
asked 2025-01-07T14:55:49+00:00
Anonymous
1 answer

Pivot Table Date problem

I have a column with a formula that determines the expired date in the raw data =IF(ISBLANK(I1), "", LET(d, DATE(5+YEAR(I1596), MONTH(E1), DAY(E1)), IF(d <= EDATE(I, 5*12), EDATE(d, 12), d))). When I create a pivot table, it does not allow…

Microsoft 365 and Office | Excel | For business | Android
asked 2025-01-13T09:35:08+00:00
Anonymous