Connect with us

Excel

How to use Best Fit or Auto Fit features in Excel

Published

on

MS Excel 2016 best fit or auto fit

 Best Fit Or AutoFit

  1. If the cell width is not adequate for the contents of a column, you can change to the exact size required using either the Best Fit feature or the Auto-Fit option. Best Fit is used not only to change the cell width but also to change the row height.
  2. Place the mouse pointer on the column letter or row number separator, then double click on it, immediately change the column width or row height to display the widest entry within that particular column or row. Always consider the separator between the current column or row and the next column or row. This feature is known as Best Fit.
  3. To make AutoFit, select the columns and go to Home Tab ⇒ cell group ⇒ Click Format ⇒ AutoFit Column Width. The columns are automatically adjusted so that each column is wide enough to display the widest content in that particular column.

Place the mouse pointer on the two-column letter or row number separator when a mouse pointer converts a symbol as below, then double – click on it.

Likewise. To automatically adjust the height of the row, first select all the rows to be adjusted. Go to Home Tab Cell Group Click Format— Y AutoFit Row Height. The rows are automatically adjusted so that the height is of each row is sufficient to display the entry of such height in that row. AutoFit & Best Fit option can change the width or height of multiple columns or rows at the same time

The concept of Workbook and Worksheet.

When you open Excel, a new Excel workbook opens the Excel application window. A Workbook is an Excel multi-page document. It takes the default extension after saving the Excel file or workbook. XLSX in the filename. Every page in the workbook is called a worksheet. The active worksheet is displayed in the document window. A new workbook has one sheet in office 2013 by default.

You can add or remove sheets from a workbook to suit your needs. Sheet tabs and navigation buttons belong to the horizontal scrollbar’s extreme left end. Click on a sheet tab to move to another worksheet or use the navigation buttons to scroll through the sheet tabs.

Simple Mathematical Calculation

Mathematical operator, such as + (for addition), – (for subtraction), * (for multiplication) and /(for division)
makes a spreadsheet program so useful.

Working with Formulas and Functions.

After you enter a formula, the cell displays the calculated result of the formula. The formula itself appears in the
Formula bar when you select the cell, however.

Following are a few examples of formulas:

=A1+A2+A3+A4Adds the values in the cell A1, A2, A3 and A4
=B1-B2Subtract the values in cell B1 and B2
=C1*C2Multiplies C1 and C2
=D1/D2Divide the value of cell D1 with cell D2

 

To apply auto sum, just keep your cursor on the target cell and click ∑Autosum command under Home Tab ⇒ Editing Group.

Saving a Workbook

Whatever you type in a workbook is stored only in the temporary memory of your computer. If you exit Excel, the data will get lost. Therefore, the important matter must be saved in permanent memory using the save command.
To Save a New Workbook:

  1. Click File button ⇒ Save as ⇒ Click Excel Workbook. This will launch the Save as dialog
  2. Type a new file name (e.g. – ABC.XLSX) and click Save Button.

The default extension name of an Excel workbook is.XLSX

To Save an Existing Workbook:

1.)   Select File Button + Click Save.  FILE 

2.)  Type a new name (e.g. — Day1.XISX) and click on save button

By default, Excel automatically saves a copy of your work every ten minutes. To adjust this setting (or turn it off), use the Save tab in the Excel Options dialog box. Choose File Button Options to display this dialog box. However, you should never rely on the Auto Recover feature of Excel. Saving your work is often a precocious idea.

Opening an Existing Workbook.

To open an existing file of Excel from the Hard disk:
I) Select File Button ⇒ Open or press Ctrl + O.
2) The Open dialog box will appear, choose your file from a relevant path and click the open button.

Closing Workbook and Excel
To close the active workbook window:

  • Click the window ‘s close button or choose office button Click close or Press Ctrl + W.
  • OR To Close Excel, choose File Button to close.

Read This >>> Advance slide narration on powerpoint

Advertisement
1 Comment

1 Comment

  1. Paragraph writing is also a excitement, if you
    know then you can write or else it is complicated to write.

Leave a Reply

Your email address will not be published. Required fields are marked *

Trending