## Tools in Excel 365

### Import a text file to an Excel spreadsheet

Often you need to import data to the Excel spreadsheet from a text file. Microsoft Excel offers a

**Text Import Wizard**to import data from different text file formats:### Import a structured text file to an Excel spreadsheet

When you import data from a text file to the Excel spreadsheet, Microsoft Excel launches a

**Text Import Wizard**to help you to import data correctly. Here you can import all or some data from text files of different formats:### How to use Camera tool in Excel

When you work with some Excel elements such as tables, charts, you spend a lot of time positioning them
and formatting them. Here will find the feature that Excel proposes to help you create a perfect presentation of
your data.

### Turn off the automatic creation of hyperlinks in Excel

Excel automatically creates hyperlinks if you type or insert some text that Excel sees like a hyperlink
such as **e-mail**. You can quickly turn off and turn on the automatic creation of hyperlinks for more comfortable work in Excel ☺.

**URL**or### Using Solver

**Solver**tool allows you to specify multiple adjustable cells and constraints on the values that the adjustable cells can have, generate a solution that maximizes or minimizes a particular worksheet cell, generate multiple solutions to a problem.

### Excel Formula Evaluator

If you would like to understand better how some of these complex array formulas work, consider using a handy
tool -

**Formula Evaluator**:### AutoCorrect for data entry

You can use Excel's

**AutoCorrect**feature to create shortcuts for commonly used words or phrases.### Using the formula bar as a calculator

If you simply need to perform a calculation, you can use the

**Formula**bar as a calculator.### How to see formulas on the spreadsheet

Sometimes it is handy to view (and print) the formulas in all the cells in a spreadsheet without having to enter each cell manually.