{"id":735,"date":"2022-05-25T08:55:00","date_gmt":"2022-05-24T22:55:00","guid":{"rendered":"https:\/\/goodgeeky.com\/?p=735"},"modified":"2022-05-25T11:34:45","modified_gmt":"2022-05-25T01:34:45","slug":"how-to-change-excel-column-labels-to-numbers-and-back-to-letters-again","status":"publish","type":"post","link":"https:\/\/goodgeeky.com\/how-to-change-excel-column-labels-to-numbers-and-back-to-letters-again\/","title":{"rendered":"How to change EXCEL column labels to numbers and back to letters again"},"content":{"rendered":"\n<p>In this quick one-minute tutorial, I show you how to switch between the R1C1 and A1 formats in Excel. <\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<div class=\"youtube-embed\" data-video_id=\"BTTPjOZCTBA\"><iframe loading=\"lazy\" title=\"Excel Quick Tip: How to Switch Between R1C1 and A1 Formats in 1 Minute\" width=\"696\" height=\"392\" src=\"https:\/\/www.youtube.com\/embed\/BTTPjOZCTBA?feature=oembed&#038;enablejsapi=1\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe><\/div>\n<\/div><\/figure>\n\n\n\n<p>Sometimes you may get an Excel spreadsheet where the columns are labeled with numbers instead of letters, and the formula will look different as a result. Where columns are labeled with numbers, we call that the R1C1 reference style. <\/p>\n\n\n\n<p>When columns are labeled with numbers, we call that the A1 reference style. <\/p>\n\n\n\n<p>There&#8217;s no real difference in what you can do with either R1C1 or A1, but if you&#8217;re used to working with one format or the other, it&#8217;s good to know how to switch between them in case you get a spreadsheet set to the format you don&#8217;t normally work with.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this quick one-minute tutorial, I show you how to switch between the R1C1 and A1 formats in Excel. <\/p>\n","protected":false},"author":2,"featured_media":738,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[11,10],"tags":[35],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/goodgeeky.com\/wp-content\/uploads\/2022\/05\/tpn8jvj4pyo.jpg?fit=1600%2C1067&ssl=1","_links":{"self":[{"href":"https:\/\/goodgeeky.com\/wp-json\/wp\/v2\/posts\/735"}],"collection":[{"href":"https:\/\/goodgeeky.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/goodgeeky.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/goodgeeky.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/goodgeeky.com\/wp-json\/wp\/v2\/comments?post=735"}],"version-history":[{"count":0,"href":"https:\/\/goodgeeky.com\/wp-json\/wp\/v2\/posts\/735\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/goodgeeky.com\/wp-json\/wp\/v2\/media\/738"}],"wp:attachment":[{"href":"https:\/\/goodgeeky.com\/wp-json\/wp\/v2\/media?parent=735"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/goodgeeky.com\/wp-json\/wp\/v2\/categories?post=735"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/goodgeeky.com\/wp-json\/wp\/v2\/tags?post=735"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}