+ Reply to Thread
Results 1 to 3 of 3

Adjust column sizes to center specific column on the screen regradless to the screen size

  1. #1
    Registered User
    Join Date
    08-12-2014
    Location
    London
    MS-Off Ver
    2007
    Posts
    51

    Adjust column sizes to center specific column on the screen regradless to the screen size

    Hi Excel gurus

    I will try to explain what I'm trying to achieve as much as possible, I hope this will be clear.

    There is a form, where on my 27' screen (full hd resolution) I have centered my sheet to show a nice table that is located in column M4 so it looks nice and neat.
    Simply I have same lenght from the left to the left border and the same size from the right border to the right.

    Now the problem is that if you open the spreadsheet on another pc that has different screen size this is not centered anymore, obviously.

    I've been thinking... you know how you can center a userforms and regardless to the screen size or resolution these are always centered?

    Could we not ask excel to always display M column at the specific place? lets say centered? to achieve we could change the sizes of columns A:L so M can finds it's place?

    So I'm more like looking for this:

    Read how many columns is visible on the screen, read their sizes (lengths) and adjust these so M shows on the middle all the time.
    Then I will be able to insert my table somewhere at L or K to center it on the screen.

    Is this possible? lol

  2. #2
    Registered User
    Join Date
    11-16-2016
    Location
    NC
    MS-Off Ver
    2007, 2019
    Posts
    86

    Re: Adjust column sizes to center specific column on the screen regradless to the screen s

    From: http://www.cpearson.com/excel/zoom.htm


    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-12-2014
    Location
    London
    MS-Off Ver
    2007
    Posts
    51

    Re: Adjust column sizes to center specific column on the screen regradless to the screen s

    Thanks for that... Looks like this is what I needed.
    Will spend my evening on this and if not, I will be back here )

+ 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] Screen Element Sizes
    By ffffloyd in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-28-2016, 12:00 PM
  2. Auto-Center a Workbook On Any Screen
    By Balddaddy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-15-2013, 01:40 AM
  3. [SOLVED] Adjust screen resolution automatically to fit all screen sizes
    By Ace_XL in forum Excel General
    Replies: 2
    Last Post: 06-14-2012, 08:51 AM
  4. hyperlink to a cell but have it center on screen
    By garywilson4 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-26-2012, 03:58 AM
  5. [SOLVED] Making comments appear in the center of the screen.
    By Tonso in forum Excel General
    Replies: 5
    Last Post: 06-03-2009, 05:36 PM
  6. Msgbox not center of screen anymore
    By RB Smissaert in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2006, 11:45 AM
  7. [SOLVED] How do i center a worksheet in the view screen
    By midnightyell in forum Excel General
    Replies: 0
    Last Post: 04-05-2005, 02:06 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