| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| move rows from column to column | New Users to Excel | |||
| numbers in a column and it changes when I move to the next column | Excel Discussion (Misc queries) | |||
| how to move the cursor to column A after entering data column F | New Users to Excel | |||
| move contents of column C based on criteria related to column A | Excel Discussion (Misc queries) | |||
| move column headings from row to column | Excel Worksheet Functions | |||
Linear Mode
