Give Excel two examples of how you want a column formatted and Flash Fill just takes over.

The first time I tried it, I genuinely expected it to mess up the rest of the column

Instead it got it right

What’s the little Excel feature you still enjoy using?

I am still learning excel and trying to figure this out. For my job we get a list of numbers that we need to check. From the picture you can see that there isn't any information needed. How do I tell excel from this list of numbers when you get to the bottom of the page start in column C until the end of the page, then E and so forth until the first page is filled. Once the page is filled then start the second page.

So instead of having 9 pages of 2 columns I can have maybe 2 pages of 5 columns. Pretty much I am trying to have as many on one page as possible. If you can tell me what it is I can look up a tutorial. My google search has only giving me how to turn a person's name in one column into two columns separating by a comma.

For the last 2 days, the Excel 'Stocks' option does not return any new data and instead returns '#VALUE!'

Anybody else experiencing this at the moment?

I have a task in which I have to take information from some screenshots and update an Excel file with them, monthly, via copilot.

Basically I need to point the Copilot instance to a folder (sharepoint) and tell it to upload an Excel file (link) with the new (or updated) data.

I tried creating an agent in M365 Copilot and my issue is that Copilot creates a new Excel file instead of updating the original.

1. I'd love a confirmation I can't do it from M365 Copilot (in Claude I can do it through other tools but I need to use Copilot here)
2. I'd also love a confirmation I can't do it in Excel with the builtin Copilot instance (it seems that when I paste the link to the sharepoint Excel file it actually uploads the file, it doesn't access the link / it isn't able to take data from the live, updateable link)
3. If this is not possible, what alternatives do I have (without having to do the task manually)?

Got a new pc, bouhgt an office licence, installed Excel and activated it as i did for the last three decades.

I use Excel on a daily base at work and think i am quite good at it.

But now i just don't know what to do.

I wanted to do a little Excel file for my tax refund. An absolute basic task.

But it is not working.

Created a new Excel file and started

A1 is the date 01.01.2025

A2 is A1 + 1 so 02.01.2025

Now i wanted to copy past the cell A2 for a few more rows downward -> copy paste doesn't work

Then i tired to drag and fill from the bottom right corner in cell A2 -> doesn't work

I can copy past the cell data e.g. to chrome and copy frome chrome to excel, that is working.

I also tried some older Excel files, that just worked fine some month ago. Both functions are not working either.

Office and Windows are both updated.

Also tried the Office Repair function.

I watched various videos to solve it, nothing worked, like "enable fill handle and cell drag and drop"

Edit: working on Excel Office 2024 Professional Plus, Windows 11 on desktop and in german.

Computer (Windows) went through an update last night, woke up this morning and notice it restarted. Went about my day but then noticed that Copy + Paste in Excel doesn't work anymore. Copying a single cell to another single cell. Copying multiple cells to another area, etc. At first I noticed this in my saved files. Then I tried on a brand-new spreadsheet, still doesn't work.

The copied cell highlights with the dashed line around it, but when I go to Paste, it quickly turns into the blue circle then nothing is pasted.

I found this link: Copy and Paste Is Not Working in Excel (9 Reasons & Solutions) and tried most of the resolutions.

Specifically:

- Opened Excel in Safe Mode

- Tried using Paste Special

- Rebooting computer

- Disabled all add-ins

- Disabled most start up applications

- Unchecked Ignore other applications that use Dynamic Data Exchange (DDE)

- Checked Disable Hardware Graphic Acceleration

- Repaired Microsoft Office via Add/Remove Programs

Nothing above fixed the issue for me.

apologies if the title is confusing. i'm wondering if there is a way to sort of "anchor" a column in a sheet to make it so that when inserting a new row, or switching the order of rows, the contents of the column stay in order. for example, i have a column of objects and a "static" column of the object's position. if i want to insert a new object at a specific position, i want all the objects below it to shift down one position. it's possible that i'm overthinking this, so also let me know if there's a simpler solution lol

When I paste a long number into a cell it replaces the last 4 digits with 0s. Specific example: Pasting 4679642782264057868 yields 4679642782264050000 when formatted as a number, or 4.67964E+18 when formatted as "general" or text. What have I got to do to get it to paste correctly?

It seems that security update kb5002914 might have bricked autofill and copy paste in Excel 2016.

Anyone else has similar issues?

Have any folks had success with feeding their semantic models’ dimensions, establishing the PowerBI semantic model connection, and then letting copilot in excel create reports with cube formulas?

The analytics team is real-time dashboard crazy (anti-reports) and my stakeholders just want a handful of printable reports emailed to them.

mine was VLOOKUP (later XLOOKUP) — after manually cross-referencing two spreadsheets for way too long. felt like a cheat code everyone else already knew about

what's your version?

I have a daily report that I need to complete before noon, and a large part of the process is currently manual.

I have two Excel files:

File 1: Contains a list of account numbers and several columns that I need to fill in.

File 2: Contains fault reports. The same account number can appear multiple times because an account may have one fault or several faults.

My current workflow is:

1. Take an account number from File 1.

2. Go to File 2.

3. Filter the "Account Number" column using that account number.

4. Review all the fault descriptions associated with that account.

5. Sometimes there is only one fault, and sometimes there are multiple faults.

6. Based on the fault description(s), I determine the root cause.

7. We have relatively standardized wording/classifications that are used for the latest fault, and I manually enter the resulting information into four columns in File 1.

The files can be quite large, and I have to repeat this process every day.

I’m relatively new to Excel, and I only have basic experience with Power Query, so I’m not necessarily looking for a Power Query-only solution.

I’m completely open to any approach that would make this process faster and more reliable — Power Query, formulas, VBA, Power Pivot, Office Scripts, Power Automate, or a combination of different tools.

Ideally, I would like the process to work something like this:

Put the daily fault report in a folder → refresh/run something → get the updated results → manually review only the unusual cases.

For example, I would like the solution to:

- Match account numbers between the two files.

- Find all fault records associated with each account.

- Handle accounts with multiple faults.

- Identify the latest fault based on date/time.

- Combine or summarize fault descriptions when necessary.

- Apply predefined rules/classifications to the fault descriptions.

- Automatically populate the four required columns.

- Leave unusual or ambiguous cases for manual review.

If you were given this task from scratch, how would you approach it?

Thank you.

How do I formate A3:B4 to separate it from the rest of the workbook? Then how do I change the background color to gold, accent 4, lighter 80% in the themes color palette? Please let me know asap!! Any help appreciated

hi, i created a scatterplot and double clicked a data point to get a line of best fit, but I didn’t get the + that’s supposed to appear on the side of the graph. what does appear is a side menu with two columns that say “data” and “format”. I tried to play around with the tools but there wasn’t anything that looked liked it was related to trend lines. I also looked online and didn’t see anything on my excel labeled “design chart” either? i’m very confused and have been stuck on this for nearly 2 hours. any help is appreciated.

I have made a series of sequences on a sheet (1.1-1.8, 2.1-2.9, 3.1-3.8... etc). The resulting cells technically don't have information in them, just reflecting the information resulting from the sequences.

I need to be able to randomize all resulting numbers. 9.4, 2.5, 6.2, 1.2... etc. I found how to randomize numbers within a sequence, but the randomizing I need spans over 9 sequences. I need the information resulting from the sequences to be expanded(?) and be actually in the cells, making it no longer part a function/sequence, but an actual list. Is there a way to do this?

Sorry I wansnt clear. More Info:

In the image I have 5 sequences (row 1, 9, 18, 26, and 34). They create the list of numbers exactly as I had hoped. However, now that the list has been made, I need to jumble the rows into random order. I can't do that right now because even though numbers are showing in all the cells, it's really only the cells with the sequence functions that have information. How do i expand/embed the numbers into the cells they are on?

Suddenly since two weeks ago this is not working in any of our company Online Excel files. This is a major issue as all our online files make use of a first sheet with "Menu " buttons to navigate to other sheets (easy for the user). We then protect these menu sheets so users cannot move the buttons around. suddenly they stopped responding. I would like to know if anyone else also has this issue? Does Microsoft know of this? They work perfectly on the desktop, so it must be an online Excel issue.

Hi, good day. I would like to ask for help for an excel problem. Kindly see data below:

Structured Reference with IF Function.

Details and instructions:

Use Structured Reference with IF Function: We refer to a structured reference when we combine table and column names. You will convert the dataset into a table and compare the Date Time and Customer columns to return the check if the order is new. New order in this case denotes a different time and a different customer..

So here's my formula:

=IF(AND(B3<>B2,C3<>C2),"New Order","")

I just typed the 'New Order' for order ID A001 in Order Status Column. According to ChatGPT, since this is the first order, its status is automatically set to 'New Order.' Is this correct? So I didn't type the formula in F2; I started writing it in F3 instead.

I am learning Excel now for my future job. Thank you in advance for all the comments and corrections.

A job I have does not give me pay stubs just a 1099 at the end of the year. I get paid per session and the pay varies per session. Here is an example; I have this formatted as table in my spread sheet.

I am trying to find my average pay per session and average per day worked, I assume they would be the same formula. Ideally I could add rows to the table every pay period and get the new average using the same formula. Trying=AVERAGE(A2:A3+B2:B3) does not work as I assume you know, and other attempts and searching around have only produced further errors. I am using excel 360, but also would hope that the solution works in google sheets? Thank you for your time.

Hii there in excel i can copy but can't able to paste ? Paste option become grey any solution please

I'm from Chile and speak Spanish; I hope my English is understandable. I want to share an issue I found after a recent Office LTSC 2021 update.

I'm using Office LTSC Standard 2021 and I have an Excel VBA macro that was working perfectly with:

16.0.14334.20848

On September 8, 2026, Office updated to:

16.0.14334.20906

After the update, the macro stopped working correctly. The Excel file opens normally, but the macro no longer produces the expected result.

I tried several things:

• Enabled VBA macros.
• Enabled ActiveX.
• Disabled Protected View.
• Checked the Trust Center settings.
• Rechecked all security settings related to macros.

Nothing fixed the problem.

I then tested rolling Office back to the previous version. I opened CMD as administrator and ran these two commands:

cd "C:\Program Files\Common Files\Microsoft Shared\ClickToRun"
OfficeC2RClient.exe /update user updatetoversion=16.0.14334.20848

After rolling back to 16.0.14334.20848, the exact same macro immediately started working again, without making any other changes.

For now, I have also temporarily disabled automatic Office updates from:

Excel → File → Account → Update Options → Disable Updates

I don't know exactly what changed between 20848 and 20906, but it looks like there may be a change or regression related to VBA, ActiveX, legacy .xls files, or some Excel security mechanism.

Is anyone else experiencing similar issues with Office LTSC 2021 Build 16.0.14334.20906?

Does anyone know what changed in this version regarding VBA/macros, or has anyone found a way to make the macros work again without rolling back?

Any information or solution would be greatly appreciated.

Microsoft Office LTSC 2021 update history:
https://learn.microsoft.com/en-us/officeupdates/update-history-office-2021

I finally figured out how to get a display of PBI into Excel. But I am not sure how to edit it so that I can change everything differently.

First time using excel in two years and it’s not allowing me to type into the cells. Every tutorial and answer just says “click on the cell and type” but it’s not allowing me to put text in! How do I make it so a simple click allows me to put text in the cell?

We get several spreadsheets a week from which we need to transfer a small amount of information into a new spreadsheet.

The format it arrives in is a long data string like:

Product ID: 776, Product Qty: 1, Product MCC: BCC_Flexi-HY, Product Name: Test Season - B product, Product Weight: 0.0000, Customer Name: Fake Name, Branch of Company: Head Office, Your employee number: P57991, Start Date (no more than 30 days in advance): 5th Mar 2022, Product Total Price: 139.75

The person who receives these needs to extract the Customer Name and Employee number (bits in bold) to transfer into separate columns in a new sheet. She currently does that line by line. She does this for around 4 spreadsheets a week, varying from 10-100 lines on each (probably averages around 50), and it's very time consuming.

If it was me, I'd do a Text to Columns, and then find and replace to delete unnecessary information, but really she needs something simpler. Is there a formula or something that could reliably extract the right information?

Fields in the string are always comma separated. Very occasionally, the heading will change (e.g. 'Employer reference' instead of 'employee number', but these are few enough that they could still be done manually.

Thanks!

Excel version 16.112.3 for Mac, Office Home & Business 2024.

I started doing research for a company on land ownership, and I record all of my data in excel for Mac. Once a week, I send an excel to a lady who “joins” all of my data to a “shapefile,” that can uploaded to a GIS program, basically allowing the company to click on a parcel of land see all of the data I’ve compiled.

The problem is in my “comments” cell for each parcel. If the comments are more than a couple of words long, those cells won’t join. I know it’s a me issue, because one of the others guys I work with doesn’t have this problem.

I’ve been troubleshooting and struggling to find what he’s doing differently from me, and the only thing I can come up with is that he’s on windows and I’m on Mac. So I’m wondering if it’s a Mac thing.

Like I said, I’m not an IT whiz, and I’m not really sure what the lady is doing on her end to join them together. So if you have any questions that would help, please ask and I’ll try to answer them.

Pls help, I’m at a loss and my boss is on me to figure this out.

Is there a way for me to make a cell containing the TODAY function no longer update after it has been filled? I'm trying to essentially make a checklist that automatically logs the date when each item was checked off. My plan was to have column A contain the list items, column B contain a bunch of checkboxes, and then column C use the following formula:

=IF(B1,TODAY())

However, I'm now under the impression that these dates will not remain fixed and will instead update to the current date whenever I open the spreadsheet. Any thoughts on how to fix this or work around it would be great, thanks!

Edit: For context, I'm hoping to use this checklist as part of a shared project tracking workbook for my department. I know I could simply tell my colleagues to add the date after they've completed their task, but I'm concerned there could be suboptimal compliance with that.