1,348 questions with Microsoft 365 and Office | Excel | For education | Windows tags

Sort by: Updated
2 answers

UNABLE TO SEE DATA ANALYSIS TAB APPEARS IN EXCEL RIBBON

Microsoft 365 and Office | Excel | For education | Windows
asked 2026-04-19T21:35:34.3233333+00:00
Earle, Malvia O. (Student) 0 Reputation points
commented 2026-04-20T22:36:51.53+00:00
Hendrix-C 14,650 Reputation points Microsoft External Staff Moderator
3 answers

teach me excel and advanced excel

teach me excel and advance excel for finance and business perspective

Microsoft 365 and Office | Excel | For education | Windows
asked 2026-01-07T10:58:48.4366667+00:00
shashank joshi 0 Reputation points
answered 2026-04-10T14:19:15.1633333+00:00
Bulldog 1,380 Reputation points
2 answers

Scientific Notation - I want to display the whole number.

How can I change a column in Excel to display and entire number without changing it to scientific notation. Instructions within Excel suggest to change the format to text, but that hasn't worked. Every time I add a number it changes to scientific…

Microsoft 365 and Office | Excel | For education | Windows
asked 2026-04-08T14:26:55.09+00:00
Kehr, Monica (DHHS) 0 Reputation points
commented 2026-04-10T13:15:52.88+00:00
Julie Huynh 835 Reputation points Independent Advisor
2 answers

Pivot auto refresh toggle

when will the pivot auto refresh be universally avable to all 365/s

Microsoft 365 and Office | Excel | For education | Windows
asked 2026-04-08T15:57:14.05+00:00
michael mc guirk 0 Reputation points
edited an answer 2026-04-10T07:48:51.8866667+00:00
Daniel-Vo 5,245 Reputation points Microsoft External Staff Moderator
3 answers

I have a spread sheet that has multiple sheets and want to check if any of the values in column A are duplicated in any of the other sheets.

I have a spread sheet that has multiple sheets. When I add additional data, which is always into the same sheet, I want to check if any of the values in column A are duplicated in any of the other sheets. The format of all sheets is the same. My data…

Microsoft 365 and Office | Excel | For education | Windows
asked 2026-04-08T03:01:18.8766667+00:00
Brian Vagg 35 Reputation points
answered 2026-04-09T23:01:37.8966667+00:00
Ashish Mathur 101.8K Reputation points Volunteer Moderator
2 answers

Blocked Macro

I have an excel file that needs to run a macro and there is a Security Risk warning that pops up and no I do not have the Macro option. I've been using this for over 7 years. I've set settings on my computer to trust a site and enable macros but…

Microsoft 365 and Office | Excel | For education | Windows
asked 2026-04-02T17:46:45.8433333+00:00
Astello, Cynthia P 0 Reputation points
commented 2026-04-06T16:25:21.2133333+00:00
Hendrix-C 14,650 Reputation points Microsoft External Staff Moderator
3 answers

After adding a formula to the table, the chart bars disappeared.

Hello, Is there something I could change in this formula to prevent bars disapearing from tthe table? I have a bar chart with estimated completion and real duration bars. Bars for real duration are based on scatter chart and modified to look like bars.…

Microsoft 365 and Office | Excel | For education | Windows
asked 2026-04-03T14:56:13.04+00:00
Agnieszka Królikiewicz 0 Reputation points
commented 2026-04-04T21:49:41.39+00:00
Ryan-N 12,100 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

What formula would suit to have monthly amounts entered in my account worksheet

I need a formula that would enter these amounts every month/quartley/yearly in my current account w/sheet

Microsoft 365 and Office | Excel | For education | Windows
asked 2026-03-30T19:33:13.5666667+00:00
William Auld 160 Reputation points
commented 2026-04-03T15:59:28.11+00:00
Alina Le 1,230 Reputation points Independent Advisor
2 answers

Autopopulate cells based on a drop down list selection

I keep getting an error message when I try to put in a formula to autopopulate from a drop down list. The drop down list is in column E and the cells that I need to autopopulate from there will be column D & F. I have used the following formula: …

Microsoft 365 and Office | Excel | For education | Windows
asked 2026-04-01T16:19:58.8566667+00:00
Latoya 0 Reputation points
commented 2026-04-03T14:35:10.5366667+00:00
Alina Le 1,230 Reputation points Independent Advisor
3 answers

HOW TO MAKE MULTIPLE DROPDOWN ON EXCEL SHAREPOINT

I badly wonder how to make a multiple dropdown in excel share point. Example: Fruits Category: banana grape peach apple I want to fill one cell with: "banana, grape, apple" which mean i can select more than 1 fruits. But i…

Microsoft 365 and Office | Excel | For education | Windows
asked 2026-01-09T01:48:02.78+00:00
Niko Patty 5 Reputation points
answered 2026-04-01T19:06:14.3366667+00:00
Kc 0 Reputation points
2 answers

SQL set of functions in Excel - MIght be interesting

Hi people, interested about high-piloting in Excel I just finished (actually there is no finish - countinues fun process) close to full set of relational functions in Excel based only on regular functions and lambdas Possible example =λWhere( …

Microsoft 365 and Office | Excel | For education | Windows
asked 2026-03-17T09:11:12.2366667+00:00
Henn Sarv 46 Reputation points
commented 2026-03-23T07:39:53.3666667+00:00
Daniel-Vo 5,245 Reputation points Microsoft External Staff Moderator
1 answer

MACRO ENABLED EXCEL FILE

I HAVE FOLLOWED EACH AND EVERY STEP TO OPEN A MACRO ENABLED EXCEL FILE BUT I AM STILL NOT ABLE TO OPEN IT. I HAVE TO COMPLETE AN IMPORTANT TASK BUT IT IS NOT LETTING ME TO OPEN THE FILE. PLEASE HELP AS THE DEADLINE IS APPROACHING FOR MY TASK. I HAVE…

Microsoft 365 and Office | Excel | For education | Windows
asked 2026-03-04T06:50:03.01+00:00
aikansh guneta 0 Reputation points
commented 2026-03-19T09:55:44.5933333+00:00
Nam-D 3,395 Reputation points Microsoft External Staff Moderator
2 answers

Date Calculation in Excel

I keep running into a problem with finding the difference between dates in a excel spreadsheet. The start date is 3/1/2026 to 3/15/2026. I've tried the simple =startdate-enddate And for some reason the end result is 1/0/1900, when I'm looking for 14.…

Microsoft 365 and Office | Excel | For education | Windows
asked 2026-03-15T22:32:41.2266667+00:00
Selina M 0 Reputation points
commented 2026-03-17T07:16:13.5333333+00:00
Darren-Ng 9,275 Reputation points Microsoft External Staff Moderator
1 answer

Can't sort table with indirect called items

Hello, I have a table that collects cell values based on a reference cell that i want to have the ability to change name without breaking the table function. The problem is that when I try and sort values in Column 2 in ascending order it does nothing…

Microsoft 365 and Office | Excel | For education | Windows
asked 2026-03-09T13:33:50.06+00:00
Gusten 0 Reputation points
commented 2026-03-12T10:55:34.8166667+00:00
Daniel-Vo 5,245 Reputation points Microsoft External Staff Moderator
1 answer

when I move down in an excel the arrow key takes me down only after multiple pressing also when I move down in a column where the header has some formatting then on pressing down arrow key the excel does not allow me to move down in a single click I have

when I move down in an excel the arrow key takes me down only after multiple pressing also when I move down in a column where the header has some formatting then on pressing down arrow key the excel does not allow me to move down in a single click I have…

Microsoft 365 and Office | Excel | For education | Windows
asked 2026-03-08T18:11:35.4366667+00:00
Sushil Upadhyaya 0 Reputation points
edited a comment 2026-03-09T22:15:00.26+00:00
Jay Tr 11,215 Reputation points Microsoft External Staff Moderator
1 answer

How to install analysis toolpak in excel

I am trying to load the analysis toolpak in excel and the instructions do not match my screen. Every instructional video I have found also do not match my screen. I need to install it for a class and do not know how

Microsoft 365 and Office | Excel | For education | Windows
asked 2026-03-07T23:53:43.91+00:00
Thomayer, Jill 0 Reputation points
commented 2026-03-09T03:53:57.4166667+00:00
Sophie N 13,825 Reputation points Microsoft External Staff Moderator
1 answer

Update Microsoft Excel

How do I update to the latest version of Microsoft Excel when using my school's resources?

Microsoft 365 and Office | Excel | For education | Windows
asked 2026-03-08T00:11:33.5+00:00
Thomayer, Jill 0 Reputation points
commented 2026-03-09T03:53:40.85+00:00
Sophie N 13,825 Reputation points Microsoft External Staff Moderator
2 answers

i can't open document in power point, xl sheet, word

Microsoft 365 and Office | Excel | For education | Windows
asked 2026-03-06T11:29:59.6433333+00:00
Nethuli Thihansa 0 Reputation points
commented 2026-03-08T15:39:26.07+00:00
Jess-Q 9,830 Reputation points Microsoft External Staff Moderator
2 answers

My mouse cursor is misbehaving while using Excel

Hi Team, I am facing an issue that while using any excel file my mouse cursor misbehaving, automatically moves to another cell or completely disappeared. Sometimes it moves to another sheet please suggest any solution.

Microsoft 365 and Office | Excel | For education | Windows
asked 2025-09-10T08:47:46.91+00:00
Anshu pal 10 Reputation points
commented 2026-03-06T14:58:35.5433333+00:00
Julie-Hu 7,105 Reputation points Microsoft External Staff Moderator
1 answer

Solution to Microsoft blocking macros

I'm downloading macro enabled workbooks from SIMnet to complete Excel assignments, and they require me to run macros saved within them. I added SIMnet to my trusted sites, disabled my ad-blocker as instructed by their support, fully enabled macros in…

Microsoft 365 and Office | Excel | For education | Windows
asked 2026-02-26T21:53:07.2566667+00:00
Alex 0 Reputation points
commented 2026-03-04T16:49:56.1433333+00:00
Jay Tr 11,215 Reputation points Microsoft External Staff Moderator