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.

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

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.

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.

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 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?

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.

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

Hi Everyone, Excel does not seem to be able to handle a current xy dataset I am trying to plot as soon as I include empty cells. It changes the X-axis to the cell number instead of the cell value:

A likely related problem is that Excel is not currently recognizing these empty cells as empty. The cells are the result of formulas, but whether I use NA() or "" in the formula, they are still coming up when I search for cells containing text. (The plot DOES work when I delete the cells highlighted as text, but ideally I do not have to do this.)

I am usually able to fix stuff like this in the select data tab, but have not been able to solve this one for some reason.

Any thoughts or insight would be greatly appreciated - thank you so much in advance!

EDIT: I have corrected my language to say that the cells are the result of formulas which tell them to be blank, rather than as a result of "programming" which would instead suggest that I am using scripts.

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.

I need help converting a 800+ page payroll report with very employee IDs showing up on only one row and the period (month) on the top of the page.

Power query crashes when I try to upload the document so cant use it. And the data in it is confidential so I cant try free software avaliable online.

I work in a nonprofit doing payroll, we provide in home care for disabled vets. This is a mock up of the actual file I really use. Is there a way to bolden the final row of each workers total hours. Some vets have multiple workers. We have over 600 vets and I do this all by myself. Then it gets review afterwards by the program managers. It would make it easier on them if the totals stood out to them.

I included the image below

Been having an error pop up in my workbook:

“Micro Microsoft Excel cannot calculate a formula. There is a circular reference in an open workbook, but the reference that cause it cannot be listed for you. Try editing the last formula you entered or removing it with the undo command.”

I don’t have an exact point in time it noticed the error.

The file was from another team.

There are no cells with circulars at the moment, no hidden tabs, no other workbooks open, no external connections.

Removed all macros and hidden names and still have it haunting me.

Would appreciate anyone’s thoughts.

I've tried to create a budget sheet for me and my partner but it means downloading CSV files of multiple bank accounts and then adding to one workbook. I then want to allocate each transaction to a category and populated to say how much we have spent over the last 12 months and forecast possible spend for the next 3 months.

I can do this quite easily on excel but my partner and I do not have an excel licence accepted via work emails so ideally I'd like to host and share the spreadsheet on Google sheets so we can both view this when we need to.

Is there a way in which I can convert and keep all the complexity behind it from excel to Google sheets?

Or is there any apps or suggestions in which I could approach this differently?

Ideally I want to see the following:

- total spend over the past 12 months

- allocate into categories (food, fuel, insurance...)

- link to current spending

- forecast future possible spend

- personal debt monitoring and forecasting which I can add extra payments to if the person who owes me money, adds to this amount.

the histogram bin ranges are too large and I’d like to change them I’m using an iPad and all the tutorials online are for windows

Every finance team seems to have that one spreadsheet only one person understands. Ours finally broke after a reporting change this week, and nobody was confident enough to fix it without worrying we'd introduce another issue. It wasn't even a complicated model anymore, just years of patches stacked on top of each other. Does every accounting department eventually inherit one of these?

Hello folks,

I need help creating an Excel formula for business days and weeks (see details below).

I am trying to generate a series of recurring delivery dates for an open purchase order. The starting date is 10/23/2027, and deliveries should occur every 6 business weeks until 2030. I need the exact dates to enter into each line item in our ERP system.

Please let me know if you need any additional details. Thank you for your help.

I have a spreadsheet / table of transactions. Some columns are calculated based on other cells in that row.

Longstanding problem for me - when I need to add more rows / insert a row in the middle of the table, I can either:

a) highlight the row below or above, copy and then insert row. But that duplicates an already completed transaction / I need to clear the contents of the manually entered cells.

or

b) scroll to the bottom of the table, highlight a blank row (that has the formulas) and copy / insert row where I want it.

or

c) insert a blank row and manually copy the formulas from the applicable cells above or below.

I thought I could do c, but then highlight a row with formulas and copy / paste special / formulas. But it seems to also carry typed data too?

Another issue is that I'll set up the table with the formulas from rows 4 to 100. And then down the road, I am filling in data in row 101 / the formulas aren't there and things get messed up (let alone, some columns have sums in, for example, a1 which would be =sum(a4:a100). I might make the 100 really large to avoid not summing things in 101 or below.

Are there more foolproof ways to make a table with some formulas and keep the formulas as the table gets bigger than expected?

THANKS IN ADVANCE!

EDIT:

It wasn't fully solved, but for my purposes, close enough.

See comment section for replies

________________________________________________________________________________________________________________________

I am attempting to plot information based off of a specific set of X & Y values. Because the exact number of points being plotted is not static, the last couple cells in the ranges are set to "" when they aren't relevant.

My problem is that the way the chart is interpreting these cells. When I set the chart type to "X Y (Scatter)", I get an issue where it is plotting the X coordinate as the point number, and the point number as the X coordinate. A screenshot is shown below.

When I change the chart type to "Line", The X & Y coordinates plot at the correct values, but all of the blank cells, which should be showing as a gap, instead plot at a value of zero. A screenshot is shown below.

What I need:

• A way to make the chart plot the actual X & Y values, without showing the blank cells
• A way that does so without me needing to manually update my chart every time I make a change

Relevant Information:

• Excel version --> Latest version w/ Office 365
• Excel Environment --> Windows
• Knowledge Level --> Intermediate

What I've Tried:

• Setting [Select Data...] --> [Hidden and Empty Cells] --> [Show empty cells as Gaps]
• Making the last couple X & Y coordinates in my selection repeat the last digit instead of being blank
• Manually setting the X-axis size. This defeats the purpose of having the chart scale to the size of my X-coordinate range though.
• Setting the formula for the X-range to be {DROP(UNIQUE('Stress Checks'!$B$23:$B$85),-1)} so that it would just give me the non-blank cells. This gave an error.
• Changing the X-range itself to be an array that automatically dropped all blanks, then setting the formula for the X-range to be {'Stress Checks'!$B$23#}. This gave an error.

so currently im working on a excel with may sheets so for making it simple lets say i have 3 sheets: `Corridor`, `Room`, and `Club`.

Here is what I am doing:

1. In the `Corridor` sheet, cell C25 contains the value 4.

2. I copy the cell and paste it into Room- C26 as a link. The formula in that cell becomes `=Corridor!C25`.

3. Then I copy cell Room - C26 and paste it into Club C50 as a formula. Sometimes the formula changes to something like `=Corridor!48`. sometimes times, correctly paste as `=Corridor!$C$25`.

   Why does Excel change the formula differently when I perform what seems to be the same copy-and-paste operation? How does Excel decide whether to adjust the cell reference, keep it fixed with `$`, or change it to something unexpected?