Microsoft Office Tutorials and References
In Depth Information
Working with shapes
Create a drawing grid
If you want a little help lining things up on screen, you can create a “graph paper” in
Excel. Because drawings exist essentially on a layer floating above the worksheet, you
can use the worksheet grid as a background for guidance. Starting with a new blank
workbook, click the box at the intersection of the row and column headings. This
selects the entire worksheet. Drag any line between column letters to the left until its
width is 2.14 (20 pixels).
Excel helpfully includes the pixel count in the label that pops up when you drag to
change the column width or row height. If you changed the default font or row height,
just make sure the column width pixels match the row height pixels to ensure that
every cell in the workbook is a tiny square. (Note that the New Sheet button will still
add normal worksheets, so if you need more graph-paper tabs, right-click the Sheet1
tab, click Move Or Copy, and select Create A Copy.) Finally, click the File tab, click Save
As, and select Excel Template in the Save As Type list so that you never run out of paper.
See “Tools to help you position objects on the worksheet” later in this chapter for information
about using the Snap To Grid option to help with your drawings.