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.
2
-
1Are "a,b,c,d,e,f,g,h" the column letters, or the column-header names?– mirimirAug 10, 2014 at 1:14
-
1What does "the paste does not work" mean exactly? You get an error message? An unexpected result?– Mike HoneyAug 11, 2014 at 1:44
Add a comment
|
2 Answers
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.
answered Aug 9, 2014 at 19:30
G-Man Says 'Reinstate Monica'G-Man Says 'Reinstate Monica'
7,83722 gold badges41 silver badges87 bronze badges
-
-
Hiding columns doesn't affect copying and pasting. If the target sheet has a hidden column, cells will still be pasted there.– mirimirAug 10, 2014 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.
