shortcuts

Good morning, - as a Lotus 123 veteran (!) I still use a lot of keyboard shortcuts within Excel such as Alt+f (File) followed by c to close the active workbook. Whilst these work most of the time, sometimes they don't and the above sequence will result in a "c" appearing in the active cell, and...

Is it possible to identify if a Application.OnKey is set or not? if Application.OnKey."+^{g}" = "MyMacro" then msgbox "Yeah" The final goal is ONE macro which disable or enable all shortcuts.

I want to assign a macro (Sub) to a keyboard shortcut. When I do this in Word, it tells me if the shortcut is already defined so I don't screw anything up. Excel does not appear to do this. Is there a way for me to find out what all of the extant shortcuts are in any sheet?

Hi guys, If I want to paste something as value, I can press Alt + ESV. That is, hold Alt and press and release e, press and release s, press and release v. It did the trick. However, I just found I can also press Alt and release it, press and release e, press and release s, press and release v...

Hello, I want to create new shortcuts in excel and they should work for all workbooks. Excel offers Alt, W, V, G shortcut for not showing the gridlines. I want to change the shortcut as Ctrl+Q. Are there any way to use the new shortcut for all the workbooks? Thannks in advance.

Hi all, Bear with me - I am a VBA novice so any help would be appreciated. We currently have a workbook which has a lot of tabs at the bottom. One of the tabs is called 'Shortcuts'. I am trying to write a VBA whereby if cell P43 on the 'Shortcuts' tab contains "1" a warning pop-up appears...

I am having issues getting keyboard shortcuts with ALT to work and I'm wondering if I'm doing something wrong. The CTRL+SHIFT shortcuts work fine; however, in order to minimize re-assigning native CTRL shortcuts that I normally use, I've moved on to using ALT. However, they don't function at...

Hi Everyone, This is driving me a bit crazy. It used to be that Excel would repeat the last action I made if I pressed the F4 key. Now it no longer does this. It's not an issue with a function lock. If I press F5 I still get the Go To menu. But somehow F4 no longer repeats the last action...

Does Microsoft Excel offer a list for all shortcuts? I know there has to be about a million of them.:laugh:

Hi All, It has been while I'm using MS Excel 2010 and generally use some MS 2003 excel shortcut like paste special, series.. etc. I don't know why it stopped working but I can use MS Excel 2010 shortcuts without any problem. Anyone has ever had this strange issue? Thanks, Mukesh Y

Hey! I want to create a bunch of windows shortcuts into the same excel workbook, but into different worksheets inside that book. Haven't found any solution to this, anyone here who knows what has to be done to make that happen? Cheers,

Hey all, I am forced to use Numbers on my Mac at work for many things. I'm going bonkers tying to use a habitual shortcut that does not seem to have an equivalent in Numbers. In excel for Mac I select a range, type the value and then press CMD+Enter. It fills in the entire range with the same...

I have found hundreds of Shorcuts like Ctrl+S for Excel 2010, but I have not been able to find a list at Microsoft for menu commands. In the case of Ctrl+S, a menu command would be Alt,F,S. I know people call them all shortcuts, but in my point of view, a shortcut is one key combination with no...

Hi everyone, I need a VBA script to insert into my module that simply creates a shortcut to the current active workbook in the following directory "D:\Work\Expense Report" Thank you and have a nice day

The reason I ask is because a user of one of my workbooks called me and said he could no longer see the sheet tabs. I simply went to Options and checked the box for "Show Sheet Tabs" but I was wondering how he hid them. I know he didn't go to the Options and un-check that box... so is there any...

Hi, When I am writing formulas and highlighting ranges, I normally just hold the Ctrl +Shift and then enter down to highlight a range. Something recently went awry so that when I do that to select a range in a formula it jumps back to the cell in which I'm writing the formula (rather than the...

I am having a problem with the CTRL + SHIFT + TAB shortcut when entering formulas into cells. Normally, when entering a formula (ie typing = into the cell), you can use CTRL + TAB or CTRL + SHIFT + TAB to activate a different workbook without exiting the formula edit. Until a few days ago...

hello every one. i was working with an excel file and inserting data into it. by accident i think i hit a shortcut button combination and the worksheet is now gone! the file still exists and it has 35 kb of information in it but when i open the file, the worksheet is not there. i think that...

Hi all, I am using Excel for Mac 2011 and when I am trying to edit a formula in a cell and reference another cell, I hit ctrl + tab to switch workbooks and when I do it cancels the edit formula. When I click on the second workbook while editing a formula it works fine. Is there any solution to...

Hi Could you please help me with the scenario below? My source folder is called "Source\Files\" It also has shortcuts folder that is shortcuts of the all original files say "Source\Shortcuts\". These shortcuts point to files in "Source\Files" folder. ---- I need to create a backup of this...