Gurus,
In a spreadsheet, how do you move a column around? I have multiple columns.
A "Cut and paste" won't do it.
--
Spin
Gurus,
In a spreadsheet, how do you move a column around? I have multiple columns.
A "Cut and paste" won't do it.
--
Spin
Select the column, Ctrl-C it, select the column to the right of where you want to move it, then select Insert>Cut Cells
how about cut and INSERT cut cells
--
Don Guillett
SalesAid Software
[email protected]
"Spin" <[email protected]> wrote in message
news:[email protected]...
> Gurus,
>
> In a spreadsheet, how do you move a column around? I have multiple
> columns. A "Cut and paste" won't do it.
>
> --
> Spin
>
>
Select the column header.
Move the pointer down to edge of cell in first row to see a 4-headed arrow.
You can drag the column using that arrow.
Experiment also with SHIFT + drag and CTRL + drag and ALT + drag to get
different behaviors.
You can copy, insert, overwrite depending upon method.
Lotsa fun........suggest you play on a copy of the sheet.
Gord Dibben MS Excel MVP
On Wed, 28 Jun 2006 16:52:01 -0400, "Spin" <[email protected]> wrote:
>Gurus,
>
>In a spreadsheet, how do you move a column around? I have multiple columns.
>A "Cut and paste" won't do it.
Gord Dibben wrote:
> Experiment also with SHIFT + drag and CTRL + drag and ALT + drag to get
> different behaviors.
SHIFT: moves (inserts before destination)
CTRL: same as copy and paste
ALT: same as cut and paste
ALT seems to be unnecessary, since dragging without any keys seems to
do the exact same thing.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks