Copying Knitting Charts from Excel

Another little trick I learned on Ravelry 😉 — love those folks!

If you are using Excel to create knitting charts, and you are ready to paste those charts into your pattern in Word, here’s a neat little trick:
~highlight the chart area in Excel
~hold the Shift key down, click Edit, click Copy Picture….
~in the dialog box that opens, click As shown when printed
~click OK
~go to your wordprocessor and click Paste
Voila! A beautiful, clear chart!

Another little tip is to use grey not black gridlines for your spreadsheet so that the lines are visible but not overwhelming. You can set the gridline colour under Tools, Options…, View tab; the colour option is at the bottom of that tab.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s