Class 6 Exam  >  Class 6 Notes  >  How to become an Expert of MS Excel  >  Absolute References with the F4 Key

Absolute References with the F4 Key | How to become an Expert of MS Excel - Class 6 PDF Download

  • If you're typing a formula, you may sometimes want a cell reference to stay locked on a specific cell or cell range even if the formula is copied. To do this, you'll need to change the cell reference to an absolute reference by adding dollar signs before the row and column (for example, $D$2).
  • Although you can type the dollar signs manually, the F4 key on your keyboard allows you to add both dollar signs with a single keystroke. If you create formulas frequently, this shortcut can save you a lot of time.
The document Absolute References with the F4 Key | How to become an Expert of MS Excel - Class 6 is a part of the Class 6 Course How to become an Expert of MS Excel.
All you need of Class 6 at this link: Class 6
94 videos|62 docs|15 tests

Top Courses for Class 6

94 videos|62 docs|15 tests
Download as PDF
Explore Courses for Class 6 exam

Top Courses for Class 6

Signup for Free!
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
10M+ students study on EduRev
Related Searches

practice quizzes

,

video lectures

,

past year papers

,

ppt

,

Viva Questions

,

Exam

,

Absolute References with the F4 Key | How to become an Expert of MS Excel - Class 6

,

Objective type Questions

,

shortcuts and tricks

,

Previous Year Questions with Solutions

,

Free

,

Extra Questions

,

Absolute References with the F4 Key | How to become an Expert of MS Excel - Class 6

,

study material

,

MCQs

,

mock tests for examination

,

Semester Notes

,

pdf

,

Sample Paper

,

Absolute References with the F4 Key | How to become an Expert of MS Excel - Class 6

,

Important questions

,

Summary

;