×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Square cells

Square cells

Square cells

(OP)
This is a simple question to many of you but how do you make the cells be square in shape?

RE: Square cells


1. You can resize rows or columns by dragging. Mouse over the header rows. When you're on the line between two letters the cursor changes to a double-headed arrow - then drag column width.

2. Same for rows

3. You can select a row or column then go to Format menu. There is a menu item for height and/or width

4. To make an individual cell different from its row or column, select 2 or more adjacent cells and use the Merge Cells option from the Format|Cells|Alignmenmt tab

5. There is also a Merge Cells option on the Formatting toolbar

Please come back if I have misunderstood your question

Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting

Steam Engine enthusiasts: www.essexsteam.co.uk

RE: Square cells

As an additional comment, in Excel 2000, when following Johnwm's item 1 and 2 above, Excel will display the column width and row height values but also shows the pixels.  By setting the column width in pixels equal to the row height in pixels, you will have a square cell.  I think this is the only place the pixel value is indicated unless you can access it from VBA.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources