shortcut keys

  1. B

    Keyboard Shortcuts Practice Sheets

    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.
  2. M

    Formula to make a sentence in one cell in one line, instead of many lines

    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...
  3. Dr. Demento

    (Re-)assigning VBA Editor Shortcut Keys

    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.
  4. T

    Need help! - Shortcut key to bring up workbook

    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...
  5. C

    Single Image Selection / Shortcut Key (Mac Excel 2011)

    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 '...
  6. M

    Keyboard Hook to be used as shortcut to fire up macro outside excel

    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...
  7. M

    Is there a keyboard shortcut to select all empty cells below the data?

    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.
  8. M

    VBA - Sub runs slower using shortcut key or F5 in VBE

    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...
  9. C

    Deactivating Windows Shortcuts

    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...
  10. S

    Keybord shortcut to paste code in excel,

    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...
  11. A

    Excel 2010 Short Cut Problem: Cannot Make Ctrl + Shift + Q! Please Help!

    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...
  12. S

    Shortcut keys not working, ALT+F8+ run does

    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...
  13. A

    Fixed-width Text to Columns without using mouse?

    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...
  14. D

    Word VBA - shortcut keys suddenly triggering a rogue dialogue box

    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...
  15. K

    Keyboard Shortcut for previous cell

    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...
  16. H

    How to delete shortcuts

    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”...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top