Microsoft Excel Data Validation

By Marie Eklof

This book will show you how to create an excel Spreadsheet from scratch. Add color to the excel spreadsheet and basic formatting. You will also learn to create Data Validation, add subjects to your data validation. You will also learn to delete data validation.

• Language: English
• Publisher: Marie Eklof
• Release date: Sep 17, 2022
• ISBN: 9798218064334

Book preview

Marie’s Computer Notes

Microsoft® Excel™

Data Validation

––––––––

by Marie Eklof

All Rights Reserved

No part of this book may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording, or by any information and retrieval systems, without the written permission of the Publisher, except where permitted by law. All product information was carefully prepared based on the latest information available and, to our knowledge, was correct at the time of publication. However, this publication could include inaccuracies or typographical errors, and Marie Eklof and Cyan Cues cannot be held responsible for inadvertent errors or omissions that may appear in this document.

Trademark Notices

Microsoft® Excel™ copyright held by Microsoft. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks and trade names featured or referred to within this book are the property of their respective owners.

Marie’s Computer Notes: Microsoft® Excel™ Data Validation

©2021 Cyan Cues

Contents

Forward

Chapter 1: Setting Up Your Spreadsheet

Creating the Microsoft Excel Spreadsheet

Saving the Spreadsheet

Changing the Color of the Spreadsheet

Changing the Border Line Style of the Spreadsheet

Changing the Font Style of the Header Row

Changing the Font Size of the Header Row

Changing the Color of the Header Row

Changing the Border Line Style of the Header Row

Changing the Border Color of the Header Row

Wrapping Text

Freezing Panes

Chapter 2: Using Data Validation for Quality Control

Using Data Validation in Your Personal Life

Creating Data Validation with Numbers

Creating Data Validation with Text

Creating Custom Warning Messages

Creating Custom Error Alerts

Clearing Data Validation From the Header Row

Chapter 3: Filtering and Sorting

Filtering Your Spreadsheet Data

Sorting Data Validation in Alphabetical Order

Chapter 4: Adding to the Data Validation List

Using a Keyboard Shortcut to Select the Drop-Down List

Adding Choices to the Data Validation List

Adding to the Data Validation List by Inserting a Row

Adding to the Data Validation List by Creating a Table

Chapter 5: Changing the Storage Column Information

Moving the Storage Column

Hiding the Storage Column

Hiding the Storage Column Using the Toolbar

Unhiding the Storage Column

Chapter 6: Removing Data Validation

Removing Data Validation in One Cell

Removing Data Validation from All Cells

Chapter 7: Applying What You Have Learned to Addresses

Creating the Spreadsheet with Addresses

More Practice with Addresses

Changing a Company Name

Glossary

Index

Forward

There are several reasons why I wrote this book. I wanted to have my computer notes easily accessible so that I could use them myself. I also wish I would have known about data validation when I started to work in Excel, since