Learn how to enter text , numbers, dates, or times in one cell or several cells at once, in one worksheet or multiple worksheets at the same time.

Enter and format data Enter & find Format Layout Validation Customize Enter data manually in worksheet cells Fill data automatically in worksheet cells Turn Flash Fill on in Excel 2016 Move or …

If a worksheet contains so many columns that you can't see them all at a glance, use a form to make entering and browsing for data easier.

In these tutorials you learn how to import and explore data in Excel, build and refine a data model using Power Pivot, and create interactive reports with Power View that you can publish, protect, and share.

Use data validation rules to control the type of data or the values that users enter into a cell. One example of validation is a drop-down list (also called a drop-down box or drop-down menu). Watch …

There are three types of what-if analysis tools in Excel: scenarios, data tables, and goal-seek. Scenarios and data tables use sets of input values to calculates possible results.

Automatically fill a series of data in your worksheet, like dates, numbers, text, and formulas. Use the AutoComplete feature, Auto Fill Options button and more.

Learn how to insert data from a picture with Excel - and you can use your smartphone or tablet to take the picture. Excel's powerful AI capabilities can convert your hand written or printed data into a table.

You can insert a drop-down list of valid entries (also called a drop-down menu or drop-down box) in Excel to make data entry easier, or to limit entries to certain items that you define.

In Excel, you can enter the same data into several worksheets without retyping or copying and pasting the text into each one.