check the automatic calculation option

How to Turn On Automatic Calculation in Excel 2013

Formulas make it much simpler to compare and evaluate data in your Microsoft Excel 2013 workbooks. By creating a formula you can enable Excel to perform mathematical functions with the numbers that you have entered into your cells. But the calculation of those functions can be set to occur either automatically or manually, so you … Read more

turn off the paste options button

How to Hide the Paste Options Button in Excel 2010

When you paste data into a cell in Microsoft Excel 2010, it is usually accompanied with a Paste Options button that appears near the target cell. This button provides additional pasting options that will allow you to┬ámodify the way that the copied data is pasted into the new location. But this Paste Options button can … Read more