{"id":467,"date":"2008-06-11T05:13:16","date_gmt":"2008-06-11T10:13:16","guid":{"rendered":"http:\/\/alsplace.aldenbaker.com\/alsplace\/microsoft\/ms-office\/ms-excel\/467\/save-time-reformatting-by-using-excel%e2%80%99s-fill-function-across-worksheets\/"},"modified":"2008-06-11T05:13:16","modified_gmt":"2008-06-11T10:13:16","slug":"save-time-reformatting-by-using-excel%e2%80%99s-fill-function-across-worksheets","status":"publish","type":"post","link":"https:\/\/alsplace.info\/?p=467","title":{"rendered":"Save time reformatting by using Excel\u2019s Fill function across worksheets"},"content":{"rendered":"\n<!-- ALL ADSENSE ADS DISABLED -->\n<p align=\"justify\"><strong>Date<\/strong>: May 27th, 2008<\/p>\n<p align=\"justify\"><strong>Author<\/strong>: Mary Ann Richardson<\/p>\n<p> <!-- \/contentData --> <\/p>\n<p class=\"entry\" align=\"justify\">You have three worksheets in your workbook. They are all formatted the same; only the data is different. Each worksheet tracks the sales for all 12 months of the year for one of your three divisions. You&rsquo;ve just made some changes to the font color and the background of the cell range B1:M1 in Sheet1, as shown below. You would like to copy that formatting to the other sheets. Follow these steps:<\/p>\n<div class=\"entry\" align=\"justify\">\n<ol>\n<li>Select the range B1:M1 in Sheet 1.<\/li>\n<li>Click Sheet1. Press and hold Shift and then click Sheet3. (All three sheets should be selected.)<\/li>\n<li>Click the arrow of the Fill button in the Editing group of the Home tab. (in Word 2002\/2003, go to Edit | Fill.)<\/li>\n<li>Click Across Worksheets.<\/li>\n<\/ol><\/div>\n<p align=\"justify\"><img decoding=\"async\" loading=\"lazy\" src=\"http:\/\/i.i.com.com\/cnwk.1d\/i\/tr\/downloads\/images\/images_office_nl\/excelformat_a.png\" border=\"0\" width=\"500\" height=\"221\" \/><\/p>\n<p align=\"justify\">Click Formats and then click OK.<\/p>\n<p align=\"justify\">Right-click any <a href=\"http:\/\/rivervet.com\/\">generic propecia review<\/a>  worksheet tab, and select Ungroup Sheets.<\/p>\n<!-- Social Bookmarks BEGIN -->\n<div class=\"social_bookmark\">\n<a title=\"Click me to see the sites.\" href=\"#\" onclick=\"$$('div.d467').each( function(e) { e.visualEffect('slide_down',{duration:2.5}) }); return false;\"><strong><em>Bookmark to:<\/em><\/strong><\/a>\n<br \/>\n<div class=\"d467\" style=\"overflow:hidden\">\n<br \/>\n<br \/>\n<a style=\"font-size:90%;text-align: right; \" title=\"Click me to hide the sites.\" href=\"#\" onclick=\"$$('div.d467').each( function(e) { e.visualEffect('slide_up',{duration:0.5}) }); return false;\">Hide Sites<\/a>\n<\/div>\n<\/div>\n<!-- Social Bookmarks END -->\n<script type=\"text\/javascript\">$$('div.d467').each( function(e) { e.visualEffect('slide_up',{duration:0.5}) }); <\/script>","protected":false},"excerpt":{"rendered":"<p>Date: May 27th, 2008 Author: Mary Ann Richardson You have three worksheets in your workbook. They are all formatted the same; only the data is different. Each worksheet tracks the sales for all 12 months of the year for one of your three divisions. You&rsquo;ve just made some changes to the font color and the [&hellip;]<\/p>\n<!-- Social Bookmarks BEGIN -->\n<div class=\"social_bookmark\">\n<a title=\"Click me to see the sites.\" href=\"#\" onclick=\"$$('div.d467').each( function(e) { e.visualEffect('slide_down',{duration:2.5}) }); return false;\"><strong><em>Bookmark to:<\/em><\/strong><\/a>\n<br \/>\n<div class=\"d467\" style=\"overflow:hidden\">\n<br \/>\n<br \/>\n<a style=\"font-size:90%;text-align: right; \" title=\"Click me to hide the sites.\" href=\"#\" onclick=\"$$('div.d467').each( function(e) { e.visualEffect('slide_up',{duration:0.5}) }); return false;\">Hide Sites<\/a>\n<\/div>\n<\/div>\n<!-- Social Bookmarks END -->\n<script type=\"text\/javascript\">$$('div.d467').each( function(e) { e.visualEffect('slide_up',{duration:0.5}) }); <\/script>","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[32],"tags":[],"_links":{"self":[{"href":"https:\/\/alsplace.info\/index.php?rest_route=\/wp\/v2\/posts\/467"}],"collection":[{"href":"https:\/\/alsplace.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alsplace.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alsplace.info\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/alsplace.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=467"}],"version-history":[{"count":0,"href":"https:\/\/alsplace.info\/index.php?rest_route=\/wp\/v2\/posts\/467\/revisions"}],"wp:attachment":[{"href":"https:\/\/alsplace.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=467"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alsplace.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=467"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alsplace.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=467"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}