Preventing a spreadsheet formula from changing when copyingWhen a formula is created in a Microsoft Excel spreadsheet or another spreadsheet program it is created using a relative cell reference by default. When copying a formula that is using a relative cell reference the formula is going to become relative to where it is being pasted. For example, if you have a formula in cell B2 that was "=A2"...
-
Keyboard Shortcuts
Shortcut keys help provide an easier and quicker method of navigating and executing commands in the computer software.
-
Hardware Tips
Learn about the latest computer hardware and find out how to diagnose
-
Knowledge Practise questions and answers
Here you can practise more questions and answers to improve your knowledge on computer
Showing posts with label Preventing a spreadsheet formula from changing when copying. Show all posts
Showing posts with label Preventing a spreadsheet formula from changing when copying. Show all posts
Tuesday, 9 January 2018
Categories
- Help (6)
- Internet Help (6)
- Keyboard Shortcuts (4)
- Mozilla Firefox shortcut keys (2)
- Ms excel (2)
- Software tips (6)
- YouTube Tips (2)