shortcut

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 was wondering if there is a way to jump to the bottom of a cell range if you have blanks in between. Please see my example below, as I would like to get from 5 to 4 in one shortcut. I know Ctrl + down arrow goes to the end of the cell range if there are no blanks, but was hoping to get...

Can I change the date format inserted by Ctrl+; shortcut to my preference? It always appear as 03/08/2018 or 3-08-2018 but I wanted 3-Aug-2018. Formatting the cell to the date format don't suit my needs as I am using the shortcut to insert date into a cell with words. Basically I am recording...

I made a very simple macro. Sub Yellow_Highlight() Selection.Interior.Color = RGB(255, 255, 0) End Sub I then assigned it a shortcut key of CTRL+SHIFT+H When I run the macro using F8 or Visual Basic it works fine. When I try to use the shortcut it does not work. Any suggestions?

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

As per title... What I am trying to do is copy a worksheet from another file. I've stripped all of the variable declarations and all other non-relevant code in the example below, just know that it does work via the button click event. When I run the code via pressing the Macro shortcut, the...

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

Good afternoon, I am trying to add a string of 60 numbers, all in the same column, but they are all 11 cells apart. What is the easiest way to do the formula =sum( )? is it best to click on every cell, type all of the cell names, or is there a shortcut you guys know that will help me get all...

Hello How do I get Excel to recalculate the value of NOW()? Obviously one way is to save the file and re-open it, but short of using VBA, is there any way of forcing a reculation - e.g. using a keyboard shortcut? Thanks J

I've created the following macro (from bits and bobs on forums) to save a shortcut of the current file in the startup folder of my computer, if i just manually create a shortcut it works so i know i can edit this folders contents but when i run this macro it produces and error about not being...

Hello. I am looking for code that will autofill six additional rows from the activecell using a keyboard shortcut. For example, I put a date in A! 1/1/2018 and activate the KB shortcut and it will autofill six more cells down ending in 1/7/2018. I then select A10 enter date, activate KB...

I want to make a macro in Excel 2010 that goes to "Other Bookmarks" in Firefox . . . I can't figure out how to do it The closest I can get is, I open this "skin" / "chrome", and it default opens to "All Bookmarks" . . . "C:\Program Files (x86)\Mozilla Firefox\firefox.exe" -chrome...

I have searched a lot for an answer to this and am beginning to think there isn't one... I would like to create a list of all the currently assigned shortcut keys, I don't just mean those assigned to macros but the ones delivered with Excel and that may or may not have been amended. I think...

I have real quick question what's the shortcut in excel to copy down really fast, lets say I have 40000 rows and I can't just select all but I need to copy down ? I know there is a shortcut? Thank you!

I'm using Excel 2013. I use the ctrl-; shortcut a lot for entering the current date in a cell, and ctrl-: for the current time. I've used them for many years without problem, but recently the date one has stopped - nothing happens when I enter it. The time one still works fine. I ran a...

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?

Hello, I have a excel workbook that when ran hides excel and vba and only shows my userform. When I quit everything saves and closes. The problem becomes when I need to access the VBA screen and unfortunately the shortcut keys on some the computers in the office do not seem to work. How can I...

How do I configure the File drop down menu from the ribbon on Excel in Office 365. My colleague has suddenly found that some of the shortcuts are missing after the last update. For instance, she no longer has the Save As shortcut but it seems to have been replaced with something called Save...

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