If I have a cell in a Microsoft Excel spreadsheet that contains a fixed number, and I want to add another fixed number, is there an easy way to do that?
For example, cell A1 contains
23.4524, and I want to add
8.3 to that number, giving
I know I can faff around with "paste special", use a formula (so the cell content is actually
=23.4524+8.3) or work it out in my head/with a calculator, but they all seem too heavyweight for what I'd expect to be a simple operation.
Update: What I'd hoped for was something along the lines of editing the cell to read
23.4524+8.3 then pressing a shortcut or function key to have Excel replace that with the calculated value.
That only requires F2, +, 8, ., 3, Enter, ???. No need to use multiple cells, move my hands from the home row, or launch a separate application.
The use case is trying to edit a bunch of cells that currently contain fixed values in an existing spreadsheet used for project tracking. I want to make different additions and subtractions to a bunch of different project estimates, so things like paste-special will work but are relatively slow, and while mental arithmetic is my current solution, it seems odd that it's necessary when I'm sat in front of a hulking great calculator.
<rant>I'm not expecting Excel to be psychic; I don't think I said anything to imply that. I think the speed with which I was hit with a -5 and had the question closed was shockingly aggressive and unwelcoming when a comment asking for clarification would have sufficed.</rant>