+ Reply to Thread
Results 1 to 3 of 3

Any possibility to set a width pixelwise?

  1. #1
    Registered User
    Join Date
    07-28-2016
    Location
    Chatham
    MS-Off Ver
    2016
    Posts
    93

    Any possibility to set a width pixelwise?

    Hi Everyone,


    I have a box with information that consists of 6 columns. And these 6 columns are repeated 100 times.

    I would like to change the column width to fit every box into a portrait-oriented MS Word page.

    Say, my preferred widths in pixels are 90/72/62/62/155/155.

    Any chance to do them all at once rather than using ctrl and manually selecting each column 1, then each column 2 and so on?

    Thanks!

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Any possibility to set a width pixelwise?

    Good afternoon roskalov

    So you have a pattern of six columns, of different widths and you want to repeat this pattern x number of times?
    If this is so, then select, say A1 - F1 and right click > Copy. Then go to G1 and right click > Paste Special. Then select Column Widths and OK.

    HTH

    Dominic

  3. #3
    Registered User
    Join Date
    07-28-2016
    Location
    Chatham
    MS-Off Ver
    2016
    Posts
    93

    Re: Any possibility to set a width pixelwise?

    Worked perfectly well, thank you!

+ 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. [SOLVED] Let dropdown list width expand beyond width of column so people can read answer choices?
    By xdrenched in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 11-15-2023, 02:05 AM
  2. Reconciling units: Column width and image width
    By MarmaladeLover in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-13-2015, 03:03 PM
  3. Replies: 2
    Last Post: 07-30-2014, 11:13 AM
  4. vlookup possibility?
    By wannabe_guru in forum Excel General
    Replies: 4
    Last Post: 05-08-2012, 09:00 AM
  5. If/Then Formula Possibility
    By El Dokablo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-12-2010, 08:57 PM
  6. Question about possibility
    By ¥ª®ºß¡ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-16-2007, 09:55 AM
  7. [SOLVED] Set Column Width Based On Total Width Of Other Columns
    By rayneraingoaway in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2006, 06:10 PM

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