Format in Excel 2013
Splitting text strings without using formulas
If you want to paste text in your worksheet, you can use Excel's Convert Text to Columns Wizard.
How to protect spreadsheets
You can significantly reduce the number of errors in data entry in Excel by protecting changes of specific
spreadsheets (worksheets) and cells.
Protecting spreadsheet elements
Working with large and complex Excel workbooks, especially when entering large amounts of data, no one is
protected from accidental changes in formulas, formats and other spreadsheet elements. But you can protect
yourself from too much work on finding and eliminating such errors by protecting the individual spreadsheet
elements.
Adding a background image to the spreadsheet
You can make your Excel spreadsheets more appealing by choosing graphics file to serve as a background for a
spreadsheet similar to the wallpaper that you may display on your Windows desktop.
Combining text and formatted values
The Excel TEXT function enables you to specify numbers and date format.
Custom cell format
Excel includes a variety of built-in formats that cover general, numeric, currency, percentage, exponential,
date, time, and custom numeric formats. You can also design your own custom formats based on one of the
built-in formats.
Adding and removing page breaks
On printing worksheet you might not be satisfied with the current pagination, so you might need to insert or
remove manual page break.
Allow specific users to edit ranges in a protected spreadsheet
Excel offers you an ability to assign user-level permissions to different areas on a protected spreadsheet.
You can specify which users can edit a particular range while the spreadsheet is protected. As an option,
you can require a password to make changes.
Share workbook and track changes
With Excel built-in tools you can easily work together on workbooks and monitor who, when and what changes
made. E.g., track project status and tasks.
Protecting workbook elements
Much like as you can protect elements of each Excel spreadsheet (see Protecting spreadsheet elements for
more details), you can protect structure of the sheets in the workbook, prohibiting renaming, moving and
other operations.