Course sections

Introducing IBM SPSS Statistics, Lecture 3

General formatting Options

Wrap text
Wrap Text Feature in excel: The wrap text feature in excel automatically fits an entire long character/textual data within a cell. Type Reshmi Roy Choudhury in any cell. The length of the word is quite long and exceeds the cell width. Click on the cell where Reshmi Roy Choudhury is written->right click on mouse in the cell->Click on Format Cells->Alignment->under Text Control click on Wrap Text

Excel automatically adjusts the name within the cell width

Merge and Center Cells in Excel
Merge cell is a function in database programming that enables different nearby cells to be joined into a single larger cell. This is finished by choosing all cells to be merged and picking the “Merge Cells” order. Center means that it enables the alignment of text to be in the center.
How to Use Merge and Center in Excel?
1. Select the adjacent cells you want a merge.
2. On the Home button, go to alignment group, click on merge and center cells in excel.

3. Click on merge and center cell in excel to combine the data into one cell.
4. Once you click, merge and Centre, selected cells will be combined into one cell and the text comes in centered.

By default, Microsoft Excel aligns numbers to the bottom-right of cells and text to the bottom-left. However, you can easily change the default alignment by using the ribbon, Format Cells dialog or by setting your own custom number format. How to change alignment in Excel using the ribbon? To change text alignment in Excel, select the cell(s) you want to realign, go to the Home tab > Alignment group, and choose the desired option:

Vertical alignment
If you’d like to align data vertically, click one of the following icons:
• Top Align – aligns the contents to the top of the cell.
• Middle Align – centers the contents between the top and bottom of the cell.
• Bottom Align – aligns the contents to the bottom of the cell (the default one).
Please note that changing vertical alignment does not have any visual effect unless you increase the row height.

Horizontal alignment
To align your data horizontally, Microsoft Excel provides these options:
• Align Left – aligns the contents along the left edge of the cell.
• Center – puts the contents in the middle of the cell.
• Align Right – aligns the contents along the right edge of the cell.

To change the font:
By default, the font of each new workbook is set to Calibri. However, Excel provides many other fonts you can use to customize your cell text. In the example below, we’ll format our title cell to help distinguish it from the rest of the worksheet.
1. Select the cell(s) you want to modify.
2. Click the drop-down arrow next to the Font command on the Home tab. The Font drop-down menu will appear.
3. Select the desired font. A live preview of the new font will appear as you hover the mouse over different options.

4. The text will change to the selected font.
Note: The standard reading fonts are: Calibri, Cambria, Times New Roman, and Arial.
Format Painter
If you want to copy formatting from one cell to another, you can use the Format Painter command on the Home tab. When you click the Format Painter, it will copy all of the formatting from the selected cell. You can then click and drag over any cells you want to paste the formatting to.
Cell styles
Instead of formatting cells manually, you can use Excel’s predesigned cell styles. Cell styles are a quick way to include professional formatting for different parts of your workbook, such as titles and headers.
To apply a cell style:
1. Select the cell(s) you want to modify.
2. Click the Cell Styles command on the Home tab, then choose the desired style from the drop-down menu.

3. The selected cell style will appear.

Applying a cell style will replace any existing cell formatting except for text alignment.
Formatting text and numbers
One of the most powerful tools in Excel is the ability to apply specific formatting for text and numbers. Instead of displaying all cell content in exactly the same way, you can use formatting to change the appearance of dates, times, decimals, percentages (%), currency ($), and much more.

To apply number formatting:
1. Select the cells(s) you want to modify.
2. Click the drop-down arrow next to the Number Format command on the Home tab. The Number Formatting drop-down menu will appear.
3. Select the desired formatting option.

4. The selected cells will change to the new formatting style.

To use the Bold, Italic, and Underline commands:
1. Select the cell(s) you want to modify.
2. Click the Bold (B), Italic (I), or Underline (U) command on the Home tab.
3. The selected style will be applied to the text.

You can also press Ctrl+B on your keyboard to make selected text bold, Ctrl+I to apply italics, and Ctrl+U to apply an underline.

WhatsApp chat