Home » Free Excel Resources » Excel Spreadsheet Secrets » Blank Rows and Columns

Top Ten Mistakes Made on Excel Spreadsheets

The Data on Most Spreadsheets is Overcooked! Is Yours?

How you set up your data in Excel has everything to do with your ability to analyze it later. Unfortunately, most people don't know how to do this. This lesson series covers ten mistakes to avoid.

Lesson 2 of 6

Learn about the tarpits of using blank rows and columns.

 

Mistake Four

Blank Rows and Columns
Blank rows and columns also make it much harder to select, analyze or chart your data. If you select this data and try to create a line chart, you’ll get:

 

How should you organize your data? In columns with time or categories in column A and data in column B.

 

Watch your inbox for Lesson 3 where we discuss the tarpits caused by column headings.

---

Stop using old technology!

Upgrade Your Excel and Data Analysis Skills to Smart Charts Using QI Macros.