+ Reply to Thread
Results 1 to 5 of 5

I am trying to make the columns a specific a specific size

  1. #1
    Registered User
    Join Date
    01-28-2013
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    14

    I am trying to make the columns a specific a specific size

    I am trying to have some columns, which are empty, a specific size so that it just creates a space between them and am wondering if there is somehow to do this in excel.

    Thanks for any feedback on this.

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: I am trying to make the columns a specific a specific size

    Here's one way to set the column width of several columns at once.

    • Select A1
    • Hold down control and click: C1, F3 and H10
    • Home.Format.Column_width...enter a width number...press: ENTER

    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Forum Contributor
    Join Date
    05-02-2013
    Location
    Indiana
    MS-Off Ver
    Microsoft 365 (Subscription)
    Posts
    192

    Re: I am trying to make the columns a specific a specific size

    With your spreadsheet open, take your mouse up where the columns are displayed Lets try column A, move your mouse towards B. When you come close to the line between A and B your pointer will turn into a left arrow and a right arrow divided by a vertical line. When that happens click and drag and it will change the width of the column.

    If you want to change the width of more than one consecutive column then..
    Put your pointer on the A in coloum A, click and drag the mouse pointer horizontally to however many columns you want. Release from the drag and then put your mouse pointer up to any one of the highlighted columns and look for the same left and right arrow with divided vertical line. Then click and drag and you will change the width of all the cells you highlighted.

    This also works for and rows you want to change the width for.

    Hope this helps!

  4. #4
    Registered User
    Join Date
    01-28-2013
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: I am trying to make the columns a specific a specific size

    Thank you for answering.

    This I know about. What I am interested in is having it so that others cannot change the column size so that A, F, G always stay at that one size or if I add a column in the group it will move over but keep the same size on the separating column.

    I have not seen this before so am not sure that it can be done in Excel.

    If you have an idea about this it would be greatly appreciated.

    Bruce

  5. #5
    Registered User
    Join Date
    01-28-2013
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: I am trying to make the columns a specific a specific size

    I answered this in the other but the goal is to freeze the size of the columns that I want frozen. And to make it so that people using the spreadsheet cannot change them on their own.

    Thank you for your response. I really appreciate it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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