Is it possible to drag a formula and autofill using a keyboard shortcut?
Many thanks.
I know how to disable individual keyboard shortcuts, but I was wondering if there was a command that would disable and enable all shortcuts? It would certainly cut down on the code.
I have been taking advantage of the fact that the old ALT keyboard shortcuts from Excel '03 also work in '07, but have come across a very annoying problem: '07 requires a slight delay between pressing each key, while '03 allowed you to press them very fast.
Example: to paste values, you press ALT+E+S+V. In '03, I can press the entire key combination in well under a second. However, if I press that combination very quickly in '07, it pops up this little box that says:
Office 2003 access key: ALT, E,
Continue typing the Office 2003 menu
key sequence, or press Escape to cancel.
However, if I press ALT+E+S+V with a half second delay between each key stroke, it works fine. Strangely, if you use a command with fewer keystrokes (for instance, inserting a cell/row/column, which is ALT+I+E) it works just fine at any speed.
So, my question is how do I get '07 to allow me to do the more full commands like ALT+E+S+V at full speed?
Hi there
I wonder if someone can help me with a relatively simple problem.
After I click "paste special" (specially defined by me as cmd+5) I'm presented with a box with several radio buttons - the default button is "All", but say I want to move the radio button to "number and formats". Is it possible to select a different option without using the mouse or trackpad?
I've tried googling, and searching this forum but I don't seem to be getting the right words in the query as I just can't find anything to say whether it's possible or not. I've tried various combinations of keys too, and nothing seems to make any difference.
Thanks!
Hi,
I have been searching for Keyboard Shortcuts in Spanish for Excel, specifically the insertion of the date.
Can anyone help me on this?
In English version the shortcut for insertion of the current date is ... ctrl + ;
This does not work in the Spanish version.
If anyone knows, I would like to get a list of keyboard shortcuts for spanish version of Excel, please.
daljaxon
When you record a macro in Excel and set it to a keyboard shortcut...Where/How does it save this? The VBA code shows it commented out. When you delete the code it removes the shortcut from memory. Any help would be appreciated.
Thanks!
****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 14">****** name="Originator" content="Microsoft Word 14">
I have customized a lot of keyboard shortcuts in 2003 and now the company is switching to 2010. For example, I have set alt+, as increasing decimals. How can I do the same in 2010? I have spent quite some time googling about the solution but is not yielding any results.
Thanks!
Hi,
I want to create keyboard shortcuts that I can use whenever I use Excel. I know how to create the shortcuts for a single workbook. But how do I make them work in every single workbook?
This is what I do now in a Workbook_Open event:
Code:
Sub setKeyShortcuts()
Application.OnKey "^+=", "MyPersonalFormat"
End Sub
Sub MyPersonalFormat()
Selection.NumberFormat = "#,##0"
End Sub
