Excels addition is not working

Question

Excel is not adding columns... Real headache.. It is constanly happening...

Answer 1

I'm a Mac user who spent more than 20 years with Windows as well. It might help if you'd explain how you're attempting to sum the column & provide specific examples. However, there are several common factors in Excel on the two platforms:

• The cell content may display as numbers but actually is text rather than values
• The worksheet may be set to Calculate Manually rather than Automatically
• You may be attempting to use Click to Add Mode but that option isn't enabled

If you provide a complete & accurate explanation I'm sure someone will be able to provide the remedy. Since it seems to be inconsistent I have no doubt that it is a setting rather tha a system issue.

Answer 2

Setup a very simple addition as I have done below:

Here I am adding the numbers in cells B5, B6 and B7 with a simple formula.

If you do that, and then you click on the green check mark:

... tell us exactly what happens next.

Answer 3

Hi! The best next step is to repair Microsoft 365 (Office) rather than resetting the whole PC. In Windows 11, go to Settings > Apps > Installed apps > Microsoft 365 > Modify and run Quick Repair first (fast), then if Excel still won’t insert/add columns, run Online Repair (more thorough, reinstalls Office components and fixes deeper corruption). This repair process applies to the full Office suite even if only Excel is affected, and it’s the recommended fix when an Office app starts behaving inconsistently.

Also, the message you’re seeing during “Reset this PC” can indicate Windows system file corruption or a damaged recovery environment, not just an Excel issue. If that continues, use Microsoft’s built-in system repair checks: run DISM and System File Checker (sfc /scannow) to repair Windows components, and then retry the reset only if you still need it.

Answer 4

Excel is not adding columns, it happens quite often. It's a real headache.

I reset the computer three times in last three days thinking that it would repair Excel...

The resetting goes for one hour, finished and then tells that nothing was done. Nothing happened.

The computer is twelve months old from Hewlett Packard.

HELP PLEASE...!!