Formatting Cell

Formatting Cell

The cell holds any type of data in the spreadsheet. The cell data can be formatted using formatting toolbar or cell formatting window. It is also possible to format the cell using Format cells dialog box. The Format cells dialog box can be opened using Format→cells using the Format menu, or from context menu opened through right clicking the cell. The various options in the Format→cells dialog.

Apply different font types on a worksheet
Font Size
Apply different font sizes on a worksheet
Make the selected text bold
Italicize the selected text
Underline the selected text
Left Alignment
Align text in a cell to the left
Center Alignment
Align text in a cell to the center
Right Alignment
Align text in a cell to the right
Increase decimal places
Show more precise value by showing more decimal places
Decreased decimal places
Show less precise decimal places

Use of dialog boxes to format values

The format cells dialog box in the toolbar can be used to find more about formatting a cell or range of cell. You can open this Format Cell dialog box by pressing the shortcut key Ctrl+1

Formatting a range of cells with decimal places

The division of different numbers may result in varied decimal places in the quotient. In such cases it is necessary to format the number to a fixed number of decimal places.

Following are the steps to format a cell to the required number of decimal places:

  • Select the range of cells.
  • Open the ‘format cells dialog’ box
  • Click the ‘Number’ tab
  • Select the ‘Number’
  • Change the decimal places as required
  • Click ‘OK’

  • A spreadsheet, also known as a worksheet, is a row and column arrangement of data and the formulas to manipulate the data.
  • A spreadsheet can be used for a variety of applications like business forecasts, inventory control and accounting.
  • Every Excel file is a workbook that can contain more than one worksheet.
  • Cell is defined as the space where a specified row and a column intersect.
  • Worksheets can contain labels, numbers or formulas.
  • Worksheet allows selecting both contiguous and non-contiguous cells.
  • A range is a group of cells referenced with a name. The range reference consists of the first and last cell addresses separated by a colon.
  • The AutoSum button on the Standard toolbar adds numbers automatically and also suggests the range of numbers to be added.
  • Formulas and functions are automatically updated with a change in the source cell or position of the formula.
  • In Relative referencing, the reference is adjusted relative to the new location of the formula.
  • In Absolute referencing, the cell reference does not change but remains fixed while pasting formulas.
  • Functions are pre-written formulas which must begin with an “=” sign.
  • Cell ranges can be named and used in place of cell references.
  • The AutoFill handle is a very useful tool to fill in logical series.
  • Cell comments are additional explanatory notes which can be attached to a cell in a spreadsheet.
  • Charts are an excellent tool to present data graphically and also help in analysing and comparing data.
  • The most powerful feature of a spreadsheet package is the “What-if analysis”. Using this feature, we can change values and immediately see the effect as the entire worksheet is automatically updated, based on the change in the values.


CCC Online Test 2021 CCC Practice Test Hindi Python Programming Tutorials Best Computer Training Institute in Prayagraj (Allahabad) Best Java Training Institute in Prayagraj (Allahabad) Best Python Training Institute in Prayagraj (Allahabad) O Level NIELIT Study material and Quiz Bank SSC Railway TET UPTET Question Bank career counselling in allahabad Sarkari Naukari Notification Best Website and Software Company in Allahabad Website development Company in Allahabad