+ Reply to Thread
Results 1 to 1 of 1

Justify right

  1. #1
    Registered User
    Join Date
    04-02-2005
    Posts
    1

    Justify right

    Help required!!!!!

    Hi there,

    I am a new user of excel working with a small table consisting of 4 columns & 4 raws; some of the cells are empty in the table (as shown below). I would like to move the data into the last column (far right hand side). is there any way to automatically move the data.


    So far I have tried this_

    Highlight data and move cursor to the boundary of the cell and pick - drag - drop

    Highlight data and select Alighning tool that only moves numbers in right/centre/left within their specific cell

    Many other things I have tried that I forgot didn't work -- below is an example of what I am trying to acheive.

    Type/format of data I have

    1--------2--------3--------4

    5-----------------6---------2

    ----------5------------------

    4------------------8--------

    ......and this is what I aiming for (moving raws till it reaches the last colum)

    1--------2--------3--------4

    5-----------------6---------2

    -----------------------------5

    ----------4------------------8

    Help will be very much appreciated!!! Thanks
    Last edited by sgk; 04-02-2005 at 07:13 AM. Reason: Couldn't paste the table with borders and with spacing

+ 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