Microsoft Excel: how to make a square grid for graphing
The tutor explains how, on Excel, to make a grid useful for displaying a graph.
In these days of software availability, one would expect making squares on a page to be obvious. Here’s the easiest way I know:
- In Excel, in the Cells cluster (Home menu), click Format→Column Width. A diaologue box comes up in which you can enter the column width you want. In my case, the default column width is 8.43; I change it to 2.2, then the cell looks square.
Now, to copy the square shape to a range of other cells:
- Select the square cell, right click it, then click Copy. Next, select a row of cells you want to become the square shape. Right click, then click Paste Special→Column widths, then OK. Hopefully you’ll see the associated cells are now square.
Once you have a spacious region of square cells, you can capture it as an image:
- Select the region of cells, right click it, then click Copy.
- Open Paint, then click Paste.
- Save the image (I use .png format).
I’ll be talking more about Excel, Paint, and other software in future posts:)
Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.
Leave a Reply
You must be logged in to post a comment.