write short note on File format and Cell Alingment
Answers
Answer:
Text and numbers may be aligned using the left-align, center, and right-align buttons on the Formatting toolbar:
Alignment Buttons on the Toolbar
To align text or numbers in a cell:
Select a cell or range of cells.
Click either the Left-Align, Center, or Right-Align buttons on the Standard toolbar.
The text or numbers in the cell(s) take on the selected alignment treatment.
Changing horizontal cell alignment
We've previously seen how to align text or numbers using the left-align, center, and right-align buttons on the Standard toolbar. You can also define alignment in the Alignment tab of the Format Cells dialog box.
Horizontal Alignment Examples
The Horizontal section features a drop-down menu that contains the same left, center, and right alignment options in the picture above, as well as several more:
Fill
This fills the cell with the current contents by repeating the contents for the width of the cell.
Justify
If the text is larger than the cell width, Justify wraps the text in the cell and adjusts the spacing within each line so all lines are as wide as the cell.
Center Across Selection
Contents of the cell that are farthest to the left are centered across the selection of cells. This is similar to the Merge and Center command, except the cells are not merged.
To change horizontal alignment using the Format Cells dialog box:
Select a cell or range of cells.
Choose Format > Cells from the menu bar.
Formal and Cells Menu Selections
(You could also right-click and choose Format Cells from the shortcut menu.)
The Format Cells dialog box opens.
Click the Alignment tab.
Alignment Tab on the Format Cells Dialog Box
Click the Horizontal drop-down menu and select a horizontal alignment treatment.
Click OK to apply the horizontal alignment to the selected cell(s).
Changing vertical cell alignment
You can also define vertical alignment in a cell, similar to how it is done for horizontal alignment. In vertical alignment, information in a cell can be located at the top of the cell, middle of the cell, or bottom of the cell. The default is bottom.
Answer:
Cell allingment : cell alignment is how your text or numbers are positioned in the cell. ... You can align vertically, meaning towards the top, the middle or the bottom. And you can also align horizontally, meaning to the left, the center or to the right. Excel actually has its own defaults for alignment.
File format : The file format is the structure of a file that tells a program how to display its contents. For example, a Microsoft Word document saved in the .DOC file format is best viewed in Microsoft Word. Even if another program can open the file, it may not have all the features needed to display the document correctly.