Results 1 to 3 of 3

Thread: How to stretch only one cell in Microsoft Excel Worksheet

  1. #1
    Join Date
    Nov 2011
    Posts
    126

    How to stretch only one cell in Microsoft Excel Worksheet

    I typed some text underneath the title of my worksheet. I want to be able to view all of this text at one time. For some reason I cannot seem to be able to do that. I want to make A2 stretch across the page so all the text will show up. The text doesn't even show up in Print Preview.

  2. #2
    Join Date
    May 2011
    Posts
    410

    Re: How to stretch only one cell in Microsoft Excel Worksheet

    Try to use format >alignment >center across. You can add the icon to your toolbars. I guess I'm just so used to mine that I forgot that I have this in my
    personal.xls and have a custom button assigned to it.
    Code:
    Sub CenterAcrossOld()
    Selection.HorizontalAlignment = xlCenterAcrossSelection
    End Sub

  3. #3
    Join Date
    May 2011
    Posts
    523

    Re: How to stretch only one cell in Microsoft Excel Worksheet

    It does not looks possible because there are no feature and script available for the same.

Similar Threads

  1. Replies: 5
    Last Post: 01-06-2012, 03:23 PM
  2. Replies: 4
    Last Post: 11-01-2012, 04:56 PM
  3. Replies: 8
    Last Post: 04-12-2011, 11:24 AM
  4. Replies: 5
    Last Post: 14-05-2011, 10:36 AM
  5. How to copy worksheet in Microsoft Excel 2010?
    By Bharat89 in forum Windows Software
    Replies: 3
    Last Post: 09-01-2010, 04:09 PM

Tags for this Thread

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
  •  
Page generated in 1,711,689,276.79432 seconds with 17 queries