How to make a 10x10 custom grid
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.
- Microsoft Excel allows users to present data in several ways: graphs, reports, as well as spreadsheets.
- You can use the formatting options in Excel to create a custom grid.
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.
- Click "Format" from the menu bar, select "Row," then "Height."
An avid technology enthusiast, Steve Gregory has been writing professionally since 2002. With more than 10 years of experience as a network administrator, Gregory holds an Information Management certificate from the University of Maryland and is pursuing MCSE certification. His work has appeared in numerous online publications, including Chron and GlobalPost.