VideoPhoto

05 June, 2021

How to make square cells for grid paper in millimeters or centimeters

No macro needed here. Just follow these steps to fill your worksheet with square cells: 

  • select the whole worksheet, or any part of it (your choice)
  • in the ribbon, select View > Page Layout, then
  • select Home > Format >Row Height, and enter e.g.:
  • 0.03937 for 1mm grid (= 1 / 25.4), or
  • 0.19685 for 5mm grid (= 5 / 25.4), or
  • 0.3937 for 1cm grid (= 1 / 2.54), and so on (your choice)
  • select Home > Format > Column Width, and enter the same value as for row height
  • return to the Normal View.

Your grid is displayed and ready for use on your computer screen.

Here are examples of created this way 1mm and 1cm grids:



If you want to get printout of your grid on paper, the next steps depend on the size of paper, selected margins, printer settings etc. Here I'm providing just one example. Let's say that you use letter-size paper and set 2.5 cm custom margins on each side. You would proceed as follows:

  • enter anything in one of the cells on the worksheet; otherwise you may get error message like this one: "We didn't find anything to print
  • in Normal view, select one full page in the worksheet (as shown by page breaks)
  • go to File > Print > Page Setup > Sheet > Print, and select Gridlines option 
  • in Print Settings, select Print Selection, then set Custom Scaling Options to: Adjust to 335% of normal size.

Some tweaking may be necessary, depending on printers and Excel version, to fit the page size. I had no problem with printing the page filled with exactly 1mm size grid.

Other grids can be printed in a similar way, just with different % adjustments of normal size (e.g, I've used 262%  adjustment for 1cm grid).

 

No comments:

Post a Comment

All comments are held for moderation. I reserve the right to edit, censor, delete and - if necessary - block comments.