Move one row up for whole column?
 

Hi
I am stuck, I wish to move the entire contents of one column up one row
(column B) but no idea where to begin - I believe its something to do with
Offset but I cant implement it - any help please?

Move one row up for whole column?
 

Select from B2 thru the end of column B. Then touch CNTRL-c
Then click on B1. Then touch CNTRL-v
--
Gary''s Student - gsnu200909

Move one row up for whole column?
 

If I Recall, correctly, by doing that the last cell - of col. "B" - will be
presented TWICE.
I would suggest to right(!) click cell B2 delete... 'Shift cells up' OK
Micky


"Gary''s Student" wrote:

Select from B2 thru the end of column B. Then touch CNTRL-c
Then click on B1. Then touch CNTRL-v
--
Gary''s Student - gsnu200909

Move one row up for whole column?
 

Sorry..., B2 should be read: B1
Micky


"מיכאל (מיקי) אבידן" wrote:

If I Recall, correctly, by doing that the last cell - of col. "B" - will be
presented TWICE.
I would suggest to right(!) click cell B2 delete... 'Shift cells up' OK
Micky


"Gary''s Student" wrote:

Select from B2 thru the end of column B. Then touch CNTRL-c
Then click on B1. Then touch CNTRL-v
--
Gary''s Student - gsnu200909

Move one row up for whole column?
 

Oh no!! - its so simple when you dont complicate it - many thanks :)

"Gary''s Student" wrote:

Select from B2 thru the end of column B. Then touch CNTRL-c
Then click on B1. Then touch CNTRL-v
--
Gary''s Student - gsnu200909