{"id":18634,"date":"2016-11-05T17:34:37","date_gmt":"2016-11-05T17:34:37","guid":{"rendered":"http:\/\/www.oracletutoring.ca\/blog\/?p=18634"},"modified":"2016-11-05T17:34:37","modified_gmt":"2016-11-05T17:34:37","slug":"excel-getting-rid-of-after-inserting-a-column","status":"publish","type":"post","link":"https:\/\/www.oracletutoring.ca\/blog\/excel-getting-rid-of-after-inserting-a-column\/","title":{"rendered":"Excel:  getting rid of ######### after inserting a column"},"content":{"rendered":"<h1>The tutor suggests a possible way to get rid of ######## in cells after inserting a column in Excel.<\/h1>\n<p>Sometimes, after you shift content by inserting a column at the left, you might find some cells become filled with ##########.  It happens to me when I add a column at the very left to create more space.  In such a case, when I select a cell that shows #########, its former value is revealed, but just isn&#8217;t showing in the cell.<\/p>\n<p>I find that selecting the cells with ########, then reformatting them as before, fixes the problem:  they once again show their values.<\/p>\n<p>HTH:)<\/p>\n<p>Jack of <a href=\"https:\/\/www.oracletutoring.ca\">Oracle Tutoring by Jack and Diane,<\/a> Campbell River, BC.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The tutor suggests a possible way to get rid of ######## in cells after inserting a column in Excel. Sometimes, after you shift content by inserting a column at the left, you might find some cells become filled with ##########. &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"more-link\" href=\"https:\/\/www.oracletutoring.ca\/blog\/excel-getting-rid-of-after-inserting-a-column\/\"> <span class=\"screen-reader-text\">Excel:  getting rid of ######### after inserting a column<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1583,1065],"tags":[],"class_list":["post-18634","post","type-post","status-publish","format-standard","hentry","category-excel","category-spreadsheets"],"_links":{"self":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/18634","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/comments?post=18634"}],"version-history":[{"count":8,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/18634\/revisions"}],"predecessor-version":[{"id":18642,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/18634\/revisions\/18642"}],"wp:attachment":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/media?parent=18634"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/categories?post=18634"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/tags?post=18634"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}