Move one row up for whole column?

  • Thread starter Thread starter CP
  • Start date Start date
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?
 
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...
 
Back
Top