I have three line charts on three different sheets. The later two sheets are just copies of sheet 1, and are in the same location on each sheet, so that when I switch between sheets, I can easily see any differences in the chart. There are visual differences in the chart in that the slopes of the lines do not look the same.

The data on all charts is exactly the same except for start date. So, for example, my first sheet has day 1,11,21,31 on the horizontal axis, and sheet two has day 31,41,51,61 and sheet three has 101,111,121,131, etc.. The intervals between the dates are the same, and the vertical data is the same (and the vertical axis data all seems correctly positioned, I'm only having irregularities with the horizontal data).

Since I was having this problem, and the sheets are all just copies of each other with the only difference being start date, of course I figured the problem was that the start date was different. So I copied the data from sheet 1 into sheet 2 and 3 so that everything should be exactly the same (including the start date), but to my surprise, the visual oddities (different slopes of lines) remained.

Worried I had somehow altered sheet 2 and 3 without knowing it, I again made a copy of sheet 1 (now called sheet 4) and pasted in data from sheet 2, and again the slopes of the lines changed. Lastly, I repasted date from sheet 1 into sheet 4 and it did return to how it used to look (so that when I switch between sheet 1 and 4, there is no difference).

I'd like to get the line chart on sheet 2 and 3 to look exactly the same, any ideas?

I know most Excel giga users work on a PC, and I’m training to improve my Excel skills. Unfortunately, I only have access to a MacBook. Would using a Windows keyboard plugged into my Mac give me access to all the Windows Excel shortcuts? If anyone has experience with this, I’d really appreciate the help

Hi! I'm currently stuck on this math problem where I have 2 years and 9 months worth of sales data.

How should I be factoring in the last 3 months (e.g. Oct-Dec 2024) when I only have 2 points of data (2022 and 2023) whereas all other months (e.g. Jan-Sept) all have 3 points of data (2022, 2023, and 2024).

Please help... feeling very puzzled on how I should be calculating the averages for a monthly seasonal index and if any weighting should be applied... Any specific step-by-step guidance in excel would be helpful. Thanks!

https://preview.redd.it/5qn2hycgc1he1.png?width=115&format=png&auto=webp&s=178145e4cd6b6dc9e330182b28dd41e0d27a4bf7

I’m having to make a spreadsheet for work and the basics of my tasks is I have to copy thousands of files from different folders into a spreadsheet but when I paste it, it doesn’t go into the format that I want (name, size, name2, date) and I don’t know how to make it format the way I need it to so I don’t have to manually sort each set data. (This is the instructions given by my boss: Press Ctrl-A and then Ctrl-C to select and copy the entire list Paste Special this into a spreadsheet (right-click, choose ‘Paste Special’, and then Text or CSV). This ensures that only the text copies through rather than the links and images The list will need to be tidied up to remove any gaps etc that have come through from the pasting.)

I have explained this horribly but thank you for any help. I would include a ss but gotta love NDAs :)

OK, this is now getting weird. In this question, which I asked only the other day, I described how on Excel on MacOS, Cmd-V (Paste) had suddenly changed such that it only ever pasted by value. I eventually fixed it but only by completely uninstalling and then reinstalling Office 365.

Well it has just started to happen again! And that's after a few days of everything having been fine. I cannot for the life of me think of what I could have done to cause it; so much so -- and especially given that it has now happened twice -- I'm of the view that I am not the cause. Ot at least, me doing something unusual is not the cause. By most people's standards, I am an advanced Excel user, but by the standards of the folk on here I am barely out of the rookie level and don't do anything particularly funky. So I'm pretty sure it's not me doing something exotic!

I'm posting about it this time merely to record it for posterity, in case anyone else stumbles on the problem. I am not asking for help, mainly because I'm not going to spend any more time trying to fix it. Fortunately, although I usually work on Excel MacOS, I also have it in Windows on Parallels and the Windows version of Excel does not appear to be having this past problem. So, off to Windows I go.†

Finally, in the spirit of leaving clues for others who come after me, here are two things I noticed that seemed to be correlated with the primary paste issue:

1. If I Right-clicked on a column header -- e.g. to insert a new column, or to find out what the column width was -- there was a very noticeable delay before the context menu popped up. This had actually begun to re-occur about a day after I had done my uninstall/reinstall, but since the main paste problem hadn't re-emerged, I put up with it
2. As the paste problem did re-appear -- in fact, this is what alerted me to the fact that it had happened -- I noticed a weird behavior that I had seen previously. If after copying (Cmd-c) a cell I then attempted to paste it into a range of cells, I would get the popup alert that says "The data you're pasting isn't the same size as your selection...". Weird. And, as with the main paste problem, this seems to be specific to using the Apple command shortcuts for copy and paste: Cmd-c (⌘-c) and Cmd-v (⌘-v). If instead I use the Windows shortcuts -- Ctrl-v and Ctrl-v -- everything is fine.

† Well, that's Plan A. That may quickly be switched for Plan B, which is to use all this hassle as an excuse to ditch this 2020 8/8-core M1 MacBook Air, and go buy a brand new 16/40-core M4 Max MacBook Pro. Every cloud an' all that. 😇

So, I've got a spreadsheet that I use to keep track of my uber stats (I'm an uber driver). Out of curiosity, I want to try and find a way to have it automatically sum up or average certain stats based on the month. Like, say, for example, I wanted to sum up the amount earned in each month. I copied a sample of the data and would like to know if there's a way to do this without having to completely rework the formatting of what I've already got

https://preview.redd.it/rfolqei251he1.png?width=286&format=png&auto=webp&s=dff36e5d4a157780d5718c96c33c6b380576fdaf

Someone told me to enter registration name it's very repetitive but the end name is different like Qwe-R92 Qwe-Psf Qwe-scr I want to do it like i only type their end name then the first name appear after i leave the cell/press ENTER/Press TAB like i type "R92" then when i changing cells it correct automatically to "QWE-R92" i want to be efficient as possible but i don't know how to do it

Hello Excel community!

At work I’ve been constructed to Validate multiple columns from multiple excel sheets. The first thing I saw was my columns from both files had different amount of rows. i.e from pre-test to post-test.

My question is will the IF () function accurately display the values needed if returned “yes” or “no” - despite the difference in column rows.

Cheers!

Hi all,

I'm taking a Excel data management class and got super stumped on a portion of my last assignment. I had a data set and am creating a table describing characteristics of moms based on their positive or negative disease test. I have added rows showing average number of children, average maternal age, and average risk index. However, I have to add a column for proportion of those families who are living with a partner.

My living status variable is binary, 1 lives with partner, 0 lives without partner. When I add the variable to my pivot table and filter by just 1, it still combines both the lives with and without partner variables and shows them as a percent of 100, even though not all the women live with partners. I tried adding it as both a filter and a column but I can't get it to show up as the actual proportion rather than just from 100%. Can anyone help me here at all?

The y axis labels on my bar graph are 1, 2, and 3, but I need them to be AR, TX, and MO to represent what states the people in the study were born in. I can’t figure out how to change the labels.

Hi all, very novice Excel user here so appreciate the advice. When I export a file from a web-based platform all of the data appears in one column. Is there a way to move each individual variable into its own separate column?

Hi there! I am failing at describing this well enough for a google search, so I hope some humans can understand what I need. I have a table of 4 columns (Type, Rarity, Variant, Value). In this table, there are no rows that are complete duplicates of any other, and the Value is filled in.

In another table, I will be filling in the Type, Rarity, and Variant, but I want the Value to automatically populate based on those other 3 pieces of info. Any sort of working function that I can just paste down that column will work for me.

Currently, my completed Value table is J2:M14 (including headers), and my Type/Rarity/Variant columns are B, C, and D. So B50, C50, and D50 would be referenced to pull the correct Value from J2:M14 and output it in E50.

Let me know if anything doesn't make sense, and thank you for your help!

=IF(OR(C252>=E252, C252<=F252), 1, IF(G253=0, 0, G253+1))

I have a formula that checks cell C252 to see if it breaks the threshold in cells E252 or F252. It then puts a value of 0 in column G if no breach occurs or the number of rows that have passed previously if a breach has occured. The formula works well for all that has been explained.

However, I need column G to reset to 1 in the next row if a breach has occured. Since column G reports the amount of rows previously before the breach once a breach occurs it should start counting fresh again.

Hello!

I have been trying to copy and paste values filtered data, but I am finding it very difficult.

Trying to copy the filtered values on Column BC to Column F.

In the picture above COLUMN BC are extracted values from a formula. Now, I am trying to copy and paste the values only on COLUMN F.

I have tried various methods by selecting the visible filtered data by using: "CTRL + G" and/or "ALT +; "

The outcomes are,

1. I get an error, "This action won't work on multiple selections."
2. It gets pasted on the first cell only.

Is there a solution for this, or am I just tackling it wrong?

Hello! I’m trying to cross reference two spreadsheets linked by phone numbers.

On one spreadsheet the phone number format is 1234567890 (fine)

On the other it’s 123 456-7890 (bad)

Can I easily reformat the bad one into the good one? Thank you!

I work in distribution and every morning we get a routing chart, I've been charged with going over the routing and finding any routes that could be combined together based on delivery area and truck sizes, I want to build a macro that basically finds all combinable routes for me but don't have any idea where to begin.

Excel on Mac does not have a clipboard to view recent copies. Anybody know how to do this without tedious formulas?

Hey i have some need to batch process some rows in spreadsheet with web search or with AI, looking for some tools could automate spreadsheet filling for batch processing and better to connect to GPT or other AI.

Accidentally found Krew and their demo seems really cool, anyone use that before or is there any other recommendations?

Hey guys, I have an excel sheet with several data of electricity production at different times of the year. To use them, I need to convert them in the same unit (MW) . For example a cell has "107 MW", an other "2 GW" and another "700 kW".

To do so, I thought I could use a power query to identify the text in the cell, and apply a conversion factor based on it (for example : if "GW then multiply by 1000"), but I cannot make it work. Do you have any idea on how to do that ?

Hey, I'm trying to reverse engineer dates from free text fields from a file extract.

For example, using the value of "1 week ago", I'd like to subtract that from todays date and turn it into "28/01/2025". The date format isn't too crucial, just so long as it's considered a date value that can be manipulated into pie charts later.

Other example values include "3 years ago", "Last month", "20 minutes ago".

Basics trying to reverse engineer what DATEDIF outputs when using k as the unit.

Is this possible? Thanks in advance!

I load data from a SQL table into excels files daily. Whenever I create a new query I updated the table properties to not adjust column width (Table Design - External Table Data - Properties, usually via the Alt-JT-P-A shortcut) and for last week it has locked up, closed, and opened in recovery each time i've done that.

I've restarted my PC numerous times and it's still happening. I've been doing this for a while without issue and just wondering if anyone knows of a setting that got changed (or I can change). We have an internal IT dept but they're not the best at MS issues like this one.

I have an excel sheet with multiple cells changing dynamically all the time. I’m trying to find a way to make one specific cell (that is changing all the time) be linked to an iPhone shortcut so that can be updated in real time on my phone. I have excel office 365, shortcuts, Google sheets/scripts and would be able to make it work in Scriptable. If anyone had any help that would be amazing. I have tried asking ChatGPT and the internet (with Power Automate) but nothing is exactly solving my problem! Any help or point in the right direction would be amazing. Thanks in advance.

Using an IF statement and would like some of the outputs to have a superscript to direct the user to a footer. For example I would like the output to be A^3 but the three should be small

Question - can you conditionally format cells so that for example if the text in celll C2 on sheet 1, matches the text in cell C2 on sheet 2?

I have 2 workbooks which are both capturing the same data for clients at work. However there has been some duplication on these sheets as people have updated the same client in different workbooks (picking up this project from the person who started) so need to reconcile which sheet contains the correct and most recent data for those duplicates. I’ve put both sheets into the same file and have a third sheet which I’ve in put =‘sheet1’C2=‘sheet2’C2 which tells me if there is a match however it would be helpful if I could see sheet 1 and have it flag cells in red if the text in the same cell on sheet 2 is different. I couldn’t seem to get this to work in the conditional formatting section.

Failing that I might just add another column to identify the original source sheet, put all data into one sheet and then sort by the client name and I can compare the duplicates and delete the row which has the old data which will leave me with my start point. Now I’m typing this out this sounds the more logical solution here as I can then see both sets of data together and where the False matches are actually blanks in one sheet………

Any ideas welcome!

I run an outstanding report monthly, starting at the top, go through each row, call the client, and write the notes from the call at the end of the row.

I'm trying to find a formula that would search the previous months report for the same name and number. If there is a match, copy my notes onto the new report so I don't have to copy and paste them individually.

Sorry if this isn't worded very well, I'm not sure how to ask the question.

Hi, I am working on a project for fun where I rank albums I listend to. I have a excel document with all the information and I like to share them with my friends. I have a few different sheets, one of them is album suggestions. I would like it to be that if I share this document with anyone they can only edit that sheet but can still see the other sheet, while I can edit every sheet. I tried protecting the sheets but than I can no longer edit the sheets. I asked ChatGPT for some advise, it made some code that I thought worked but it didn't I was editing another sheet. I am new to excell so no idea how the code works. Can anyone help? :)

I changed \"Password\" it was the right password and some things may be in dutch

I have a worksheet that tracks items at the vendors my company uses.

I have a "Received column" and a "DUE" column. I have a difference column that uses this statement:

=IF([@Received]="","",[@DUE]-[@Received])

Is there a way to include "NETWORKDAYS" or something similar to only count business days and leave out weekends?

Hi - I've created a GANTT chart in excel where each timeframe for each row is colored green. I'm trying to highlight the column with the most number of green-colored cells to indicate that that column(s) have the highest number of overlapping activities in a given timeframe. Tried googling answers but I always get an answer about highlighting the cell with the highest number of value which doesn't help in my case.

Help please?

I have used the Office 365 Removal Tool. Reinstalled it continues to happen. Try and Print to my Konica Minolta C450i and it fails to print and then starts to act odd.

If I click a cell, I get 5 cells vertically picked.

If I try and click File I get "cannot quit Microsoft excel" error message.

I have to End Task in the Task Manager.

I have tried;

1. Disable Extend Selection:

• Go to File > Options > Advanced.
• Under the Editing section, uncheck the box next to Extend selection.
• This will prevent Excel from automatically expanding your selection when you click and drag.

2. Check Conditional Formatting:

• Open the Home tab and click Conditional Formatting > Manage Rules.
• Look for any rules that apply to the entire row based on the values in any cell.
• If you find such a rule, try deleting it or modifying it to only highlight the specific cell(s) you want.

3. Verify Add-ins:

• Some add-ins, especially ones related to data validation or automation, can interfere with cell selection.
• Go to File > Options > Add-ins.
• Click COM Add-Ins and then Go.
• Uncheck any add-ins you suspect might be causing the issue and restart Excel.

4. Check Linked Names:

• If your cell has a linked name that applies to the entire row, this could be causing the highlighting.
• Right-click the cell and select Insert > Defined Name.
• Check if there's a name defined for the cell that includes the entire row (e.g., A1:A10). Delete it if you don't need it.

5. Reset View Settings:

• Sometimes, custom view settings like hidden rows or frozen panes can cause unexpected behavior.

• Go to the View tab and click Normal.

• If the problem persists, try closing and reopening the workbook.

I have updated Windows 11. I have updated all the drivers for the Copier. I have updated Office 365.

Other Office Products, Outlook, Word Ect all print and act fine. I will post some photos.