Move one row up for whole column?

[CP]

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?

 

[Gary''s Student]

Select from B2 thru the end of column B. Then touch CNTRL-c
Then click on B1. Then touch CNTRL-v

 

[מיכ×ל (מיקי) ×בידן]

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

 

[מיכ×ל (מיקי) ×בידן]

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

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

 

[CP]

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