{"id":1518,"date":"2025-11-08T10:58:20","date_gmt":"2025-11-08T10:58:20","guid":{"rendered":"https:\/\/hlrnet.com\/sites\/ebp\/?p=1518"},"modified":"2025-11-08T10:58:20","modified_gmt":"2025-11-08T10:58:20","slug":"my-6-favorite-excel-features-that-almost-nobody-talks-about","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/sites\/ebp\/my-6-favorite-excel-features-that-almost-nobody-talks-about\/","title":{"rendered":"\u00abMy 6 favorite Excel features that almost nobody talks about\u00bb"},"content":{"rendered":"<p>My 6 favorite Excel features that almost nobody talks about<br \/>\n<a href=\"https:\/\/www.makeuseof.com\/favorite-excel-features-that-almost-nobody-talks-about\/\" class=\"autohyperlink\">www.makeuseof.com\/favorite-excel-features-that-almost-nobody-talks-about\/<\/a><\/p>\n<section id=\"article-body\" class=\"article-body adsninja-injected-repeatable-ad-beforeend\">\n<div class=\"content-block-regular\">\n<ol>\n<li id=\"f4-to-repeat-your-last-action\">F4 to repeat your last action. The fastest way to apply formatting without touching your mouse<\/li>\n<li class=\"body-img landscape \">The Filled Map. Turn location data into a real map in two clicks<picture>\u00a0<source srcset=\"https:\/\/static0.makeuseofimages.com\/wordpress\/wp-content\/uploads\/wm\/2025\/11\/two-filled-maps-on-an-excel-spreadsheet-with-three-columns.png?q=49&amp;fit=crop&amp;w=825&amp;dpr=2\" media=\"(max-width: 1023px)\" data-srcset=\"https:\/\/static0.makeuseofimages.com\/wordpress\/wp-content\/uploads\/wm\/2025\/11\/two-filled-maps-on-an-excel-spreadsheet-with-three-columns.png?q=49&amp;fit=crop&amp;w=825&amp;dpr=2\" \/><\/picture><\/li>\n<li id=\"show-all-formulas-ctrl\">Show All Formulas (Ctrl + `).\u00a0One shortcut to audit a sheet without clicking cell-by-cell<\/li>\n<li id=\"start-with-an-apostrophe-to-force-text-entry\">Start with an apostrophe to force text entry.\u00a0When you want Excel to stop helping and keep what you typed<\/li>\n<li id=\"convert-your-data-range-into-a-table-ctrl-t\">Convert your data range into a table (Ctrl + T).\u00a0The easiest way to keep your data structured and expandable<\/li>\n<li id=\"name-manager-ctrl-f3\">Name Manager (Ctrl + F3).\u00a0Keep your formulas readable<\/li>\n<\/ol>\n<div class=\"body-img landscape \"><\/div>\n<\/div>\n<\/section>\n<footer class=\"article-footer\">\n<div id=\"footer-threads\" class=\"footer-threads\">\n<div class=\"w-footer-threads\">\n<div class=\"thread-footer-notes\"><\/div>\n<\/div>\n<\/div>\n<\/footer>\n<div id=\"adsninja-ad-zone-adsninja-ad-unit-outstream-607d67070ca18c\" class=\"adsninja-ad-zone an-zone  an-zone-content-outstream  an-can-float  an-can-close  an-can-change  an-injector-zone  adsninja-valstream an-zone-vp  adsninja-ad-zone-not-using-space \" data-key=\"content_outstream_adsninja-ad-unit-outstream-607d67070ca18c\">\n<div id=\"dynamically-injected-refresh-ad-zone-adsninja-ad-unit-outstream-607d67070ca18c\" class=\"dynamically-injected-refresh-ad-zone\">\n<div class=\"ad-current\" data-adreal-not-merge=\"1\" data-adreal-yellow=\"1\" data-adreal-hashes=\"de94f47090,a6e114acc4\" data-adreal-node=\"1\" data-adreal-sent=\"1\" data-adreal-ad-id=\"1762597977332382\">\n<div id=\"ad-zone-container-adsninja-ad-unit-outstream-607d67070ca18c\" class=\"ad-zone-container ad-zone-container-content-outstream adsninja-ad-zone-container-with-set-height  ad-zone-container-background-details-enabled  ad-zone-container-loading-animation-enabled  ad-loading \" data-no-fill-collapsable=\"false\" data-adreal-not-merge=\"1\" data-adreal-yellow=\"1\" data-adreal-hashes=\"de94f47090,a6e114acc4\">\n<div id=\"ad-zone-size-container-adsninja-ad-unit-outstream-607d67070ca18c\" class=\"ad-zone-size-container ad-zone-size-container-content-outstream\" data-adreal-not-merge=\"1\" data-adreal-yellow=\"1\" data-adreal-hashes=\"de94f47090,a6e114acc4\">\n<div class=\"ad-zone ad-zone-content-outstream  \" data-height-regular=\"169px\" data-width-regular=\"300px\" data-height-floating=\"169px\" data-width-floating=\"300px\" data-floating-mode=\"always\" data-waypoint-offset=\"0\" data-position=\"bottom-right\" data-use-close-button=\"true\" data-float-until-viewed=\"false\" data-float-until-viewed-delay=\"0\" data-is-floating=\"false\" data-floating-allowed=\"true\" data-click-to-float=\"false\" data-floating-setup=\"true\" data-adreal-not-merge=\"1\" data-adreal-yellow=\"1\" data-adreal-hashes=\"de94f47090,a6e114acc4\">\n<div class=\"ad-zone-inline ad-zone-inline-content-outstream\" data-adreal-not-merge=\"1\" data-adreal-yellow=\"1\" data-adreal-hashes=\"de94f47090,a6e114acc4\">\n<div id=\"adsninja-ad-unit-outstream-607d67070ca18c\">\n<div class=\"an-vp-int an-vp-int-playlist an-vp-int-transitioning\">\n<div class=\"an-vp-int-details\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>My 6 favorite Excel features that almost nobody talks about <a href=\"http:\/\/www.makeuseof.com\/favorite-excel-features-that-almost-nobody-talks-about\/\" class=\"autohyperlink\">www.makeuseof.com\/favorite-excel-features-that-almost-nobody-talks-about\/<\/a> F4 to repeat your last action. The fastest way to apply formatting without touching your mouse The Filled Map. Turn location data into a real map in two clicks\u00a0 Show All Formulas (Ctrl + `).\u00a0One shortcut to audit a<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[30,33],"tags":[24],"class_list":["post-1518","post","type-post","status-publish","format-standard","hentry","category-en","category-tools","tag-excel"],"publishpress_future_action":{"enabled":false,"date":"2026-05-01 05:20:42","action":"change-status","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/sites\/ebp\/wp-json\/wp\/v2\/posts\/1518","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/sites\/ebp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/sites\/ebp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/sites\/ebp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/sites\/ebp\/wp-json\/wp\/v2\/comments?post=1518"}],"version-history":[{"count":1,"href":"https:\/\/hlrnet.com\/sites\/ebp\/wp-json\/wp\/v2\/posts\/1518\/revisions"}],"predecessor-version":[{"id":1519,"href":"https:\/\/hlrnet.com\/sites\/ebp\/wp-json\/wp\/v2\/posts\/1518\/revisions\/1519"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/sites\/ebp\/wp-json\/wp\/v2\/media?parent=1518"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/sites\/ebp\/wp-json\/wp\/v2\/categories?post=1518"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/sites\/ebp\/wp-json\/wp\/v2\/tags?post=1518"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}