+ Reply to Thread
Results 1 to 2 of 2

Value spans three columns

  1. #1
    jerry chapman
    Guest

    Value spans three columns

    How can I put a value in row 2 that spans columns j, k and l, and have it
    centered horizontally in those three columns?



  2. #2
    Don Guillett
    Guest

    Re: Value spans three columns

    Use format>alignment>center across selection.

    Suggest adding a custom icon to your toolbar by right click
    toolbar>customize>

    Sub CenterAcross()
    Selection.HorizontalAlignment = xlCenterAcrossSelection
    End Sub

    --
    Don Guillett
    SalesAid Software
    [email protected]
    "jerry chapman" <[email protected]> wrote in message
    news:[email protected]...
    > How can I put a value in row 2 that spans columns j, k and l, and have it
    > centered horizontally in those three columns?
    >
    >




+ 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