shortcut

Hi Guys, I'm a student completely new to Visual Basic and I've been tasked with creating a Macro that upon pressing the shortcut ctrl+a has to change the text in a specific cell to Bold and blue. Any help is appreciated. Thanks

Hi All I have several pictures of equipment to the side of a sheet that is like a library. When I need to grab these pictures, I scroll over to look for it and then copy it and paste it to where I need it. I'm looking for a shortcut that I'm guessing isn't possible. Something like: Type the...

Have a cell(A1) with a formula consisting of two cells: +B1+B2 If selecting cell A1 and typing Alt+[ I get directed to cell B1. Is there any way (Shortcut) to be directed to the second cell instead?

Hello, I create a custom menu called Marks and I want to access it through a shortcut (for example CTRL+M). Can anoyne help me with the vba code to display it. I want the same effect as ALT+SPACE BAR for displaying Control Menu Thanks in advance.

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?

I have been experiencing this same crash on multiple files... it seems like an excel glitch. It happens when I have data loaded into the data model via power query and pivot tables feeding from the data model. When I execute the freeze pains shortcut (Alt, W, F, F) the file immediately crashes...

Hello, In Excel 2016, the shortcut key for current date is CTRL + ; For current time the shortcut key is: Shift+CTRL+; Are there similar shortcut keys in the online version of Excel? I can only find basic shortcut keys for navigation etc... Thanks

Hi I have a report that works perfect, but I can't find a way to run a report, not as an editor. I want to be able to have a separate person run the report, but they just need to run the report and then print. That's it. Can I create a shortcut to the report and allow them to run it with no...

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.

I've tried to search for help on this but struggling with the keywords I'd need to find a query like this. Basically I'm wanting to know if it is possible to create a simple text hyperlink to an application, but when the hyperlink is clicked rather than taking the user to the original...

I am operating Excel 2016. "Ctrl + Alt + -" was my keyboard shortcut for zooming out "Ctrl + Alt + +" was my keyboard shortcut for zooming in. It was great for ditching the scroll wheel on the mouse. As of recently, it has stopped working and I cannot figure out why. Was wondering if anyone ran...

Shift-F2 is still the shortcut key for inserting a new note (ex comment) but I cannot find a shortcut key for insering a new comment - Alt-RC will do it but nowhere near as easy; and my brain is wired for shift-F2 . Anyone, please?

Using Excel 2010 (& 2007) Windows 10 I would appreciate some help, again, please :wink: I have a spreadsheet, consisting of a sheet for each month, ie x 12 (Jan – Dec) plus ‘Summary’ sheet. I want to be able to have a button/or use keyboard shortcut Ctrl-Shift-B, which will, on clicking...

I have spent 10 years looking for a shortcut to pull up the FILL COLOR PALETTE. I found it about three months ago and I set it up. I don't remember whether I set it up with System Preferences (I have a Mac) or with the built-in keyboard shortcut tool in Excel > Tools. I had to reinstall...

My company uses a set of macros with assigned shortcuts. One of them is Ctrl+Shift+L, which overwrites the default Ctrl+Shift+L shortcut that filter the current selection. For consistency's sake I want to leave the macro shortcut unchanged, but is there a way to assign a new keyboard shortcut...

I have a userform open and my Application.visible = False on start up, i want to add a macro that will Application.visible = True with assigned shortcut Ctrl+Shift+Z it currently does not work and have ran out of ideas, any help is appreciated?

Hi! I have a file in the local network to wich i have a shortcut on my desktop. The thing is I usually want to open it in read only. Is there a way of doing it through the shortcut, maybe with some special lunch parameters? I don't like doing this through the open excel program and its menu, it...

keyboard shortcut to open pivot tables old view is CTRL+D+P what is the equivalent shortcut to be used in an excel spanish version ? where can i find the list of keyboard shortcuts in english with their equivalences in spanish thanks

Hi Mr. Excel, Is there a way NOT to REPEAT the logical_test false statement again, as I wanted the formula to be just shorter. Example: from: =IF(VLOOKUP(D2,Criteria!$C$2:$D$11,2,0)="123",1, VLOOKUP(D2,Criteria!$C$2:$D$11,2,0)) to: =IF(VLOOKUP(D2,Criteria!$C$2:$D$11,2,0)="123",1, some...

I'm having trouble getting a macro to run when I press a key combination. This code sets the worksheets to VeryHidden: Sub DeliveryPrep() Worksheets("Leader Info").Visible = xlVeryHidden Worksheets("Calculations").Visible = xlVeryHidden Worksheets("Details").Visible =...