{"id":279,"date":"2015-06-25T04:54:54","date_gmt":"2015-06-25T04:54:54","guid":{"rendered":"https:\/\/4it.com.au\/kb\/?post_type=article&#038;p=279"},"modified":"2015-06-25T04:54:54","modified_gmt":"2015-06-25T04:54:54","slug":"how-to-enter-the-same-data-in-multiple-cells-in-microsoft-excel","status":"publish","type":"article","link":"https:\/\/4it.com.au\/kb\/article\/how-to-enter-the-same-data-in-multiple-cells-in-microsoft-excel\/","title":{"rendered":"How to Enter the Same Data in Multiple Cells in Microsoft Excel"},"content":{"rendered":"<p>If you need to enter the <strong>same data in multiple cells<\/strong> (not necessarily adjoining) using Microsoft Excel here&#8217;s how to do it.<\/p>\n<h2>Step 1. Highlight the Cells<\/h2>\n<p>Press and Hold the Control\u00a0Key (CTRL)<\/p>\n<p>Select the Cells with your mouse that you wish the data to be entered in to. \u00a0The cells do not need to be adjoining<\/p>\n<h2>Step 2. Release the Control Key<\/h2>\n<p>After you have got all the required cells selected\/highlighted release the Control Key. \u00a0Do not click anywhere else on the sheet.<\/p>\n<h2>Step 3. Type in the Text or Number<\/h2>\n<p><a href=\"https:\/\/4it.com.au\/kb\/wp-content\/uploads\/2015\/06\/Enter-Data-Multiple-Cells-Excel-2013.png\"><img class=\"aligncenter size-full wp-image-280\" data-original=\"https:\/\/4it.com.au\/kb\/wp-content\/uploads\/2015\/06\/Enter-Data-Multiple-Cells-Excel-2013.png\" alt=\"Enter-Data-Multiple-Cells-Excel-2013\" width=\"542\" height=\"438\" \/><\/a><\/p>\n<p>Straight after releasing the control key type in the Text or Number and press <strong>CTRL + ENTER<\/strong><\/p>\n<p>The information should be now populated in all the cells that you had highlighted in the earlier steps.<\/p>\n<h2>Conclusion<\/h2>\n<p>Entering the same data in multiple cells at the same time might take a bit of practice the first time you do it. \u00a0If you click anywhere else on the sheet after releasing the Control Key it may not work as expected. \u00a0It&#8217;s also important to note that the last cell you selected will not usually show as being highlighted\/selected as it is the active cell.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<div style='text-align:left' class='yasr-auto-insert-visitor'><\/div>","protected":false},"excerpt":{"rendered":"<p>If you need to enter the same data in multiple cells (not necessarily adjoining) using Microsoft Excel here&#8217;s how to do it. Step 1. Highlight the Cells Press and Hold the Control\u00a0Key (CTRL) Select the Cells with your mouse that you wish the data to be entered in to. \u00a0The cells do not need to [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","article-category":[56],"article-tag":[271,268,270,269],"class_list":["post-279","article","type-article","status-publish","format-standard","hentry","article-category-microsoft-office","article-tag-enter-data-in-multiple-cells-excel-non-adjacent","article-tag-enter-data-multiple-cells-excel","article-tag-excel-enter-numbers-in-multiple-cells","article-tag-excel-enter-text-in-multiple-cells"],"yasr_visitor_votes":{"stars_attributes":{"read_only":false,"span_bottom":false},"number_of_votes":14,"sum_votes":49},"_links":{"self":[{"href":"https:\/\/4it.com.au\/kb\/wp-json\/wp\/v2\/article\/279","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/4it.com.au\/kb\/wp-json\/wp\/v2\/article"}],"about":[{"href":"https:\/\/4it.com.au\/kb\/wp-json\/wp\/v2\/types\/article"}],"author":[{"embeddable":true,"href":"https:\/\/4it.com.au\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/4it.com.au\/kb\/wp-json\/wp\/v2\/comments?post=279"}],"version-history":[{"count":0,"href":"https:\/\/4it.com.au\/kb\/wp-json\/wp\/v2\/article\/279\/revisions"}],"wp:attachment":[{"href":"https:\/\/4it.com.au\/kb\/wp-json\/wp\/v2\/media?parent=279"}],"wp:term":[{"taxonomy":"article-category","embeddable":true,"href":"https:\/\/4it.com.au\/kb\/wp-json\/wp\/v2\/article-category?post=279"},{"taxonomy":"article-tag","embeddable":true,"href":"https:\/\/4it.com.au\/kb\/wp-json\/wp\/v2\/article-tag?post=279"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}