How to Increase the Values in Microsoft Excel Cells

Save

Microsoft Excel is a spreadsheet program that is used to store data which can be manipulated in a variety of ways. Data is stored in a tabular fashion, with columns and rows comprised of cells. Each cell contains a separate piece of information and can have a variety of mathematical operations performed on it. It is also possible to simultaneously increase the value of each selected cell.

  • Click the "Start" or Windows button in the lower left corner of the screen, then scroll to "Microsoft Office".

  • Select "Microsoft Excel" to launch it.

  • Click the "File" or Windows button at the top of the screen and choose "Open" to open a previously created document, or begin editing the blank document that is on the screen.

  • Type a value into any blank cell that indicates the amount that you would like to increase the cell values.

  • Copy this cell's contents by clicking it once, then pressing "Ctrl + C" on your keyboard.

  • Click in the top left corner of the cell range whose values you would like to increase, then drag your selection window to the lower right corner of the cell range. If you want to select multiple cells that are not adjacent, hold the "Ctrl" button while you click on those cells individually.

  • Right click on one of your selected cells and choose the "Paste Special" option.

  • Click the "Add" or "Multiply" option under "Operation" to choose how you would like to increase the values of your selected cells.

  • Click the "OK" button to increase the values of the cells.

Tips & Warnings

  • It is possible to use your copied cell value to multiple, add, subtract or divide from your selected target cells.

References

Promoted By Zergnet

Comments

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!