Intro
Same as Basic Steps except all the formulas and references are in R1C1 notation.Here are some of the features shown in the sample:
- Setting cell values and formulas
- Adding a basic chart
- Using the color palette
- Applying styles and formatting
- Page setup, including headers and footers
- Setting "document properties" metadata
- Adding external pictures to a worksheet
- Defining clickable hyperlinks
- Using cell comments
- Setting Conditional Formatting
- Defining workbook and worksheet protection
Code
Downloads
Output: BasicStepsR1C1_output.xlsx
Image: OWlogo.gif