Our Recommendation for You Search your Query, You can find easily. for example search by book name or course name or any other which is related to your education

Followers

Formatting text and cell in Excel 2013

Align text and Formatting cells in Excel 2013

Align text or data in Excel cells is performed using the buttons on the toolbar 'Home' in the group commands 'Alignment'. In the picture below, see all the commands for text alignment, text wrapping in a cell and merge multiple cells into one cell.

Buttons for alignment of text or values ​​in Excel cells
An example of the alignment of the text in an Excel cell you see in the image below. There are six types of text alignment in cells that can be used via the buttons on the toolbar or via dialog 'Format Cells' in the zone 'Text alignment'.

Align text in cells of Excel

On the toolbar, the 'Home' notice group commands 'Alignment' and the command to open a dialog 'Format cells'. In the picture below you see the dialog box 'Format Cells' by which you can align text, indent text, write text at an angle, write the text vertically and the like.

Format Cells dialog box in Excel and format the text in the cells of Excel

Format numbers, values​​, time and date in an Excel cell


Numbers, monetary value, time, date, and other formatting you make the 'Number' tab in the Format Cells dialog box in Excel.

Formatting data in an Excel cell using the Number tab

Align text in Excel

Text alignment you make using the 'Alignment' tab in the Format Cells dialog box in Excel.

Alignment kartica za poravnanje podataka u Excelu

Font Formatting in Excel

Formatting font you make the 'Font' tab in the Format Cells dialog box in Excel. Here you can format text portions as 'exponent' or 'index' (m2, m3 H2O).

Formatting text using the tab 'Font' the Format Cells dialog box in Excel

Formatting the cell borders and tables in Excel

Formatting cells, cell borders make to 'Border' tab in the Format Cells dialog box in Excel.

Formatting the cell borders in Excel using the tab 'Border' in the Format Cells dialog box

Set the background color of a cell in Excel

Coloring cell background and so you make the 'Fill' tab in the Format Cells dialog box in Excel.

Formatting cells in Excel using the tab' Fill the Format Cells dialog box

Locking cells in Excel

Locking cells in a worksheet Excel workbook you make in the 'Protection' tab in the Format Cells dialog box in Excel.

Protecting and locking cells on the worksheet tab Protection in the Format Cells dialog box

Writing text in multiple rows of cells or wrap the text to fit in an Excel cell

If you have a column which we can not change the width and you must enter it in the text that is longer than the width of a cell or column then we need to wrap text, or shrink the text to fit within Excel cells.

Shrink text into multiple rows or wrap text in a cell Excel
The dialog box 'Format cells' you can open and right-click on an Excel cell and then choose the command 'Format Cells'-