keyboard shortcuts

Hello, I’m not sure this is the best way to go about it.. But I need code to get a specified range in a macro. The range is variable .. so I’m trying to use keyboard shortcuts like “ctrl + home” and “ctrl + end” to get the correct range. The problem is when I start let’s say at the bottom...

Hi, Is there an equivalent to the Ctrl+" / Ctrl+' keyboard shortcuts to copy a value / formula from the cell *below* instead of from above? Thanks, Stefan

Is there any way to completely disable "End Mode" so that the End key does what it used to do, i.e. jump to the last row? I would even begrudgingly accept a multi-key shortcut that does the same thing. Apparently we are now forced to endure "End Mode", a "feature" that does what Ctrl+ArrowKey...

I recently changed laptops. And now when I try and record macros on my personal macro workbook and assign a keyboard shortcut, the keyboard shortcuts don't work. However, if I open up the code/VBA and click run, it runs the macro just fine. Anyone know how to fix this?

I am completely stumped. I assigned ctrl+v to a macro in Excel and now I want to switch it back to the preset "Paste" function. To my surprise, I cannot figure out how to do this. I have searched all over the web and very few even recognize my question, much less have any meaningful advice...

One of the best things about the Quick Access Toolbar in Excel for Windows is that it automatically creates shortcuts for the items included in your Quick Access Toolbar. For example, pressing Alt+1 triggers the first item in your Quick Access Toolbar, pressing Alt+2 triggers the second item...

For example, let's say I'm in an Excel worksheet and use the ⌘⇧K shortcut for the group rows/columns action. A menu pops up with two radio buttons, the first for the option to group by "Rows" and the second for the option to group by "Columns". (The former radio button is selected be default.)...

I am completely flustered on this one. I was working in a sheet today and hit control+c like I always do to copy a cell and the next thing I new There was a different active cell and and several rows were hidden. I assumed it was a mistake on my part, but sure enough, every time I hit...

It's very useful to be able to press CTRL+[ in order to navigate to the first precedent/reference in a formula. (And then to press F5 to jump back to the formula.) However, what if a formula has multiple precendents/references, including some or all that appear on a different worksheet? It...

I have two workbooks, each with a Keyboard shortcut assigned to the same key stroke combination. Both of the shortcuts do similar things, e.g. delete or add rows, but because the workbooks are different in terms of number of columns and content, the Macro can't work exactly the same in either...

I'm a heavy Excel user and love keyboard shortcuts. I'm working on a small project to run keyboard shortcuts on your computer from a tablet. I'm looking for feedback from other Excel users on how to make it most useful. I have a short Google survey (http://bit.ly/directflight) that I would...

I'm using Excel 2010 with Windows 7. I'm new to macros. I've been recording macros and trying to assigning a keyboard shortcut in the Record Macro window but, they don't seem to stick. The macro keyboard shortcuts work with the first use but, don't work if I close Excel and try to use them...

Hi, I love all the keyboard shortcut showing in mr excel and excelisfun videos on youtube, and use them a lot, but my big problem is allways to convert them to the danish EXCEL. Does any one have a link to a conversion table from english keyboard shortcut to danish keyboard shortcut :confused...

I'm doing a ton of corrections for mixed up information. Is there a function that will cut and paste a cell's contents and automatically push the destination's cells contents to the original cell that you cut from? i.e. - Swapping contents... if that does exists, I'd assume I could assign a...

Hello, I'm an avid user of keyboard shortcuts in Excel 2007. Last week, while I was trying to enter a SUMIF formula, I encountered a new issue with a keystroke combination I've been using forever! Steps to recreate issue: Assume Months (Jan-Feb) are in A1:A12. Assume numerical values are in...