Agents for Placer Hills Real Estate (PHRE) have built a worksheet to help clients compare monthly payments. You clear and reset data validation, insert a spin box form control, and save the workbook as a template.
[Student Learning Outcomes
File Needed: PlacerHills-07.xlsx (Available from the Start File link.)
Completed Project File Names: [your name]-PlacerHills-07.xlsx
Skills Covered in This Project
Save a workbook as a template.
Find and clear data validation settings.
Set data validation with an error alert.
Insert a spin box form control.
Protect a worksheet.
Create a workbook from a template.
Open the PlacerHills-07 start file. Click the Enable Editing button. The #NUM! error appears in three cells because arguments for the formulas in those cells are missing.
The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
Find and clear data validation settings.
Click the Find & Select button [Home tab, Editing group] and choose Go To Special.