+ Reply to Thread
Results 1 to 3 of 3

Split Cell Without Ruining the Layout

  1. #1
    Registered User
    Join Date
    02-02-2016
    Location
    USA
    MS-Off Ver
    2010
    Posts
    6

    Split Cell Without Ruining the Layout

    I am going crazy here, because I know that there has to be an easy way to do this, without recreating the entire form.

    I have a form that I forgot to factor in an extra cell, so the associate can type in, without removing the cell text.

    In the image below, I have marked out in pink where I would like to create an extra cell that the associate can click in and type the information needed.
    Unfortunately, if I just simply "insert" a cell, it will shift over my entire layout, and if I adjust the current cell widths, it will mess up the layout below it.

    Any help will be greatly appreciated it!

    Screenshot_030216_085007_AM.jpg

  2. #2
    Registered User
    Join Date
    02-24-2016
    Location
    The Netherlands
    MS-Off Ver
    365
    Posts
    92

    Re: Split Cell Without Ruining the Layout

    Hi,

    Unfortunately you cannot insert a cell the way you requested.
    Can you change the width of the blue and black marked columns?
    If so, make the blue smaller and de black wider.
    Then unmerge the specific cells and merge the purple marked cells.
    stevie875.PNG

    Hoop this helps.
    WouterM
    The Netherlands

  3. #3
    Registered User
    Join Date
    02-02-2016
    Location
    USA
    MS-Off Ver
    2010
    Posts
    6

    Re: Split Cell Without Ruining the Layout

    Quote Originally Posted by WouterM View Post
    Hi,

    Unfortunately you cannot insert a cell the way you requested.
    Can you change the width of the blue and black marked columns?
    If so, make the blue smaller and de black wider.
    Then unmerge the specific cells and merge the purple marked cells.
    Attachment 448915

    Hoop this helps.
    Thank you WouterM for the tip!
    With adjusting those cells, plus the use of Insert > Entire Column, I was able to make it work.

    Screenshot_030216_093000_AM.jpg

+ 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. Change cell display name without ruining connection with other program?
    By Here2learn in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 07-14-2015, 04:04 AM
  2. Replies: 5
    Last Post: 12-19-2013, 06:04 PM
  3. Take Sheet1 layout and Create Sheet2 layout with Macro
    By theglitch in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2013, 03:50 PM
  4. Shortcut ruining my work!
    By lesvevans in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-28-2013, 10:43 AM
  5. SUMIFS - Life ruining #VALUE! message...
    By Sordini in forum Excel General
    Replies: 5
    Last Post: 10-10-2008, 07:55 AM
  6. Minimum is ruining my day
    By PattyinNO in forum Excel General
    Replies: 5
    Last Post: 03-19-2008, 04:14 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