My SUMIFS formulas are able to correctly reflect the quantities under each type (based on yellow table) when "Stock In" is a condition, but they all reflect 0 when I change the condition to "Stock Out", even though nothing else is changed. Does anyone know why this is so and how I can change the formula so that the quantities under "Stock Out" can be reflected? Thank you!

Good news for the many people who have complained about how the Copilot icon overlaps the worksheet area: in the latest desktop Excel version, the Copilot icon is now to the right of the ribbon.

Why Microsoft decided to keep the Copilot icon separate, rather than being on the ribbon, is an interesting design choice. It seems that they only partially listened to the feedback.

If you’re cleaning the same report every month (deleting columns, trimming spaces, filtering rows), Power Query can do it for you. Here’s how I’d get started, plus the habits that stop it getting messy.

Where to find it
Data tab > Get Data. You can connect to a workbook, CSV, folder, web page or database. When the preview appears, click Transform Data to open the Power Query editor.

A simple order that works

1. Remove any junk rows at the top and bottom (titles, totals).
   
2. Promote the first row to headers.
   
3. Set your data types (dates, numbers, text).
   
4. Remove columns you don’t need.
   
5. Filter out rows you don’t want (cancelled orders, blanks).
   
6. Clean text (Trim, then Capitalize Each Word).
   
7. Add any calculated columns.
   
8. Close & Load to a table, then use Refresh All whenever the data changes.

Habits worth building early

* Leave the raw data alone. Power Query reads your source file but never changes it. Do all your cleaning in the query, so you can always go back.
* Set headers and data types early. Later steps behave better when they’re in place, and dates stored as text cause all sorts of problems.
* One step, one purpose. Don’t cram two jobs into one step. It’s much easier to find and fix things later.
* Name your steps. “Filtered out cancelled orders” beats “Filtered Rows1” when you’re back in six months.
* Aim for a tidy table. One row per record, one column per field. Pivots and formulas get much easier.

If you get a new file every month
Use the folder connector. Put all the files in one folder and Power Query combines them. When you add next month’s file, you just hit refresh. The part that confused me initially was which steps go in the Transform Sample File query and which in the main query. My rule of thumb: steps that make one file look like a proper table (top rows, headers) go in the sample file, and anything that works on all the rows combined (filters, trimming, calculated columns) goes in the main query.

I made a video that walks through all of this on a simple example, in case it’s useful: https://youtu.be/23vd7vAEH2s

Hope people find this useful!

I’m using Abacus Docs to pull fields from vendor invoices, and some vendor IDs have leading zeroes. I need those IDs to stay exactly as printed because they match records in another workbook. Do you set the field up as text in the extraction template, then export, or import the result through Power Query and force that column to text there?

I’m trying to avoid a workflow where Excel silently turns 00127 into 127. If you’ve handled this with another document extraction tool, did the exported file preserve the zeros or did you need to fix the type on import?

Quest 1: The Coneservation

https://everybody.codes/event/2026/quests/1

Past Coding Challenge spiel on etiquette:

https://www.reddit.com/r/excel/comments/1pbgisa/advent_of_code_2025_day_1/

My excel used to be doing fine, when i add error bars, it always would be only giving me vertical bars which i need. But these few months it started to give me both horizontal and vertical which is very annoying because its very hard to get rid of manually and considering how much i have the data? Does anyone know how to turn this off? Does this happen to everyone?

I have seen a lot of memes and jokes about using a mouse in excel. Although, I don't have any excel work but based on my career path it's not far until i sit on it 6-8 hours a day but I've always seen people saying mouse in excel is a crime is there any good explanation for it? I mean i get it excel has a lot of shortcuts for keyboard key combinations. Although, when I last used excel my mouse seemed to be more efficient in general selecting and scrolling.

Preface: This is using Excel 2016. I can't do much about that atm.

I'm trying to improve a quoting template so I can get more help maintaining them (will be protecting the worksheets for my sanity).

The concept:

• List of Products/SKUs with a numbered helper column
• Second list for Accessories (if needed) that would have a matching number to the first list
• Output on a scope of work sheet as:
• Item 1
• Item 1 - Accessory #1
• Item 1 - Accessory #2
• Item 2
• Item 3

Is this even possible? Or will I need to add the # reference to the scope sheet and just hope they follow along?

Bonus points if the output also ignores blanks, but I'm not getting my hopes up for that yet.

Edit: Screenshot from Worksheet Edit2: Shoutouts to /u/Competitive-Paint-84, /u/bezuc and /u/MlookSM. All helped me on the right track.

• I used a (now hidden) helper sheet with a column for the original Item# and a COUNTIF() function to create an Accessory# (eg. 1.01, 1.02, etc)
• then the SMALL() function to list those item# in order, ignoring blanks on my output sheets
• One Index/Match to bring in the rest of the info corresponding to the item#.
• I used locked rows (eg. A$1:A$50) to easily copy the Index/Match function through the needed columns, but could have also matched the columns using the header titles.

Overall was pretty quick to implement and is now working perfectly across 2 output sheets. Leaving this extra detail for anyone who stumbles across this thread. Thank you all!

I have an entire document with people's addresses that was correct and the final version somehow had everyone's addresses incorrect due to the numbers shifting by 1. Example if someone lives at first st 124 it changed their address to first st 123....

What could I have done during my formatting to get excel to put that data into mail merge to bring on mailing labels could have altered everyone's address numbers?

I'm actually being driven crazy and excel doesn't seem to have the versions pervious that isn't the very first document that I gave it.... with the correct addresses in it....

The only thing I can think of is when I used the brush to copy format that may have done something but I literally made no changes to anyone's address.

Please help!

Happening every so often when saving a copy in MS365, and the user has to close the application and reopen, and the workbook has lost all progress since the previous save. The thing that is making my head scratch is that apparently, for years before I started here, by boss has worked with her to fix this, thinking that it has been fixed more than once, and it keeps coming back; though not nearly as often as when it started.

Anyone seen this before or have ideas of what could cause this? I'm not very familiar with excel.

I started a new job at the beginning of 2025 that has me doing a lot of reports on Excel. I'm by no ways an "excel pro" but I'm by far the best tech we have on using it, and probably one of the better people in our office overall.

I've got 4x reports for some buildings that I've done some testing in. Each of them has a sheet is a list of devices that we need to test, along with a bunch of information for each device in multiple columns.

I've been working a lot lately on getting our reports nice and consistent sizing and formatting wise, and spend a good 30-45 minutes on every job scrolling through 20-50 pages of reports doing little formatting changes, updating formulas, etc, just to make things neater and smoother for future years.

So on these 4x buildings, each of these device pages are formatted identically from what I can tell. Every column is the same width, every row is the same height. Margin options are identical. I go through and edit all of the cell sizes on essentially every report, just to make sure they're consistent. But I've got 4x reports now, where all cell row and column sizes are the same, all margin options are the same, any headings are identical. But if I do a "reset page breaks" and then drag my page break width to the column I want so that my A-M cells are all on a page, each report ends up a different scale. One ends up at 71% zoom, another at 83%, another at 81%, etc, despite all cell sizing and everything being the same as far as I can tell.

Curious if anyone has a reasoning for this.

hello everyone. i have a simple expenses tracker pivot table i did from ~3years ago but just recently noticed that when i update it, it became in alphabetical order instead of when the data was entered. i don't see a sort option of "when entered" or something along the lines, for the row's sort option.

is there a way for it to remain sorted when the data was entered other than A-Z / Z-A?

for example:

Item A has values in Apr
Item B has values in Jan, Feb, Mar

so in my pivot table, i want it to show as:
Jan Feb Mar Apr
Item B xxx xxx xxx
Item A xxx

but it's now showing like so:
Jan Feb Mar Apr
Item A xxx
Item B xxx xxx xxx

any help will be appreciated, i'm really losing my mind. i even tried to re-do the whole pivot table but it's still in alphabetical order.

I've been using excel app on an android phone for over a year with no issues but starting yesterday anytime i try to filter something and type text into the search box for that it only let's me type in one letter before switching my typing to renaming the cell so after typing it one letter I have to keep clicking back into the filter search box to type another letter into it. Have already tried reinstalling and resetting the app.

I'm getting a message on my MS office files that says "activate Microsoft 365 to create and edit". I can't save any of my files anymore. The reason is that support for office 2021 is over. unfortunately, that's the license I have. So I'm trying onlyoffice. so far so good.

I need to break up one long column of data down to the data in a new column for each day. There is a data point for each hour of each day, and the hourly data needs to be sorted by day in that day's column.

See comments for re-uploaded pic

Thank you in advance for taking the time to look at this!

Description of Spreadsheet (I have a small example below as well):

• I have a spreadsheet full of responses: Column A is the respondees name, column B is when the response was submitted, column C through GM (I know :l) is whether they are available or unavailable for each date with the date along row 1. Each person input several responses throughout the time period and didn't necessarily include availability for dates passed.

What I'm Trying to Do

• I'm attempting to condense this spreadsheet with only one row for each person so I can see how many people we had available for each date in the record. The idea would be to have one set of names in column A and the dates listed in row 1, then in each cell have it search the data for the correct name and a response date that is less than the date of the column it's in.

I tried using an xlookup with boolean logic and changing the search mode between 1 and -1 but it seems like the entire concept of it returning values from different lines is not happening.

I feel as if there has to be an easier way to do this but I'm coming up blank!

I'm an extreme beginner and figured i could help a family member, who is even less knowledgeable than I am, out with their project. I'm looking for a formula/way to quickly fill in the difference of these values on the respective "non" cell to avoid having them filling in each value by hand as at this point its not possible to change the layout of the data. I have access to Google sheets and Microsoft Office LTSC Professional Plus 2024, both on desktop. I hope it is clear what im asking for and tried following the rules, i apologise if it is not and thank you for your time in advance.

I am trying to make a vacation planner. The ones online I have found aren’t quite right or cost money. I want make a das board that will display checklists on other pages as done or not( ie all boxes checked, corresponding box on dashboard will turn green. How is this achieved?

For an assignment, I have to show multiple scatterplots with quick style 9 (regression) for a Units Produced column and different costs associated with production. The chart for each Input Cost A, C, and D returns normal data as y=3x, 500, and 2x+4000 respectively, but I keep getting y=1.1x-3E-10 for Input Cost B

I've tried manually selecting the column, copy-pasting from Inputs A and C and moving the selected column to B, and typing in the data to be used in the chart data window, but I keep getting the same results or having to start over again with a clean sheet. Can someone help me figure out what I'm doing wrong?

Happy to share screenshots or whatever else would be helpful

I am trying to make a little budget worksheet just for fun. I want it to track income and tax over however long I use the budget sheet, and I want it to total each week's income and tax correctly even when future weeks still show zeros. Since each week is written out each month (with random numbers), there will be zeros where there will be numbers in the future.

I have used the formulas =SUMPRODUCT((V1:AM164="Revenue($):")*IFERROR(V2:AM165*1,0)) and =SUMPRODUCT((V4:AM78="Tax($):")*IFERROR(V5:AM79*1,0)) to count the tax and money made, shown in the image in the comments. I’m not sure what’s going wrong; if somebody can help, that would be fantastic.

!MacBook user! hello everyone, is there any way to filter data from different tables to show a specific rating? for example, if i wanted to filter all the tables to only show songs i have rated a "10?"

Hello, I'm using Excel 2019. I'd like the cells in my Date column to,

1. Have a light red background with red text if their date is older than 10/1/2026
2. Not have a light red background with red text if their cell is blank (there is no value/formula in these cells)

For the example above, just cells A4 and A5 should change color. Thank you for your time!

Edit: Made image smaller and added Excel version.

Saturday, October 17 - Friday, October 23, 2026

Top 5 Posts

Unsolved Posts

Top 5 Comments

Hi! I'm new to excel and I need to work out how to combine the content of 4-5 cells into one, with line breaks between the content of each cell.

I've found several ways of combining content (https://spreadsheetplanet.com/combine-cells-excel/), but the formulae won't take CHAR(10) as a separator character as described here: https://www.exceldemy.com/excel-char-10/

So I've tried let's say =C2&"CHAR(10) "&D2&"CHAR(10) "&E2&"CHAR(10) "&F2 and it gave me an error in the formula cell.

I assume concat and textjoin would result in the same error as the problem seems to be the CHAR(10).

Anyone smarter than me, any suggestions? ty

ETA after mod autopost: desktop version of Excel, idk the exact version as it's on my work computer. Super beginner. Will happily add info as needed but it'll have to wait until Tue when I'm back at work

As the title says, I cannot open any of the default templates in my version of Excel (16.16.27) for Mac. I'm running MacOS 11.7.11. I am able to open a blank workbook, but when I click 'Create' after selecting any of the templates, I get this error popup:

Sorry, we couldn't find {5158210B-13B3-C343-AD83-9F57F57CEB70}TF021319d1-8fd9-4017-acd1-4bbaa149d16ea012565-7fc77437defb.xl. Is it possible it was moved, renamed or deleted?

The string of letters and numbers changes depending on the template, but the end result of not being able to open the template is the same. I've found some answers for custom templates, but my issue is with the default templates. Thanks in advance for any help.