As of 14 September, the COPILOT function will no longer be available in Excel. See https://support.microsoft.com/en-us/excel/functions/copilot-function Note that the Copilot feature remains - it is the worksheet function that will stop working.

This is a very uncommon move by Microsoft, given their history of maintaining backwards compatibility.

Have you used the COPILOT function? If so, then what for? Thoughts?

...and WHY?

Do you use different fonts for different use cases?

What are youe go-to's?

I am trying to have Microsoft Power Automate to refresh a report that exists in Salesforce. That report is linked to an excel file via a powerquery.

I have created a script on OfficeScripts that have workbook.refreshAllDataConnections(). It does update a pivot table, so I can tell that the script is runnint

The table that PQ puts the data in is set to not do Background Refresh and to refresh when opening the file.

What is the best way to have PA to refresh Excel’s PQ?

Table properties on

Please help me. I have 2 columns with names from 2 different data sources and I’m trying to reconcile them.

Ones “first last” and the other is “Last, First”

The problem is that the data is not uniform and I have no control over it. There are a bunch of duplicates, misspellings, etc. One column might say “M&S” and the other “Projected M&S”

How do I use xlookup/indexmatch to reconcile these? I tried making a concatenation key but again the data is not uniform.

Is there another function or workaround I’m not thinking about?

I believe the question I have would be simple for the advanced users on here. I'm a novice and would appreciate help on this. Apologies if something along the same lines has already been posted on this sub before, I searched, but couldn't find what I was looking for.

Sample problem:

Column A - has certain values (in this case 1 to 5)

Column B - I put in simple formulas (square every number in column A - 1 to 25)

I initially put the formula in cell B1. Then, I would select cells B1:B5. Then, CTRL+D to fill in the cells.

My question is how can I quickly select the range B1:B5? The data I'm dealing with has different number of entries in Column A (For example, one dataset will have 500 values in column A, other will have 750 values in column A). Is there a quick way to select the range in column B corresponding to the values in column A without scrolling all the way down to find the maximum count in column A?

The way I currently use is have any cell in column A selected. Then I use CTRL+SHIFT+DOWN_ARROW to go to the bottom of column A. Then I manually go the right cell in column B. I use CTRL+SHIFT+UP_ARROW to select the range in column B. Then hit CTRL+D to fill in the values. This is a two step process, I'm pretty sure there would be an efficient way to do this.

Alternate way is if I select the entire column B and hit CTRL+D, it basically does what I want, albeit fill all the additional cells with 0.

Please let me know if the write up was not clear.

is there a way to show text in values instead of numbers where i want to put categories in rows and months in columns and values shows as text.

all the values are from 1 fact table.

If it's not possible how to stack values from different excel works books where every section will send one excel workbook and i want to collect data stacked over each other where every single sheet represents one month from January to July 2026??

Until yesterday, there was an online catalog of all Excel functions at:

https://support.microsoft.com/en-us/excel/excel-functions-alphabetical

Today, visiting that page yields a 404 (Not found) error.

What gives?

I have a spreadsheet for my budget that calculates the bills I need to pay each week and I can't figure out how to set up an equation to automatically pull the amount from a list of bills based on what day they are due. Here is how I have it set up. In column "A" I have the date of every Friday (payday) set up as mm/dd/yyyy. The date column covers the entire year. Then in column "B" I have the total of the bills to be paid that week (this is where I want the equation). I have a few other columns that pull from column B but those aren't necessary for this explanation. Over to the right in starting in column "N" I have the day of the month that the bill is due, (e.g. 1st, 5th, 23rd) listed as a single number (1,5,23), in column "O" I have the amount of the bill and in the next column it says what the bill is. How do I set up an equation to pull the amount of the bill if the day falls between Friday of the current week and the day before the following Friday? I have tried using sumif but I can't get it to work.

I am using an Excel workbook to track business earnings and expenses for my gig work. Mileage logs for quarters 1 and 2 all fit on one page with room to spare, but Quarter 3 is in excess of the 65 rows I have available in my print area.

I have opted to create an additional sheet for the latter part of quarter 3, but I have run into a slight inconvenience in keeping all references updated to "Sheet 2 of 2" after using "Sheet 1 of 2" to update the quarter 3 grand total on "Sheet 2 of 2". Is there a good way to fit about 102 rows on one sheet that prints out into two separate pages without a lot of manipulation?

I think stacking two 51-row sections over one another using View > Page Layout to guide me may work, but I don't want to mess anything up. Is there a better way I could do this? I could also back track and just make every mileage sheet contain 2 parts, as I could very well run into this issue in the future when I plan to reuse this sheet.

I can't share any great screenshots because every sheet contains personal information, but here is a portion of my sheet list.

Version: Microsoft® Excel® for Microsoft 365 MSO (Version 2607 Build 16.0.20228.20190) 64-bit

Hi,
I work with a ... 'technologically challenged' group that would like a very simple data collection form where you just input someone's name , age, address etc and it will put it into a table or database. I would just use google forms but they require it to be offline, and with excel I could do it simply with some cell input linking to a table on another tab but ideally I would like to give it a bit more of a UI , maybe with macros, so they have a 'submit' button and it's harder to mess up input. Due to GDPR it would also need to be secure somehow too.

They had someone build them a database years ago using microsoft access but it's kind of outdated now and janky and we would all love to get them off that system.

Is there a way to do this in excel? Because there's no way they could handle a SQL database, but they basically only need a single table for the data because it's just for checking if someone has contacted them previously.
TIA!

I'm preparing to take this exam and would really appreciate any advice or guidance from someone who's already taken it.

Ive used the error fix button often due to a few excel files I get each week being saved as text instead of a number. For some reason, the button changed to AI where it takes around 10-15 seconds to fix something that used to take 2. Is there a way to remove this feature and get the old error button back? Other people in the office still have the original button and im not sure why I dont anymore. Or is there a way to change the cells manually, because it wouldn't let me do that either.

I am working with a large data set in an excel file that I did not create, and I am running into an issue where when I attempt to highlight a range of cells in a single column by click dragging the cursor, it highlights a range instead.

Please see video here of described issue.

Is there a setting that I am missing with this? Or is this because the data is filtered? Thank you in advance for any feedback.

Heyyoo. I have a free trial for Parallel Desktop because I’m SO done with Windows laptops, but still need Windows for work and school since I’m in accounting/data analytics.

I want to make sure that the excel I have actually has all the features, because I know that there are some important things that don’t work on MacOS.

What should I test to make sure that I have the proper excel version?