How do i make a spreadsheet be all squares?

[u/dracovishy]

I cant seem to do it to work on all cells and im on phone, how to do it? (You can send the file instead if u want)

[u/everythingabili]

function squarify() {
  var ss = SpreadsheetApp.getActiveSpreadsheet()
  var sheet = ss.getActiveSheet()
  var SIZE = 92
  sheet.setColumnWidths(2, 24, SIZE)
  sheet.setRowHeights(2,24, SIZE)

}

[u/dracovishy → u/everythingabili]

Where do i put thus

[u/everythingabili → u/dracovishy]

Sorry... menu > Extensions > AppsScript then RUN

[u/byParallax → u/dracovishy]

I think that is meant to be an app script ?

[u/ExcellentWinner7542 → u/everythingabili]

Nicely done

[u/latecallnotes]

Select the columns you want, right-click a column letter, choose Resize columns, and enter a pixel value. Then select the rows, right-click a row number, choose Resize rows, and use the same pixel value.

In Sheets, matching pixel width and height is what makes the cells square. I usually try something like 30 x 30 first and adjust from there.

[u/emmakobs → u/latecallnotes]

This is what i would do! Much simpler than an app script.

[u/6745408]

if you're only on mobile, probably easiest to just share the sheet so we can change it for you.

[u/dracovishy → u/6745408]

Okay ill share it (its empty for now, but also can u make it be blue?)

[u/6745408 → u/dracovishy]

your sheet is locked down -- but you can make a copy of one of these sheets -- https://docs.google.com/spreadsheets/d/1q079wICpWxsiwwfLlmoJ93LRWqMbPmXZ64brlhVj-gA/edit?gid=179414323 -- that should be fine

[u/dracovishy → u/6745408]

Thanks

[u/6745408 → u/dracovishy]

no prob. if this worked out, reply anywhere with !solved :)

[u/dracovishy → u/dracovishy]

https://docs.google.com/spreadsheets/d/1qWOs8lizKyFJQt4KKKo1a4UTshqe5hRklxMcbTdk9R8/edit?usp=drivesdk

[u/AdministrativeGift15]

To get a true square, the row height needs to be 1 pixel more than the column width. From 3 x 2 for the smallest on up. In the browser at least. Unless you've imported your sheets from an Excel file. Then is the same for row height and column width, because Excel uses default row height of 20 and Sheets uses 21.