2015-11-20 Read about the right-to-left features in Office, including operating system requirements, display and keyboard languages, direction of text display, and common problems. Text in a cell or field can be left-aligned, center-aligned, or right-aligned. In some programs, such as Access and Excel, text can also have Context text direction.
The official docs say to use
Option-Up/Down
I tried that - as well as
Option-Left/Right
and Command-(any arrow keys)
and they all do different things than the page right/left.So is there any way to get this functionality short of point and click?
Update By playing around a bit more an answer was discovered: the
Command-Left|Right Arrow
will page left/right to the next non-empty cell. I had been seeing it page to the beginning/end since the particular rows had few entries.Hold on .. So the behavior is that the `Command-Left|Right Arrow will move to the next non-empty cell if there were other intervening empty cells. So in the case of a row with all entries filled - e.g. the Header Row - a single invocation puts you at beginning/end of the entire row: so in that case it behaves like Row Home/Row End.
This is not acceptable behavior: is there any workaround?
javadba
javadbajavadba
1 Answer
Although it seems counter intuitive not to use the left/right arrows, (that is a subject for giving Microsoft some feedback) using the following key combinations work for Excel 15.xx for Mac:
Using Built-in MacBook Keyboard:
Page Right: fn+⌥ option+↓ down arrow
Page Left: fn+⌥ option+↑ up arrow
Page Left: fn+⌥ option+↑ up arrow
Using External Apple Wired Keyboard:
Page Right: ⌥ option+page down
Page Left: ⌥ option+page up
Page Left: ⌥ option+page up
As noted in the OP's screenshot.
bjbkbjbk
You must log in to answer this question.
Not the answer you're looking for? Browse other questions tagged keyboardms-office .
Is there a way to move a column (or row) to the left using only the keyboard?I known I can use ctrl-space (shift-space) to select a column (row), but how to move it to the left or right, actually swapping position with the column to its left or right?
(I am using Excel 2007)
Rabarberski
RabarberskiRabarberski
8 Answers
If you're not set on using the keyboard only, highlight the column, either by Ctrl+Space or clicking on the column header. Then press and hold down the Shift key. In some environments you may see the selection box (border) around the column change to an I-bar. Then you can drag the column to the left or right (using the mouse) and it will move the column there without overwriting data or leaving a blank column.
This also works with rows, and with ranges of columns or rows. The I-bar changes to horizontal or vertical as you move the range, and separates the columns or rows where it will move the range to.
To summarize:
- Ctrl+Space to select the source column(s).
- Hold down Shift while you drag the column(s).
GlennFromIowaGlennFromIowa
Best I can come up with is something like this (note, this works in Excel 2003 - might not work in 07/10, but you've haven't indicated which version you are using):
Ctrl + Space to select the source col.
Ctrl + X to cut the col.
Left Arrow or Right Arrow to move to the column you want to move the selected column to the left of.
Crtl + Space to select the target col.
Crtl + + to insert the cut cells (with thanks to variant for that useful comment!).
I'm thinking that AutoHotkey or a short macro might be a good way to achieve this.
It should be easy to record a quick Excel macro using the above set of commands, just make sure 'Relative Reference' is on.
It should be easy to record a quick Excel macro using the above set of commands, just make sure 'Relative Reference' is on.
DMA57361DMA57361
An important difference between inserting a blank column and pasting into it, vs. 'insert cut cells' is that the later will shift your other columns to the right, but NOT their column width formatting. So if you 'insert cut cells,' all the columns to the right will have the widths of the their former columns one to the right and you will have to readjust them to fit your data.
David OlsonDavid Olson
According to the Excel keyboard shortcuts list, there is no built-in shortcut to achieve what you want.
Mehper C. PalavuzlarMehper C. Palavuzlar
To move a single cell or row or column do the following:
- Select the cell(s)
- Type Ctrl+X
- Move to the new location
- Do one of the following:
- Type Enter or Ctrl+V, or
- Press the ≣ (Menu) key (which may be between the Windows and Ctrl keys on some keyboards, or press Shift+F10 if the key is not available),and select 'Insert Cut Cells'.
The cells will be inserted to the left or above the selection.
VaradarajanVaradarajan
Try the following:
- Double-click on the column you would like to move (it will highlight the whole column)
- Hit Ctrl+X at the same time (you will see the selection cut)
- Hit the arrow key to move in whichever direction you want to move (LEFT arrow Or Right Arrow)
- Point between the columns, and release the mouse
- Where you point after the next right column will be deleted automatically (careful: select one Blank column, then move the column )
Example: If you moving a column Between A & B, it is possible that B will be remove) so before moving any column, bring up an empty column between two columns and after you start moving the column.
In summary, select the column (Double click), CTRL+X, move with arrow left or right.
HemalHemal
The method by Hemal (?) works, but the trick is to create a new column where you want to move to, Excel will leave a blank column behind where the data were previously to be used or deleted.
- Double click when the down-pointing arrow appears above the column header for the data you want to move.
- Hit Ctrl+x
- Move with arrow keys to the location of the new column and hit Enter
- Hit Enter
Data moved to the new column.
If you hit enter on a populated column, it is overwritten. Not slick or 'clean', but it's an easy shoehorn to use.
kimkim
If you want to move a particular row or column or cells you just need to select cells pressing Shift with Arrow key after selecting cells just press ctrl+shift+(+) and select the the option for moving down,up, right and left by arrow keys and press Enter. Done!
Armaan KhannaArmaan Khanna