LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 64
Default How can I easily make cells in Excel that are square?

The underlying problem is that Excel measures Row Height in picas and Column
Width in number of standard characters.

There are 72 picas (vertical) to the inch, and 12 characters (horizontal) to
the inch. So for a square cell, the ratio of the NUMBERS for Row
Height/Column Width must be 1:6. As JEV wrote, for a 1 inch square cel,l set
RH = 72, CW =12.
For a 1/2 " square cell, set RH=36, CW=6.

Mike

"JEV" wrote:

select all;
format; row height set to 72 pts
column width set to 12 pts

displys cells 1" by 1"



"Todd" wrote:

Seems such a simple request, but I cannot find a simple answer.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I make Excel forget cleared cells askgail Excel Discussion (Misc queries) 1 April 17th 06 10:48 PM
Cells User Select Locked after upgrade to Excel 2002 TWilson Excel Discussion (Misc queries) 1 August 5th 05 12:22 PM
How can I have excel search and add multiple cells to find a targe Blakepro Excel Discussion (Misc queries) 1 April 1st 05 02:37 AM
Can you make cells in Excel flash or twinkle? 8buds4u Excel Worksheet Functions 1 March 29th 05 05:35 PM
in excel - i have a row of cells i need to make 'unique' and do n. gtoffice Excel Worksheet Functions 1 January 13th 05 06:54 PM


All times are GMT +1. The time now is 11:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"