{"id":1550,"date":"2012-05-11T17:38:26","date_gmt":"2012-05-11T21:38:26","guid":{"rendered":"http:\/\/www.rexfeng.com\/blog\/?p=1550"},"modified":"2012-05-11T17:38:26","modified_gmt":"2012-05-11T21:38:26","slug":"excel-format-painter-double-click-hot-tip","status":"publish","type":"post","link":"https:\/\/www.rexfeng.com\/blog\/2012\/05\/excel-format-painter-double-click-hot-tip\/","title":{"rendered":"Excel Format Painter: Double Click Hot Tip"},"content":{"rendered":"<div id=\"attachment_1551\" style=\"width: 550px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1551\" class=\"size-large wp-image-1551\" title=\"FormatPainter\" src=\"http:\/\/www.rexfeng.com\/blog\/wp-content\/uploads\/2012\/05\/FormatPainter-540x286.png\" alt=\"\" width=\"540\" height=\"286\" srcset=\"https:\/\/www.rexfeng.com\/blog\/wp-content\/uploads\/2012\/05\/FormatPainter-540x286.png 540w, https:\/\/www.rexfeng.com\/blog\/wp-content\/uploads\/2012\/05\/FormatPainter-150x79.png 150w, https:\/\/www.rexfeng.com\/blog\/wp-content\/uploads\/2012\/05\/FormatPainter-300x159.png 300w, https:\/\/www.rexfeng.com\/blog\/wp-content\/uploads\/2012\/05\/FormatPainter.png 713w\" sizes=\"auto, (max-width: 540px) 100vw, 540px\" \/><p id=\"caption-attachment-1551\" class=\"wp-caption-text\">Format Painter in Excel 2003<\/p><\/div>\n<p>For all those who live in MS Excel (myself included), here&#8217;s a nifty tip paraphrased from <a href=\"http:\/\/www.accountingweb.com\/topic\/technology\/microsoft-excel-thirteen-double-click-tricks\">AccountingWeb<\/a>:<\/p>\n<blockquote><p>Double Click the Format Painter to lock the Format Painter. Paste the format into as many cells as you want then hit the Escape Key.<\/p><\/blockquote>\n<p>When I found out about the Format Painter several years ago, my mind was blown. It&#8217;s one of those small things that once you learn, it becomes essential. This tip lets you paste the cell formatting into as many cells as you want without having to go back and click the Format Painter icon before each paste.<\/p>\n<p>I&#8217;ve tried double clicking on Format Painter in both Excel 2003 and newer versions (2007 I think), and it works.<\/p>\n<p>It&#8217;s the <a href=\"http:\/\/www.codinghorror.com\/blog\/2012\/05\/this-is-all-your-app-is-a-collection-of-tiny-details.html\">details that count<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>For all those who live in MS Excel (myself included), here&#8217;s a nifty tip paraphrased from AccountingWeb: Double Click the Format Painter to lock the Format Painter. Paste the format into as many cells as you want then hit the Escape Key. When I found out about the Format Painter several years ago, my mind [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[1010,1009,1012,1011],"class_list":["post-1550","post","type-post","status-publish","format-standard","hentry","category-tech","tag-double-click","tag-excel","tag-format-painter","tag-tips"],"_links":{"self":[{"href":"https:\/\/www.rexfeng.com\/blog\/wp-json\/wp\/v2\/posts\/1550","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rexfeng.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rexfeng.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rexfeng.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rexfeng.com\/blog\/wp-json\/wp\/v2\/comments?post=1550"}],"version-history":[{"count":3,"href":"https:\/\/www.rexfeng.com\/blog\/wp-json\/wp\/v2\/posts\/1550\/revisions"}],"predecessor-version":[{"id":1554,"href":"https:\/\/www.rexfeng.com\/blog\/wp-json\/wp\/v2\/posts\/1550\/revisions\/1554"}],"wp:attachment":[{"href":"https:\/\/www.rexfeng.com\/blog\/wp-json\/wp\/v2\/media?parent=1550"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rexfeng.com\/blog\/wp-json\/wp\/v2\/categories?post=1550"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rexfeng.com\/blog\/wp-json\/wp\/v2\/tags?post=1550"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}