0
votes
1answer
3k views

How to customize Paste Value Excel Short Cut

I was reading in this other post about how to set up a macro to past values in Excel. I understand how to create he macro but I would like to set the keyboard shortcut to Ctrl d but excel pops up an ...
0
votes
1answer
43 views

Keyboard default binding to advance to next sheet in Windows Excel 2010?

Using the default bindings for Microsoft Excel 2010 on Windows 7, what keyboard binding exists (if any) that allows me to navigate to the next sheet in a spreadsheet? What about the prior sheet? ...
2
votes
3answers
3k views

Ctrl + Shift + Arrow stopped working

When I work with a big amount of data, I introduce formulas in Excel by using the shortcut: Ctrl+Shift+arrow. That shortcut allows me to select a whole set of data to the left, right, up or down. ...
5
votes
2answers
11k views

How do I select an entire row in Excel?

How do I highlight all cells in an Excel row? I'm using Excel 2010 on Windows.
2
votes
1answer
572 views

How can I change what cell is selected after I press Enter in Excel?

Is there an Excel keyboard shortcut for changing editing , i.e., for "After pressing Enter, move Selection Direction (to) Right/Down"?
1
vote
2answers
1k views

How to create custom shortcut in excel 2010 using VBA?

How can I create a custom shortcut like Ctrl+D to do certain task in excel 2010 using VBA? Also I'd like to use this shortcut again and again for different files. However, I used VBA before for very ...
2
votes
3answers
17k views

How to toggle Scroll Lock in Excel 2010 without a Scroll Lock key in the keyboard

I have a notebook with no Scroll Lock key (or any shortcut using the 'Fn' key). Somehow Excel 2010 got the Scroll Lock on. I see it left down in the status bar and now I can't navigate through cells ...
2
votes
4answers
51k views

Keyboard shortcut to change case of text in cells in Excel 2010?

Is there a keyboard shortcut in Excel for changing the case of selected cells (to lower or upper or whatever)? All my searches lead me only to functions to do this. But that is not what I want.
6
votes
6answers
22k views

What's the keyboard shortcut to Unhide a column in Excel 2010?

My SHIFT key doesn't appear to be broken, so this one's got me stumped: Looking online, I've been told the keyboard shortcuts for hiding and unhiding columns in Excel are CTRL + 0 and CTRL + SHIFT + ...