title: How do I create a macro in Excel to hide every other column
body: <p>How do I create a macro in Excel to hide every other column</p>
  
  <p>I currently have an Excel spreadsheet with each column representing a particular type of data (i.e artist, album, title) in a music file. </p>
  
  <p>What I would like to do is show changes by having two columns for each type of data (i.e artistOld, artistCurrent, albumOld, albumCurrent, titleOld, titleCurrent) but most of the time user would not want to see the old columns so what I want is a Macro that simply shows/hides the <em>Old</em> columns.</p>
  
  <p>BTW I am ware that you can add comments (like tooltips) when you hover over a cell so in theory  this would be a way to store old data, but this is not what I want. I want the user to be able to see all the data at the same time not just the old data for one particular field.</p>
  
  <p>Screenshot without the old value column</p>
  
  <p><a href="https://i.stack.imgur.com/OMNu5.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OMNu5.jpg" alt="enter image description here"></a></p>