I'm using Microsoft Excel 2003 on a PC, so the location of some of the menus and tools may vary depending on your version. The general technique should work just fine for you. These instructions will give you a square grid. Keep in mind that knit stitches are not perfect squares.)
To see a larger version of any of the screen shots, click on the image and the full size file should open up.
Setting up the graph paper
- Open a new Excel document and save the file. (Always save your work frequently!)
- Resizing the columns: To resize the columns evenly, you need to select the columns you would like to resize. Click on the "A" header of the column (see red arrow) and drag until all the columns you want are selected. Alternatively, Click on "A" and while holding pressing the shift key, click on the column heading and the end of your range (selecting A through CZ will give you 104 columns.)
- The end default of columns is Q, but if you press the right scroll bar arrow at the bottom of the screen (see red arrow in the below picture), you can increase the number of columns.
- Click on the edge of a highlighted column, and drag until you see the width label change to 1 (12 pixels). Note: You will not see these numbers when you release the click. This width is approximately the size of a single letter width in the column label. By selecting many columns at once, you will have a grid where every square has the same width. If you have kept track of the width value, then it is easy to add more columns of the same size later, but I like to start with more than I could ever need.
- Now that we have a good square width, our grid is made up of small rectangles. To adjust he height, select multiple rows as you did with columns. I like to select a couple of hundred rows (sometimes I like to work on multiple charts in one document) As with selecting columns, click on the "1" row title, and the "150" row title while holding down the shift key.
- With the 150 rows selected, click on in between 2 rows (see red arrow) and drag to decrease the size until you have a height of 9 (12 pixels.)
- You now have a grid of 104x150! You are ready to start designing your knitting chart.
Continue this tutorial:
Part 2 - Drawing your Chart
Part 3 - Saving and sharing your chart