|
|
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?
|
|
0
|
|
|
|
Reply
|
 Utf
|
12/17/2009 11:16:02 AM |
|
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
|
|
|
0
|
|
|
|
Reply
|
Utf
|
12/17/2009 11:36:04 AM
|
|
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
|
|
|
0
|
|
|
|
Reply
|
Utf
|
12/17/2009 11:45:01 AM
|
|
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
|
|
|
0
|
|
|
|
Reply
|
Utf
|
12/17/2009 11:48:01 AM
|
|
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
|
|
|
0
|
|
|
|
Reply
|
Utf
|
12/17/2009 11:51:01 AM
|
|
|
4 Replies
933 Views
(page loaded in 0.094 seconds)
Similiar Articles: Move one row up for whole column? - microsoft.public.excel.misc ...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 wi... Move Column data to row data - microsoft.public.access.queries ...Move one row up for whole column? - microsoft.public.excel.misc ... Would Like Pivot Table Data on 1 Row instead of Stacked Column ... Move one row up for whole column ... Moving Column data formula - microsoft.public.excel.worksheet ...Move one row up for whole column? - microsoft.public.excel.misc ... Hi I am stuck, I wish to move the entire contents of one column up one row ... I want to extend the formula to the WHOLE column. Help please ...Move one row up for whole column? - microsoft.public.excel.misc ... I want to extend the formula to the WHOLE column. Help please ... Move one row up for whole column ... The whole page moves with the up/down arrows, not the cells ...Move one row up for whole column? - microsoft.public.excel.misc ... The whole page moves with the up/down arrows, not the cells ... Move one row up for whole column ... copying causes lock up - microsoft.public.excel.miscCopying the contents of a box causes a lock up for 10 to 20 seconds. The jagged line around the box is stationary and after a period of time start to move. how to make a table with 10 million rows in one column ...Would Like Pivot Table Data on 1 Row instead of Stacked Column ... Move one row up for whole ... the entire contents of one column up one row (column B) but ... make ... Breaking a line within a formula - HELPHELP PLEASE - microsoft ...Move one row up for whole column? - microsoft.public.excel.misc ... summarizing and finding the max value within ... I want to extend the formula to the WHOLE column. MACRO for moving rows from one worksheet to another - microsoft ...I have a formula to notate which row contains the appropriate color (Column ... but asking someone to write the whole ... MACRO for moving rows from one worksheet to another ... Formatting row color in table to match first cell in first column ...Hi, I have a question about setting up a table where new rows added to ... student > table with First, Last, Address as Row ... Start" in column B and then move one row ... Move one row up for whole column? - microsoft.public.excel.misc ...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 wi... Move rows or columns - Excel - Office.comMove or copy rows and columns When you move or copy rows and columns, Microsoft Excel moves or copies all the data that they contain, including formulas and their ... How to Move Rows in Excel | eHow.comCan You Move a List of Values From Rows to Columns in Excel? The process of moving... ... Selecting delete will cause the rows below the deleted row to move up ... Move or copy rows and columns - Excel - Office.comWhen you move or copy rows and columns, Microsoft Office Excel moves or copies ... SHIFT+ARROW key (RIGHT ARROW or LEFT ARROW for rows, UP ARROW or DOWN ARROW for columns). Move a column up or down - Excel Help ForumSometimes i need to move a specfic column one line up or down, my quetios is how ro do it? of ... I assume you mean you want to move a ROW up or down? You can copy the row 7/20/2012 10:41:14 PM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
68 followers. 