columns like in word
 

sorry. I wasn't clear...
I want to put data into rows 1 thru 50 of column A and when I add a cell
into column A row 5 my data from cell A50 will push up to B1... b1 would move
to B2...



"jenn" wrote:

is there a way to connect fields or columns so that I can view/work with them
in columns that way that Word works with columns. ?

columns like in word
 

I don't believe there's a way to do that without writing a macro. No such
built in setting. Why not use Word if you need that functionality?

Dave
--
Brevity is the soul of wit.


"jenn" wrote:

sorry. I wasn't clear...
I want to put data into rows 1 thru 50 of column A and when I add a cell
into column A row 5 my data from cell A50 will push up to B1... b1 would move
to B2...



"jenn" wrote:

is there a way to connect fields or columns so that I can view/work with them
in columns that way that Word works with columns. ?