Microsoft Excel allows users to present data in several ways: graphs, reports, as well as spreadsheets. Adding a grid to a report is a good way to display information in a easy-to-decipher way. With Excel, you can create a custom grid that contains the exact number of rows and columns needed to hold your data, such as a 10 x 10 grid. You can use the formatting options in Excel to create a custom grid.
Launch Microsoft Excel. A new worksheet will open in the workspace window.
Click on cell "A1" in the top-left corner of the worksheet and hold down the left mouse button. Drag the cursor to cell "J10" to select the area for a 10 x 10 grid. The selected cells will be highlighted.
Click "Format" from the menu bar, select "Row," then "Height." The "Row Height" dialogue window will open. Enter the height you want each cell in the grid to have, then click "OK." You can test different row heights until you get the height that you want on the grid.
Click "Format," then "Column" and "Width." The "Row Width" dialogue window will open. Enter the width you want the grid cells to have, then click "OK." Test different widths until you get the width you want.
Click "Format," then "Cells." The "Format Cells" dialogue window will open. Click the "Borders" tab, then click the "Outline" and "Inside" buttons in the "Presets" section. Select a line in the "Style" box to define the type of line the grid will be made of. Click the "OK" button. The 10 x 10 custom grid will be displayed on the worksheet.
- Jupiterimages/Photos.com/Getty Images