We Value Your Privacy

We and our partners use technology such as cookies on our site to personalise content and ads, provide social media features, and analyse our traffic. Click below to consent to the use of this technology across the web. You can change your mind and change your consent choices at anytime by returning to this site.

Update Consent
Loading ...

How to make a 10x10 custom grid

Updated March 23, 2017

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.

Loading ...
  1. Launch Microsoft Excel. A new worksheet will open in the workspace window.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

Loading ...

About the Author

Steve Gregory

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.

Loading ...
Loading ...