Browse » Home
Monday, November 14, 2011
How to Make a Grid in Excel
1. Decide on the size of each cell, and how many rows and columns to use. This example creates a grid of cells that is nine rows long and seven columns wide with cells measuring 1-inch square.
Click on cell A1 in the upper left and while holding the left mouse button, drag the selection to cell G9 in the lower right.
3. From the 'Format' menu, choose 'Row,' then 'Height' to display the 'Row Height' dialog box. Excel measures the row height in points, with roughly 72 points per inch. Enter a row height of 72, then click 'OK' to close the dialog.
4. From the 'Format' menu, choose 'Column,' then 'Width' to display the 'Row Width' dialog box. Excel measures the column width in the number of standard characters that fit into the width, with roughly 13 characters per inch. Enter a row width of 13, then click 'OK' to close the dialog.
If the grid is too big to fit on one page, reduce the cell dimensions or adjust the page numbers by choosing the 'File' menu, then 'Page Setup.' In this case, the left and right margins of the page are reduced to 0.5 inches each.
6. With the cells still selected, choose the 'Format' menu, then 'Cells' to display the 'Format Cells' dialog box.
Click the 'Borders' tab.
8. Click on a 'Style' in the right 'Lines' box to define the border appearance.
In the left 'Presets' box, click the 'Outline' and 'Inside' buttons to draw borders on the grid.
10. Save or print the grid as needed.