Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have been using Excel for years to compile records of baseball gloves I have repaired. I was assembling an all time mega Excel spreadsheet, and found that in one of the templates I had made, I had the columns listed a,b,c,d,e,f,g,h. But in the second template [how I got two I will never know], I had deleted the second columnn [B], so that spreadsheet reads a,c,d,e,f,g,h etc. The problem is that when I just want to take the entire information from year 2009, and cut and paste it into the newer template, the paste does not work.

share|improve this question
Are "a,b,c,d,e,f,g,h" the column letters, or the column-header names? – mirimir Aug 10 '14 at 1:14
What does "the paste does not work" mean exactly? You get an error message? An unexpected result? – Mike Honey Aug 11 '14 at 1:44

I don't believe that it's possible in Excel to delete a column and leave a gap in the column names.  You have probably hidden column B.  Select columns A and C (by clicking and dragging in the column headers) and right-click; you should see an Unhide option.

share|improve this answer
I concur. This is likely the case. +1 – LPChip Aug 9 '14 at 20:04
Hiding columns doesn't affect copying and pasting. If the target sheet has a hidden column, cells will still be pasted there. – mirimir Aug 10 '14 at 1:13

Have you tried adding the column in the problem spreadsheet, copying the resulting spreadsheet into your copy buffer and paste it into the spreadsheet without the problem.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.