keyboard

Hi Lets say I have date in range A1:A10. I clicked on A1 then shift_ctr_down arrow, to highlight all the range. I still have A1 is selected. Excel now show the last cells in the range, to move up I used Ctr+backspace. Now I see A1, A2, A3,... and A1 is selected and The reset are highlighted. Now...

Hi - I created a custom ribbon tab and the keyboard shortcut after creating it defaulted to "Y2". Can someone explain to me how to change it? Maybe to "S" Thanks

Hi Folks, If I have the Find window up and want to switch focus to the worksheet is their a keyboard shortcut so I can toggle between the popup and the worksheet? Martin

Hello, I have always used the following keyboard shortcut in Excel 2016 to copy cells and 'paste as values': Copy - CTRL + C Paste as Values - Right-Click button on keyboard + CTR + S + S + Down button to select 'Values' + Enter This shortcut is deeply ingrained in me. Suddenly this shortcut...

Dear Sirs, I am using below code in my work. Kindly please help me some one and code in below code "so that while saving file below code also run (I mean either keyboard short key or on saving file ) Sub Macro1() ' ' Macro1 Macro ' ' Keyboard Shortcut: Ctrl+Shift+L '...

Hello, I have a spreadsheet that I developed on a Windows 7 computer, with an English OS and Swiss German keyboard. Regional settings are for Swiss German keyboard and number format. This file is shared amongst a large group of people around the world. In it, there is a range with a simple...

Frank here. I have a formula = then a symbol which is not a dollar or an S but looks like it. How can I make my keyboard make such a sign and what does it do and mean? Anyone help? thanks

As a keyboard shortcut I use ctrl + shift + down arrow to select a long column of data when working on a formula. But how do I go back up to the top of the sheet without messing up the formula I'm working on?

I have a macro that used to work fine and still works when a press on the macro by choosing it from the list of macros, however it does not work when I use the keyboard shortcut I used to use (CMD+ALT+SHFT+V). The shortcut DOES appear when I open up OPTIONS under that macro. Any ideas as to...

Hi everyone I'm having some difficulty deriving a formula for this problem. Basically, a shop owner runs a hardware store. Sadly, some items are out of stock, so he decides to create a 'reserves' list. Customers approach the owner and create reservations. However, as some customers reserve of...

I have a userform keyboard named (UFKeyboard). In this form there are 3 frames, Frame1, Frame2, and Frame3, each containing a separate keyboard. When one keyboard is called the other 2 frames are hidden. All 3 keyboards are different sizes though so what I'm trying to do is find a way to...

Hello everyone, Was curious if there is a way to call the windows 10 touch keyboards in userforms when clicking on textboxes, toggle buttons, command buttons etc.. Both the full keyboard and the numeric keypad. Had some older userform keyboard forms/modules from looking into this same thing...

I'm using Excel for Mac version 15.32. I have a Logitech Bluetooth keyboard & mouse (they came as a set). My worksheets are not responding to any mouse clicks (left or right). I can move around the worksheet using my keyboard. I can type in formulas and use other keyboard commands. I just cannot...

Dear all, I use Ctrl+Home button very frequently in excel. I have purchased new keyboard where Home and End buttons are not available. Please guide is there any alternative keyboard shortcut to get the same functionality of Ctrl+home/End button? Appreciate a lot. Thanks

I am frequent user of the keyboard commands in Excel 2016 such as Alt,H,AC = Align Center or Alt,H,AR = Align Right. There are hundreds of these keyboards that are usually pretty easy to remember. HOWEVER, when you go to Data, From Table or Alt,A,PT,Enter you enter a whole world of...

I've already gone through the steps of going to language settings and putting Not Assigned on both the Ctrl and Alt buttons. It worked for about a day and then it just stopped working again. Is there a way I can assign this same keyboard shortcut to a macro?

Hi, When I open my workbook and try to fire a macro using a keyboard shortcut, I get this message although my macros are enabled. If I then change the keyboard shortcut it works fine? Any advice please?

I want to assign a macro to a keyboard shortcut, bit I don't want to clobber a key combination that is already assigned to something else. In Word, when I go to assign a keyboard shortcut, it tells me what that key combination is currently assigned to. Excel does not do that. Is there some way...

I know keyboard shortcuts can be set when recording a macro. Is is possible to insert one into an existing macro? So far I've created a simple macro then added code to it thinking this would work. Nope! I got "this will reset project" which looks to wipe out the shortcut. I've also looked...

Hey, Whenever I try to assign a keyboard shortcut to my personal macro's they never work.. it sticks to it when I go back in to change the key however when I try to perform it it doesn't work. Is something blocking this from my settings as non-personal macros work fine? Thanks,