How to make a 10x10 custom grid

Written by steve gregory | 13/05/2017
How to make a 10x10 custom grid
(Jupiterimages/ Images)

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.

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.