Abstract
In this chapter, you’ll learn how Excel worksheets use three types of data: text, numeric, and date/time. It is important to understand the different types of data. You will learn how to insert characters that aren’t available on your keyboard. The chapter covers resizing columns and rows, correcting typing mistakes, how to create custom lists and add notes and comments to your spreadsheets. You will work with Excel tools: AutoCorrect to make corrections and shortcuts for entering words and phrases, AutoFill tool to create duplicate cells and create a series, and the tools AutoComplete and Pick from Drop-Down List to improve and speed data entry.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2020 David Slager and Annette Slager
About this chapter
Cite this chapter
Slager, D., Slager, A. (2020). Best Ways to Enter and Edit Data. In: Essential Excel 2019. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-6209-2_3
Download citation
DOI: https://doi.org/10.1007/978-1-4842-6209-2_3
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-6208-5
Online ISBN: 978-1-4842-6209-2
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)