Moving columns around

[Francis Hookam]

Good old Mac XL has the wonderful facility for moving columns around

Select col
Cmnd (or whatever you call the Apple key) + X
Click the head of the col you want it moved in front of
Hey presto! Done - as simple as that

Having to use PC XL after so long I miss some of the niceties I have got
used to

Does the PC XL have this columns swapping facility and is there anywhere
where such differences are listed?

Again thanks for the amazing help you all give

Francis Hookham

PS
In Mac XL:
Cmnd + K used to remove a selected col - now it annoyingly (for me anyway)
opens the Hyperlink dialog box - can I change that back?
Fortunately Ctrl click still inserts a column

Same of course with rows but it is mostly cols where I use these facilities

 

[Harvey Waxman]

Select col
Cmnd (or whatever you call the Apple key) + X
Click the head of the col you want it moved in front of
Hey presto! Done - as simple as that

I'm no expert but it doesn't do that for me unless you first insert a column at
the new position.

You can do it more easily (for me) by selecting the column, holding the shift
key while you move the mouse over the selected column until it changes to a
hand, then dragging to wherever you want it. to be The insertion is automatic.

 

[JE McGimpsey]

Cmnd (or whatever you call the Apple key) + X
Click the head of the col you want it moved in front of
Hey presto! Done - as simple as that

Having to use PC XL after so long I miss some of the niceties I have got
used to

Does the PC XL have this columns swapping facility and

Cut the column using Ctrl-X, then use WinXL's menu shortcuts by typing
Alt-i-e.

Alt activates the menus, i chooses the Insert menu, and e selects the
Insert Cut Cells command (the letter to use in each command is
underlined).

is there anywhere where such differences are listed?

I don't know of any place that this type of difference is gathered.

 

[JE McGimpsey]

PS
In Mac XL:
Cmnd + K used to remove a selected col - now it annoyingly (for me anyway)
opens the Hyperlink dialog box - can I change that back?
Fortunately Ctrl click still inserts a column

That particular shortcut was changed with, IIRC, XL01, to Ctrl-K, in
order to be more consistent with WinXL (many CMD-key combos were
switched to Ctrl-key).

However, with both XLv.X and XL04, you can easily change them back using
Tools/Customize/Keyboard...

 

[JE McGimpsey]

I'm no expert but it doesn't do that for me unless you first insert a column
at the new position.

If you type Ctrl-i after selecting the column, the cut cells will be
inserted before the selected column.