Home > Excel Topics > Data

Excel Data Topics on Contextures

Tips for Excel data entry, find and select, tables, and sample data. Fix date problems, add or remove line breaks, avoid copy paste problems, troubleshoot, and more.

Create Excel Tables

Use named Excel tables for your data, so it's easier to sort and filter the data.

In the short video below, I show how to set up an Excel table. Get details and the Excel file on the Creating an Excel Table page.

	Get Sample Excel Data
	If you need Excel sample data for practice or training, go to my Excel Sample Data page. There's sample data for an office supply company, food sales, insurance, and several other examples to download.

	Time-Saving Data Entry Tips
	Shortcuts -- Save time in Excel with data entry tips and shortcuts. Add line break in cell, use Excel's hidden data entry form, fix paste problems, + more. Details on the Excel Data Entry Tips page.

Fill Blanks -- In Excel, fill blank cells with values from cells above, manually or programmatically. Details on the Fill Blank Cells in Excel Column page.