0
Want this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
Which Excel feature records a series of actions that can be easily repeated later?
Record Macro
What does record mean in exel?
There can be a number of answers for that. A record can be a database term relating to a set of data that is related to one individual item. This could be the name, address, date of birth etc. of a person, or something like the name, price and category of a product. Excel is capable of dealing with databases, so the term record can be used in Excel in those situations. In Excel you can also "record" a macro. In Excel a macro is a small program consisting of a series of commands to do something in Excel. These commands can be written by the users. However it is also possible to have a series of actions recorded as they are done and then stored as a macro for re-use. So you can use the term record in that sense too.
What is a record in excel?
A record is a database term. A record is a set or related data on a row. On a spreadsheet you would have a row with different data in each cell, like your firstname in one cell, your surname in another, the different lines of your address each in cells of their own, your date of birth in a cell and so on. On the next row you would have these details for another person, which would be a different record.
You have recorded a macro. By mistake you recorded an action in it which you do not want. How will you remove the unwanted action without having to record the whole macro again?
All you need to do is edit the macro and remove the section you do not want in the macro. Excel 2007: From the Developer tab on the Menu ribbon, click on the Visual Basic icon in the Code section. See related links for a detailed tutor on how to edit an Excel macro.
How do you get merged cells to auto height with out a macro in Excel?
I don't know about Excel 2007 but in 2003 you cannot do it with a macro. An inherent feature constratint of Excel 2003.
What virus attaches to documents such as word or excel files?
Macro viruses use Microsoft Word and Excel's capabilities to embed code and programs into the document. When the document is opened, the macro virus is executed and infects your computer.
What are two words an Excel macro ends with?
End Sub.
Create date macro in excel?
The following is a record macro copied into the workbook open section of the workbooks properties. Enters date in a1 Private Sub Workbook_Open() Range("a1").Activate ActiveCell.FormulaR1C1 = Now() Selection.NumberFormat = "dd/mm/yyyy;@" End Sub The macro run's it's self when the file opens
How many lines of macro code an excel sheet accept?
3
Can run access or excel macro codes on pdf files?
Yes! you can!
WHAT a virus that is attached to documents such as Word or Excel files?
macro virus
What is the name of the custom toolbar where where you can attach your own macro?
In Excel 2013 what is the name of the custom toolbar where you can attach your own macro buttons
