+ Reply to Thread
Results 1 to 7 of 7

Excel 2003 - Making cells square

  1. #1
    Registered User
    Join Date
    09-10-2010
    Location
    Scotland
    MS-Off Ver
    Excel 2003
    Posts
    29

    Excel 2003 - Making cells square

    How do you do this, everything around points to features introduced since 2003 version.

    I have a blank worksheet, I wish to draw a diagram and I want the rows = column sizes ie a square grid not an oblong one.

    How do you achieve this. Remember Excel 2003

    Thanks

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2505 (Windows 11 Home 24H2 64-bit)
    Posts
    91,120

    Re: Excel 2003 - Making cells square

    Please update your forum profile, which says Excel 2000. I take it you do mean Excel 2003 as in the year 2003? That is, a very old version?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Excel 2003 - Making cells square

    In the attched file, the rows all default to 20pixels deep. Grab a bunch of columns and drag to left until pixel width is also 20???
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  4. #4
    Registered User
    Join Date
    09-10-2010
    Location
    Scotland
    MS-Off Ver
    Excel 2003
    Posts
    29

    Re: Excel 2003 - Making cells square

    So I see the column with is 2.14 and the row height 15 but how do you get to that you didn't explain what you did.

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Excel 2003 - Making cells square

    I did... but maybe not clearly enough. I can't recall where things were in Excel 2003, so a more roundabout way...

    1. open a sheet.

    2. Left click on the line at the border between any two row labels and mentally note the pixel size (15 by default in my Excel).


    3. select as many columns as you need, or click on the box at the junction of th erow labels and column labels to do the whole sheet.

    4. Left click on the line at the border between any two column labels and, with the left button still depressed, move the border partition to the left until it, too, reads 20 pixels.

    5. Done.

  6. #6
    Registered User
    Join Date
    09-10-2010
    Location
    Scotland
    MS-Off Ver
    Excel 2003
    Posts
    29

    Re: Excel 2003 - Making cells square

    Yep got you know. Thanks Glenn.

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Excel 2003 - Making cells square

    You're welcome.



    It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

    Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Making all charts the same size on excel 2003
    By davidx in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-06-2013, 10:12 AM
  2. CSV (MSDOS) - excel 2003 - making into a page
    By itselflearn in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-28-2013, 05:35 PM
  3. [SOLVED] Excel 2003: Making a Drop Down List from a Range of Discontinuous Cells
    By helpmeinexcel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-26-2013, 02:16 PM
  4. Making Two Columns Out of One (Excel 2003)
    By chelovek123 in forum Excel General
    Replies: 3
    Last Post: 02-15-2011, 06:53 AM
  5. use of square brackets in vba excel 2003
    By mattsgame in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-08-2010, 06:06 PM
  6. Replies: 0
    Last Post: 08-01-2006, 05:05 AM
  7. [SOLVED] How can I easily make cells in Excel that are square?
    By Todd in forum Excel General
    Replies: 4
    Last Post: 05-13-2006, 09:35 PM
  8. Square cells in Excel
    By TH6 in forum Excel General
    Replies: 3
    Last Post: 11-11-2005, 08:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1