Chapter 1. Staying in Control

In this chapter, we will cover:

  • Making the spreadsheet more readable with colors
  • Making the spreadsheet more readable with comments
  • Making the spreadsheet more readable with borders
  • Using Named Ranges
  • Selecting all worksheet cells with one click
  • Copying the format of one cell to another cell or range
  • Debugging the spreadsheet
  • Navigating between worksheets
  • Grouping canvas components