Advertisements
Blog,  Inspiration,  Learn to Crochet

Using Excel to Create Pattern Striping 

Want to create your own crochet patterns utilizing stripes but don’t know how to begin?  Have no fear… this tutorial will guide you through each step!  It is how I created my pattern for the Sue Renee Lapghan.

1.  SIZE

a).  Figure out your gauge & size of project.  For this tutorial we are going to use 100 rows.

b.)  Open a blank Excel worksheet.  Find row 100 on the left-hand side of the worksheet.   Highlight row.

c.)  Using the toolbar at the top, click on the “Borders” tab & select “Thick Bottom Border”.  This heavy line will mark the bottom of your project.

     

2.  CHOOSE COLORS  

a.)  Click the arrow beside the “Fill Color” button (see pic below – it looks like a paint bucket).

b.)  You can either select from the colors shown or click “More Colors” to customize your choices.

3.  CREATING CUSTOM COLORS

a.)  Click on the “More Colors” tab.  Then click in the rainbow field to pick your color.  Or click on the “Custom” tab.  If you know the values you want to use you can enter them here.  Click “OK”.

b.)  Repeat for each color you want to create.

c.)  The next time you want to use the same color, when you click the “Fill Color” tab your custom color will be there under “More Colors”.

 

4.  FILL WITH MAIN COLOR

a.)  Click & hold 1 row number at the left & drag your mouse down, releasing the mouse on row 100.  You selection will turn gray & will be surrounded by a thick border.

b.)  Click “Fill Color”.

5.  ADD STRIPES

a.)  Click the row numbers at the left to select individual rows or groups of rows.

b.)  Click “Fill Color” to add stripes.

Advertisements
%d bloggers like this: