Use Alternate Row Marking with 3 how-to topics, including turning it on, turning it off, and choosing a color scheme; 3 items are available without membership and 0 items are membership-related.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Turn On Alternate Row Marking | Free |
| 2 | 2. Turn Off Alternate Row Marking | Free |
| 3 | 3. Choose a Color Scheme | Free |
How-to Guide
1. Turn On Alternate Row Marking
Entry: View → Alternate Row Marking
- Open the spreadsheet file that you want to review.
- Click the View tab at the top of the window.
- Find Alternate Row Marking on the toolbar and click it.
- Check whether alternating row colors now appear in the worksheet.
Success Criteria
- Interface result: The current worksheet shows alternating row colors.
- What you can do next: You can continue browsing, editing, or reviewing the spreadsheet.
Tips While Using
- Common mistake: If you are not in a spreadsheet view, the entry may not be visible.
- Environment note: This feature is mainly used for the display of the current worksheet.
2. Turn Off Alternate Row Marking
Entry: View → Alternate Row Marking
- Keep the spreadsheet file open.
- Click the View tab at the top of the window.
- Click Alternate Row Marking again.
- Confirm that the alternating row effect is no longer shown.
Success Criteria
- Interface result: The worksheet returns to the normal display without alternating row colors.
- What you can do next: You can continue viewing and editing the spreadsheet in the original display mode.
Tips While Using
- Common mistake: If nothing changes, first confirm that the feature was turned on for the current worksheet before this step.
3. Choose a Color Scheme
Entry: View → drop-down menu next to Alternate Row Marking
- Open the spreadsheet and go to the View tab.
- Find the drop-down menu next to Alternate Row Marking.
- Click the drop-down menu to view the available color schemes.
- Select the color scheme you want and review the display effect.
Success Criteria
- Interface result: Alternate Row Marking is shown with the newly selected color scheme.
- What you can do next: You can continue browsing the worksheet or adjust the scheme again if needed.
Tips While Using
- Common mistake: If Alternate Row Marking is not turned on first, the color change may not be obvious.
- Environment note: The color scheme changes the display effect only and does not change the actual data.