Excel can't get rid of column 1 column 2 header names fix (remove table)

Channel:
Australia Magic Monk
Subscribers:
65,900
Published on ● Video Link: https://www.youtube.com/watch?v=vbBjorhrLs0


Duration: 2:45
88,148 views
374

One of my students accidentally converted her data into a table in Excel, and all these random headings called "column 1" and "column 2" showed up, and she can't get rid of that row by using the normal delete row function. Here's the tutorial on how to get rid of those column names / headers and how to convert the table back into normal cells.



Other Videos By Magic Monk


2014-11-14Solving simultaneous inequalities
2014-11-14Sybil Cut tutorial part 4
2014-11-14Sybil Cut tutorial part 3
2014-11-13Sybil Cut tutorial part 2
2014-11-09Top 100 Mars One Australian Brisbane candidate Natalie Lawler demonstrate a card trick
2014-11-08How to record phone calls on Android phones
2014-11-08Annuities lesson 2 - Using the annuities formula
2014-11-07Annuities lesson 1 - using a spreadsheet to simulate the growth of an annuity
2014-11-01Vectors application question - Elastic collision, momentum, and kinetic energy
2014-10-31How to find the equation of a parabola given some points
2014-10-29Excel can't get rid of column 1 column 2 header names fix (remove table)
2014-10-25Slide through legs swing dance routine + bloopers
2014-10-25Google maps create link to location short URL tutorial
2014-10-25Practice question - Simplifying algebraic fractions using factorisation and index laws
2014-10-19Samsung Galaxy S5 taking pictures too slow fix
2014-10-19Free Interactive whiteboard software tutorial
2014-10-18Samsung Galaxy S5 - How to take a screenshot of your phone and text it to a friend
2014-10-18How to set up Dreamweaver CC for one key save, upload and live view
2014-10-15How to get more views on YouTube
2014-10-12Samsung Galaxy S5 customization - Get rid of My Magazine, removing widgets, adding icons to desktop
2014-10-12Samsung Galaxy S5 customization - set up lock screen


Tags:
excel troubleshooting
excel column 1
excel remove column 1 column 2