keyboard

  1. L

    keyboard skill to unhighlight a range

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

    Changing Keyboard Shortcut To Custom Ribbon Tab

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

    keyboard Toggle Between Find Pop Up and Worksheet

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

    Paste as Values Shortcut Not Working

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

    Excel / VB code

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

    Formulas and regional settings

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

    how to make formula sign

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

    Keyboard Shortcut to Return to Top of Sheet?

    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?
  9. A

    My macro hotkey (keyboard shortcut) has stopped working

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

    Formula for total products reserved

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

    Excel 2016 VBA: Adjust userform size to match size of the visible frame

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

    Touch Keyboards in Userforms

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

    Excel worksheets not responding to mouse clicks

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

    Ctrl Home function

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

    Really Dislike the Keyboard Commands in Excel 2016 Query Editor

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

    Ctrl + Shift + 0 - Unhide Columns Not Working

    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?
  17. L

    Because of your security settings, macros have been disabled upon keyboard shortcut.

    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?
  18. JenniferMurphy

    How to display all of the current keyboard shortcuts

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

    insert keyboard shortcut into existing macro...

    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...
  20. L

    Keyboard shortcuts on personal macros not working

    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,

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