Task 3 – Recording Absolute Macros
- This topic is empty.
-
Posts
-
Mayank Goyal
Before you start recording a macro, take a copy of the current sheet so you have a replica to test your macro on later. Record a macro called FormatTable,with the shortcut CTRL + SHIFT + F, which will format the table and add a formula into column C to calculate the ratio of people who gave CT exams this time. File:
[attachment=1]Task 3 – Recording Absolute Macros.zip[/attachment] “The steps involved in this macro are:
In Cell C3 add in the header % People.
Highlight Columns A-C and centre the text within each column.
Align the main header Favourite Cheeses Data across Columns A-C.
Change the Font of the main header to Bold and Size 14pt.
Change the Font of the table headers in Row 3 to Bold and Size 12pt.
In Cell C5 type in a formula to calculate the ratio of the people who prefer that cheese.
AutoFill this down to the bottom of the list.
AutoSize the column widths.”
Answer:
[attachment=0]Task 3 ans – Recording Absolute Macros.zip[/attachment] [font=Calibri,sans-serif]References:https://support.office.com/en-us/article/Change-the-column-width-and-row-height-72f5e3cc-994d-43e8-ae58-9774a0905f46 ” class=”bbcode_url”> https://support.office.com/en-us/article/Change-the-column-width-and-row-height-72f5e3cc-994d-43e8-ae58-9774a0905f46 [/font] [font=Calibri,sans-serif]https://www.howtogeek.com/232629/how-to-center-text-across-multiple-cells-in-excel/ [/url] [/font] [/size]
- You must be logged in to reply to this topic.