tag:blogger.com,1999:blog-9312877.post110252609731953429..comments2022-12-09T12:19:07.505-07:00Comments on Excel Tips: Square Cells in ExcelJon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-9312877.post-16429007748580919152015-10-02T02:21:56.488-07:002015-10-02T02:21:56.488-07:00Wow, Great thanks for square cells. You rock Jon!Wow, Great thanks for square cells. You rock Jon!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-9035163145996944072014-07-10T10:00:02.034-07:002014-07-10T10:00:02.034-07:00Making the column widths and the row heights equal...Making the column widths and the row heights equal to the same number of pixels works for on screen, but this will not mean that the grid will be square when printed.Jon Wittwerhttps://www.blogger.com/profile/04461947852006005549noreply@blogger.comtag:blogger.com,1999:blog-9312877.post-76364910904825495262014-07-06T23:50:52.105-07:002014-07-06T23:50:52.105-07:00a simple solution could be
- select all cells
- d...a simple solution could be<br /><br />- select all cells<br />- drag and resize the columns to a desired pixel size (you will see column width in both points and pixels as you drag and resize)<br />- repeat the same for rows (selecting the same pixel size)<br />- this should give you a worksheet with perfectly sized square cellsAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-50779157089777264422014-01-18T19:43:39.042-07:002014-01-18T19:43:39.042-07:00Thank's a lot!Thank's a lot!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-1152192302060337102006-07-06T06:25:00.000-07:002006-07-06T06:25:00.000-07:00Actually, I have been using the following code, wh...Actually, I have been using the following code, which sets the width first:<BR/><BR/>Private Sub MakeSquareCells()<BR/>Dim duh As Long<BR/>Dim myPts As Long<BR/>Dim myRange As Range<BR/><BR/>On Error GoTo TheEnd<BR/>Set myRange = Application.InputBox("Select a range in which to create square cells", Type:=8)<BR/>On Error Resume Next<BR/>If myRange.Cells.Count = 0 Then Exit Sub<BR/><BR/><BR/>duh =Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-1117741122386687542005-06-02T12:38:00.000-07:002005-06-02T12:38:00.000-07:00Wow... look at all the information out here... S...Wow... look at all the information out here... Square cells in Excel. And I was actually just wondering this. Thanks for whoever posted this... keep up the good work!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-1104714687726883282005-01-02T18:11:00.000-07:002005-01-02T18:11:00.000-07:00Good luck with the new blog, I look forward to rea...Good luck with the new blog, I look forward to reading it!<br />RossAnonymousnoreply@blogger.com