Move one row up for whole column?

C

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?
 
G

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


מיכ×ל (מיקי) ×בידן said:
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
Click to expand...
 
Top