0
Create a macro and assign Ctrl plus l key to run this macro method?
Wiki User
∙ 14y ago
You can record a macro and before starting the recording you can use i key as assigned key to run the macro. Also, if you have an existing macro to which you want to assign i key then Press Alt + F8 which will show you the list of existing macro. Click on Edit and type the i in the assign key box. Remember Ctrl is my default. So, if you want the macro to have Ctrl SHIFT I then turn on the caplock.
Your question is not very decriptive in nature.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
How do you apply macro to whole column?
That's my macro: Sub Macro1() ' ' Macro1 Macro ' ' Keyboard Shortcut: Ctrl+m ' ActiveCell.FormulaR1C1 = "=(RC[-1]-RC5)/RC[-1]" Range("O13").Select End Sub
What is the key command to create a new tab in Firefox?
To create a new tab is Ctrl+T To switch between tabs is Ctrl+Tab
How many ways can you save an excel file?
· File -> Save · File -> Save As · [Ctrl] + Save · Save button · [Alt] + [F], [S] · Create a macro to save a spreadsheet · F12 · Close
An alternative method to copy a file is by pressing what?
Ctrl + C
What is the shortcut key to move a folder?
I think the cut-and-paste method (navigate, Ctrl+X, navigate, Ctrl+V) will do the trick.
What is the function of CTRL plus 1?
The action assigned to shortcut keys can be different in different applications. In the case of Microsoft Excel, Ctrl+1 is a useful shortcut to the format dialog, where you can assign cell formats, borders, etc.
What is Cntrl End in Excel?
The Ctrl key can work with many keys to create shortcuts for many activities. Some are common ones that you find in other applications, like Ctrl-C to Copy. Others are specifically for Excel like Ctrl-R to copy to the right, or Ctrl-F3 to define a name for a cell.The Ctrl key can work with many keys to create shortcuts for many activities. Some are common ones that you find in other applications, like Ctrl-C to Copy. Others are specifically for Excel like Ctrl-R to copy to the right, or Ctrl-F3 to define a name for a cell.The Ctrl key can work with many keys to create shortcuts for many activities. Some are common ones that you find in other applications, like Ctrl-C to Copy. Others are specifically for Excel like Ctrl-R to copy to the right, or Ctrl-F3 to define a name for a cell.The Ctrl key can work with many keys to create shortcuts for many activities. Some are common ones that you find in other applications, like Ctrl-C to Copy. Others are specifically for Excel like Ctrl-R to copy to the right, or Ctrl-F3 to define a name for a cell.The Ctrl key can work with many keys to create shortcuts for many activities. Some are common ones that you find in other applications, like Ctrl-C to Copy. Others are specifically for Excel like Ctrl-R to copy to the right, or Ctrl-F3 to define a name for a cell.The Ctrl key can work with many keys to create shortcuts for many activities. Some are common ones that you find in other applications, like Ctrl-C to Copy. Others are specifically for Excel like Ctrl-R to copy to the right, or Ctrl-F3 to define a name for a cell.The Ctrl key can work with many keys to create shortcuts for many activities. Some are common ones that you find in other applications, like Ctrl-C to Copy. Others are specifically for Excel like Ctrl-R to copy to the right, or Ctrl-F3 to define a name for a cell.The Ctrl key can work with many keys to create shortcuts for many activities. Some are common ones that you find in other applications, like Ctrl-C to Copy. Others are specifically for Excel like Ctrl-R to copy to the right, or Ctrl-F3 to define a name for a cell.The Ctrl key can work with many keys to create shortcuts for many activities. Some are common ones that you find in other applications, like Ctrl-C to Copy. Others are specifically for Excel like Ctrl-R to copy to the right, or Ctrl-F3 to define a name for a cell.The Ctrl key can work with many keys to create shortcuts for many activities. Some are common ones that you find in other applications, like Ctrl-C to Copy. Others are specifically for Excel like Ctrl-R to copy to the right, or Ctrl-F3 to define a name for a cell.The Ctrl key can work with many keys to create shortcuts for many activities. Some are common ones that you find in other applications, like Ctrl-C to Copy. Others are specifically for Excel like Ctrl-R to copy to the right, or Ctrl-F3 to define a name for a cell.
What Key Do You Press to Copy data using the drop and drop method?
ctrl
What key do you press to copy data using the drag- and drop method?
ctrl
How do you create macro?
You can create a macro (macro: An action or a set of actions that you can use to automate tasks. Macros are recorded in the Visual Basic for Applications programming language.) by using the macro recorder to record a sequence of actions, or you can create a macro from scratch by entering Visual Basic for Applications (Visual Basic for Applications (VBA): A macro-language version of Microsoft Visual Basic that is used to program Microsoft Windows-based applications and is included with several Microsoft programs.) code in the Visual Basic Editor (Visual Basic Editor: An environment in which you write new and edit existing Visual Basic for Applications code and procedures. The Visual Basic Editor contains a complete debugging toolset for finding syntax, run-time, and logic problems in your code.).You can also use both methods. You can record some steps and then enhance them with additional code.By recording stepsOn the Tools menu, point to Macro, and then click Record New Macro.In the Macro name box, type a name for the macro.In the Store macro in box, click the template (template: A file or files that contain the structure and tools for shaping such elements as the style and page layout of finished files. For example, Word templates can shape a single document, and FrontPage templates can shape an entire Web site.) or document in which you want to store the macro.In the Description box, type a description for the macro.If you don't want to assign the macro to a toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.), a menu (menu: A list of commands that is displayed when you click a menu name on a menu bar or other toolbar.), or shortcut keys (shortcut key: A function key or key combination, such as F5 or CTRL+A, that you use to carry out a menu command. In contrast, an access key is a key combination, such as ALT+F, that moves the focus to a menu, command, or control.), click OK to begin recording the macro.To assign the macro to a toolbar or menu, click Toolbars, and then click the Commands tab. In the Commands box, click the macro you are recording, and drag it to the toolbar or menu you want to assign it to. Click Close to begin recording the macro.To assign the macro to shortcut keys, click Keyboard. In the Commands box, click the macro you are recording. In the Press new shortcut key box, type the key sequence, and then click Assign. Click Close to begin recording the macro.Perform the actions you want to include in your macro.When you record a macro, you can use the mouse to click commands and options, but not to select text. You must use the keyboard to record these actions. For example, you can use F8 to select text and press END to move the cursor to the end of the line.To stop recording your macro, click Stop Recording.By using Visual Basic for ApplicationsOn the Tools menu, point to Macro, and then click Macros.In the Macros in list, click the template (template: A file or files that contain the structure and tools for shaping such elements as the style and page layout of finished files. For example, Word templates can shape a single document, and FrontPage templates can shape an entire Web site.) or document in which you want to store the macro.In the Macro name box, type a name for the macro.Click Create to open the Visual Basic Editor.Note If you give a new macro the same name as an existing built-in command in Microsoft Word, the new macro actions will replace the existing actions. To view a list of built-in macros in Word, point to Macro on the Tools menu, and then click Macros. In the Macros in list, click Word Commands.
How do you program a macro?
i think that te way to program a macro has somthing to do with holding th ctrl and alt buttons anddo somthing over and over thenyou let go of them and do it the exact same way again......but i am not sure so dont quote me on it
What does the Ctrl plus you shortcut key accomplish in Ms-Word?
Ctrl + U will underline text that is selected. Ctrl and the plus sign will superscript text. You need to hold the shift key while doing that, otherwise it subscripts the text.
