Advanced Excel Question on Columns

October 12, 2012 at 09:03:41
Specs: Windows 7
I am tasked with Copying an old paper form to excel. It is being asked to look "exactly" the same. It was obviously made with word, because all the columns do not line up. Is there any way for me to make a form where the columns are offset?

See More: Advanced Excel Question on Columns

Report •


#1
October 12, 2012 at 09:40:35
If you are asking if e.g. A2 can be offset from A1 by e.g. half of a column, then the answer is "No".

If you are trying to go from this:

       A             B    
1   Test One      Test Three
2   Test Two      Test Four


to this:

           A                   B    
1   Test One          Test Three
2           Test Two           Test Four

the only way to do it is by widening the Columns and adding leading spaces to move the text to the right.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question