How to change width of gridlines in Excel
If you want, you can change the width of the gridlines for your worksheet. To do that, follow the next steps:
1. Click on the top left corner of the spreadsheet to select all cells in the workbook:
2. Right-click on any column and select Column Width... in the popup menu:
3. In the dialog enter the new value for width and click OK:
Note: You can calculate the new width, but if you would like to change grid for aligning shapes, your new width should be the same that current height:
- If you are using the default font of Calibri 11, the standard row height is 15 pts,
which equals 40 pixels. To create the grid, change the column widths to 2.07
(= 40 pixels).
The units for Excel column widths are based on the average number of characters that will fit within a cell.
- If you are using another font, simply drag and drop selected cells to new width:
See also this tip in French: Comment changer la largeur du quadrillage dans Excel.