{"id":489,"date":"2016-09-08T04:11:26","date_gmt":"2016-09-08T04:11:26","guid":{"rendered":"http:\/\/99excel.com\/home\/?p=489"},"modified":"2021-05-14T16:08:49","modified_gmt":"2021-05-14T16:08:49","slug":"f4-key-use-in-excel","status":"publish","type":"post","link":"https:\/\/99excel.com\/home\/f4-key-use-in-excel\/","title":{"rendered":"F4 Key use in excel"},"content":{"rendered":"

F4 Key:<\/h3>\n

\u201cF4\u201d key provides you two different outputs depending on what you are doing currently in your excel.<\/p>\n

If you are editing, then it will cycle you through the all three types of references, like \u2013 absolute reference, relative reference and mixed reference.<\/p>\n

Refer below example for detail.<\/p>\n

 <\/p>\n

As displayed in below image in the selected cell of excel, we are first using the relative reference of Cell having Student A\u2019s marks in English Subject. After pressing \u201cF4\u201d key it toggles and suggests the absolute reference of same cell and again by pressing \u201cF4\u201d key the mixed reference of the cell are suggested. If you are new to these terms of references \u2013 then you cango through this article to understand these in details.<\/p>\n

\"References<\/p>\n

In addition to toggling the reference of a cell, \u201cF4\u201d keys also repeats the last action performed in workbook. Although, this could also be achieved using \u201cCtrl + Y\u201d keys.<\/p>\n

Example: If you have just inserted or deleted a row or column in your workbook then by pressing \u201cF4\u201d key you can repeat the action of insertion or deletion of rows and \\ or columns. Likewise if you have just pasted something in your workbook, then using \u201cF4\u201d you can repeat it.<\/p>\n","protected":false},"excerpt":{"rendered":"

F4 Key: \u201cF4\u201d key provides you two different outputs depending on what you are doing currently in your excel. If you are editing, then it will cycle you through the all three types of references, like \u2013 absolute reference, relative reference and mixed reference. Refer below example for detail.   As displayed in below image … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[],"tags":[],"class_list":["post-489","post","type-post","status-publish","format-standard","hentry"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/posts\/489","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/comments?post=489"}],"version-history":[{"count":1,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/posts\/489\/revisions"}],"predecessor-version":[{"id":490,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/posts\/489\/revisions\/490"}],"wp:attachment":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/media?parent=489"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/categories?post=489"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/tags?post=489"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}