0
votes
1answer
274 views

How do you click and drag lower right corner of a cell (autofill) in excel using the keyboard? [duplicate]

If I press CRTL+Down I move to the cell before the empty cell. If I press CTRL+SHIFT+End I end up selecting everything between the active cell and the next empty cell. Now if I want to auto fill ...
2
votes
2answers
278 views

Adjust Fixed width option in Text to Columns without a mouse?

Is it possible to apply "Text to Columns" without a mouse (we can use only keyboard)? If yes, then how can we CREATE/DELETE/MOVE a break line for Fixed width Original data type?
2
votes
1answer
1k views

Alt + E, S suddenly not working

Yesterday 'Paste Special' using the right mouse click and the keyboard shortcut Alt +E,S stopped working. Application.commandbars("cell").reset did reset the right click option, but using the ...
1
vote
1answer
196 views

Specific excel shortcuts

I am trying to create specific keyboard shortcuts with only one key in Excel 2007. For example: when I press Enter I want to move one cell left and then one cell down and when I press * to move ...
2
votes
1answer
309 views

How can I change Excel 2007 shortcuts from foreign to English?

I have a copy of Excel 2007 that happens to be in Brazilian Portuguese. For me it's great since I'm in Brazil but there is a catch. All the English shortcuts I'm used to, like Ctrl+S for saving, ...
9
votes
2answers
35k views

Excel keyboard shortcut to copy/fill down for all cells with non-blank adjacent cells?

I'm looking for a keyboard shortcut that will duplicate the functionality available by double-clicking the "handle" in the bottom-right corner of a cell. Is there something that can do this, without ...
5
votes
1answer
17k views

Fit column width to text shortcut?

I know that I can double-click a column header with my mouse, but is there a keyboard shortcut to fit a column to the text width?
9
votes
2answers
5k views

Keyboard shortcut to switch between sheets in Excel

Does Excel 2007 have a keyboard shortcut that switchs between worksheets?