Visit my new blog at www.myxcelsius.com
Forms help you input data into a spreadsheet more easily. We’ll look at a data input form. We’re going to see how helpful a data input form is, and how easy it is to create one. In fact, you won’t be creating one at all – Excel does all the work for you.
Start a new spreadsheet. Enter January in cell A1. AutoFill the months up to October in column J. Then do the following:
-
Highlight the entire A column by clicking on the letter A at the top of the spreadsheet
-
Hold down your left mouse button on the letter A of the column
-
Keep it held down and drag to the right
-
Keep dragging until you have highlighted all the columns from A to J
-
Your highlighted spreadsheet will look like this:
Crystal Xcelsius Dashboarding 