|
Key Words:
|
sheet shading -- column width -- sheet naming
|
Formatting and Naming the Main Worksheet
In this lesson, we want to prepare the main worksheet that will hold our controls. We will apply a solid color background - the color needs to be light so the controls show up. Then we will name the main sheet and set a column width to a different value than the default width.
Apply a background color
- Open the workbook you saved in the last lesson and go to the first sheet.
- Press Ctrl + A to select all the cells in the worksheet.
- Click the drop-down arrow of the Fill Color button on the Format toolbar.
- Select a light color for your background. I usually use one of the colors on the bottom row.
Rename the worksheet
- Double-click on the sheet tab.
- Type "Main" (without the quotes) and press Enter. An alternate method for naming sheets in the VB Editor is described later in this project and in the main course.
Set a column width and save your work
- Right-click on the top header of column J. This will select the entire column and show you a menu.
- Select Column Width... from the menu.
- Set the column width to 24, and click OK.
- Save your work
|
Click here for feedback and questions about this chapter.
Copyright © 2006-2008 J. Donald McClenagan, PhD, ALL RIGHTS RESERVED
|
|
