![]() ![]() The F4 key allows adding the dollar sign ($) with a single keystroke. One of its common uses is to lock references to make a cell reference absolute. What Does F4 Do in Absolute Referencing in Excel?į4 is one of the most-used keyboard shortcuts in Excel. For example, if you want to lock the value of Cell B2, then it will look like $B$2 with absolute cell reference. This can be done by simply putting the dollar ($) sign before the cell references. ![]() What is Absolute Cell Reference in Excel?Ībsolute cell reference in Excel is used when we want to lock the position of selected cells in any formula so that its value will be fixed and won’t be changed whenever the cells are being copied to other cells or sheets.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |