Excel 2016 For Dummies
Book image
Explore Book Buy On Amazon

To begin to work on a new Excel 2016 spreadsheet, you simply start entering information in the first sheet of the Book1 workbook window. Here are a few simple guidelines (a kind of data-entry etiquette) to keep in mind when you create an Excel spreadsheet in Sheet1 of a new workbook:

  • Whenever you can, organize your information in tables of data that use adjacent (neighboring) columns and rows. Start the tables in the upper-left corner of the worksheet and work your way down the sheet, rather than across the sheet, whenever possible. When it’s practical, separate each table by no more than a single column or row.

  • When you set up these tables, don’t skip columns and rows just to “space out” the information. (To place white space between information in adjacent columns and rows, you can widen columns, heighten rows, and change the alignment.)

  • Reserve a single column at the left edge of the table for the table’s row headings.

  • Reserve a single row at the top of the table for the table’s column headings.

  • If your table requires a title, put the title in the row above the column headings. Put the title in the same column as the row headings.

About This Article

This article is from the book:

About the book author:

Greg Harvey, PhD is the President of Mind Over Media. Greg wrote his first computer book more than twenty years ago and since that time, he has amassed a long list of bestselling titles including Excel All-In-One For Dummies (all editions) and Excel Workbook For Dummies (all editions).

This article can be found in the category: