shortcut keys

Where can I find some keyboard shortcut practice sheets to give my new analysts. Something that would utilize CTRL + Arrows, PgUp/PgDn, Home, etc. Maybe something like a snake game or similar. Open to suggestions.

Dear All, May I request you to help me on a formula/shortcut for below: I have one cell contains a huge sentence. But it is broken down to many lines within the cell. However my ERP will read only the first line of the cell. I wanted to remove the ENTER between the lines and make the sentence...

I understand how to assign shortcut keys in Excel, but I'm coming up blank on how to run a Sub while in the VBE using a shortcut key. Thanks y'all.

Hi, I have workbook that I would like to bring to the foreground and activate when I press an assigned shortcut key (even if the workbook isn't active - .i.e minimized or hidden behind other windows) My goal is for the user to be able to bring the Excel workbook up with the shortcut key even if...

Single Image Selection / Shortcut Key (Mac Excel 2011) Hi - I’m using Excel for Mac 2011. I wrote a macro to scale, rotate, cut, and paste the image that I drag and drop from the finder: Sub rotatescale2() ' ' rotatescale2 Macro ' ' Keyboard Shortcut: Option+Cmd+y '...

Hello guys! Please tell me if it is possible initialize procedure outside inactive Excel. I mean, the file is opened, and some userform is loaded. Is it somehow possible (e.g. hooking keyboard) to assign to procedure/userfrom_button, a windows shortcut (e.g. alt+1)? The macro is being used for...

Is there is a keyboard shortcut to select all empty cells below the data down to the very last row 1048576? I have a client who likes to hide all those rows below her data. Also, because I have a Mac laptop I don't have an "End" key. I would like to use a keyboard shortcut rather than Visual Basic.

Here's a really strange one - I have a set of macros that perform simple show/hide operations on a set of columns. Here's one of these macros, the others are very similar (I'm not including the code of all subs/functions being called because I reckon it's not relevant, but will be glad to do so...

Application requires users to enter data through a UserForm. Think of it as a Kiosk where the user can have a variety of computer skills. I'm trying to make it "bulletproof". My issue is with Windows shortcuts, like "Win + down arrow" which minimizes the application. Is there a way to...

i need to past the data from keybord using shortcut keys as shown below. when the code is pasted its give enter ,so need to use paste and backspace, <tbody> Activate to paste alpha series code (A TO Z) If Press the no Paste and back space code paste in word file ALT+A 1 $#a1...

Hey guys, I have a very weird problem re using a specific short cut to call a macro within Excel. I posted on a different site but got little help. I have been really puzzled by this problem. Please help me out. In my office, we have a macro (let's call it macro A) that everybody needs to...

Hi guys, I have written the below macro. If I run via the editor or ALT+F8+run it works. I assigned a shortcut key Ctrl+Shift+M. It begins to run the macro, opens the other wb for data for vlookup and then stops, no errors or anything. I have control of excel again. I have highlighted the...

Heyyyya folks! Been a while since I've been here, but I've been trying to find some information and not having any luck, so....here I be! :) I'm one of those people who loves keyboard shortcuts more than using the mouse, as a general rule. I use the Text to Column function on a regular...

I am reasonable familiar with VBA for Excel but new to Word VBA. I have cobbled together a couple of simple Word macros and assigned keyboard short cuts. These worked successfully for a while but suddenly for no reason I can discern the hot keys stopped triggering the macros and whenever the hot...

Hello, Is there a keyboard shortcut in Excel 2007 that will return me to the previous cell I was just at? After doing a ctrl [ to see the source of a cell, I want to be able to go back to where I was at originally; however, the ctrl [ doesn't work since the new cell likely has other...

Hi, I’ve got some spreadsheets that contain macros that I would like to delete. The reason I want to delete them is that the shortcut keys are really annoying, for example every time I use CTRL+F it tries to run a macro and I get an error message, “The macro xxxxxxxxx could not be found”...