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.