In Excel, formatting worksheet (or sheet) data is easier than ever. You can use several fast and simple ways to create professional-looking worksheets that display your data effectively.

The TEXT function lets you change the way a number appears by applying formatting to it with format codes. It's useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols.

Format cells, numbers, text, and other data in Excel to improve readability. Learn how to apply borders, shading, text colors, and more.

Lists the file formats that are supported in Excel. The topic also includes a list of unsupported file formats and some suggested workarounds.

Enter data manually in worksheet cells Fill data automatically in worksheet cells Turn Flash Fill on in Excel 2016 Move or copy worksheets or worksheet data Create a list of sequential dates Create a custom list Select cells, ranges, rows, or columns on a worksheet Copy visible cells only Move or copy cells and cell contents Paste options

Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.

Use create.microsoft.com to find and download free Excel for the web templates. Download free Excel templates for calendars, invoices, budgeting, and more.

Learn how to format your data in Excel so that you can use Copilot to get insights, generate formulas for new columns, and highlight, sort, and filter your data.

You can apply conditional formatting to a range of cells (either a selection or a named range), an Excel table, and in Excel for Windows, even a PivotTable report.

You can use the built-in number formats in Excel as is, or you can create your own custom number formats to change the appearance of numbers, dates, and times.