Excel tutorials

Align Text and Formatting Cells

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'.

Types of alignment of the text in an Excel cell

On the 'Home toolbartoolbar', 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.

Wrapping text, indented text, angled text, vertical text in an Excel cell

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.

Formatting and aligning data using the Alignment tab in the Format Cells dialog box

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

Lock 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.

Notice 'Text control' check box: Wrap text, Shrink to fit and Merge cells.

How to write text in an Excel cell, and it is written in multiple row lines

The dialog box 'Format cells' you can open and right-click on an Excel cell and then choose the command 'Format Cells'.

How to hide content of Cell

Hidden content of cells in excel