Abstract
Excel incorporates several tools to help you to prevent or correct errors in your spreadsheets. Starting with the actual data entry process, you can apply restrictions to the type of data that a cell can accept using data validation criteria. For example, you can specify that a cell can only contain a whole number or a date that falls within a particular timeframe. This can help avoid errors resulting from a cell containing the wrong type of data or a value outside the permitted range.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2007 Helen Dixon
About this chapter
Cite this chapter
(2007). Preventing and Correcting Errors. In: Excel 2007. Apress. https://doi.org/10.1007/978-1-4302-0389-6_13
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0389-6_13
Publisher Name: Apress
Print ISBN: 978-1-59059-798-9
Online ISBN: 978-1-4302-0389-6
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)