Connect with us

Excel

How to use MS Excel 2016 Best Fit or Auto Fit features

Published

on

MS Excel 2016 best fit or auto fit

The concept of Workbook and Worksheet.

When you open Excel, the Excel application window opens with a new Excel workbook. A Workbook is a  multi-page Excel document. After saving the Excel file or workbook it takes the default extension. XLSX in its filename. Each page in the workbook is called a Worksheet. The active worksheet is displayed in the
document window. By default, a new workbook has one sheet in office 2013.

You can add or remove sheets from a workbook to suit your need. Sheet tabs and the navigation buttons
belong to the extreme left end of the horizontal scrollbar. Click 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 your computer’s temporary memory. If you exit Excel,
that data will get lost. Therefore, the important matter has to be saved within permanent memory using 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 saves a copy of your work automatically every ten minutes. To adjust this setting (or turn it off), use the Save tab of the Excel Options dialog box. To display this dialog box, choose File Button
Options. However, you should never rely on Excel’s Auto Recover feature. Saving your work frequently is a
good 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.

Pages: 1 2

Click to comment

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Excel

How to change the background color of text in excel organised worksheet

Published

on

How to change the background color of text in excel organised worksheet

How to change the color of the text.

  1. Select the cell, range of cell, text or characters that you want to format with different text color.
  2. Go to Home Tab ⇒ Font group, do one of the following:

Change the background color of the text.

Select the cell, range of cells, text, or characters that you want to format with a different background color.

On the Home tab, in the Font group, do one of the following:

  • To change the background color, click the arrow next to Fill Color and then under Theme Colors or Standard Colors, click the background color that you want to use.
  • To apply the most recently selected background color, click Fill Color
  • To apply a color other than the available theme colors and standard colors, click More Colors, and then define the color that you want to use on the Standard tab or Custom tab of the Colors dialog box.

Apply a pattern or fill effect to a background color.

  1.  Select the cell, range of cells, text, or characters to which you want to apply a background color with fill effects.
  2. On the Home tab, in the Font group, click the Format Cell Font dialog box launcher next to Font, and then
    click the Fill tab.
  3. Under Background Color, click the background color that you want to use.
  4. Do one of the following:
  • To use a pattern with two colors, click another color in the Pattern Color box, and then click a pattern
    style in the Pattern Style box.
  •  To use a pattern with special effects, click Fill Effects, and then click the options that you want on the
    Gradient tab.

Organize Worksheet

Rename Move or Copy Sheet and Tab color

Go to Home Tab ⇒ Cells group⇒ Format ⇒ Choose Rename Sheet / Move or Copy Sheet or any required option to change the format of a sheet.

Rename Sheet – Use this option to change the name of the worksheet as well as the sheet tab. You can do the same thing by double-clicking on the sheet tab or right click on the sheet tab, and from the popup select Rename option. Excel highlights the name on the sheet tab so that you can edit the name or replace it with a new name. Sheet names can be up to 31 characters, and spaces are allowed. However, you can’t use the
following characters in sheet names: (:) Colon,(Front slash, (\) Backslash, (?) Question mark,
(*) Asterisk.
Move or Copy Sheet — Use this option to Move or copy worksheets in the same or another workbook. (To move a worksheet to a different workbook, both workbooks must be open.)

Tab Color — Use this option to change the color of your worksheet tabs. For example, you may prefer to color code
the sheet tabs to make identifying the worksheet’s contents easier.
Hide Sheet and Unhide Sheet — Use this option to hide and unhide the current worksheet.

Continue Reading

Excel

How to working with rows and columns in excel 2016

Published

on

Working with Rows and Columns

Rows and Columns make up an excel worksheet. Every worksheet has an exactly 1,048,76 rows and 16,684 columns and these values can’t be changed. you can insert/delete row(s) and columns(s) but here rows and columns will be deleted automatically from the last according to the number of rows and columns inserted.

Inserting Rows and Columns

  • Inserting rows in excel is very simple. Right click on row number before which you want to insert the row and select insert option from the popup menu that appears. Accordingly, you can insert Columns(s) right clicking on the selected columns and clicking on the insert option. Columns always insert just before your selected columns(s).

Alternatively,

you can also insert row(s) and columns(s) from the Home Tab ribbon click on the insert button and clicking on the insert sheet rows or columns option.

How to Deleting Rows or Columns

Row(s) or columns(s) can be deleted by right-clicking on the selected Row(s) or columns(s) and clicking on the delete option.

  • Right click on the selected rows and click on delete option from the Dropdown list, selected rows and columns will be deleted. here two rows are selected naturally two will be deleted. Accordingly, you can delete columns right click on the selected columns and click on delete option from the dropdown list.

Alternatively,

You can also delete selected row(s) or columns(s) clicking on delete sheet Rows or Columns from the insert button under the Home ribbon’s cell group.

how to Hide/Unhide rows and columns.

To get the option of hiding and unhiding rows and columns, go to the format button of Home Tab.

  1. To hide the selected rows click on Hide Rows and for Hiding columns click on Hide Columns. contents of the hidden rows /columns will not be
  2. To get back the hidden rows/columns, select the previous and next rows or columns of the hidden Row(s) /columns or select the entire worksheet, and then choose any of these options accordingly. all the hidden rows/columns will come back immediately.

How to Adjusting Rows hight and Columns width

Row Height ⇒ This option is used to changing the row height of the selected row or rows to the defined value. the following dialog box appears, when you click this option, type the value and click on OK button.

AutoFit Row Height ⇒ This feature is used to changing the height of the selected cell(s) to fit the contents accordingly. this can be done by Best Fit Option.

Column Width ⇒ This option changed the width of the selected columns. the following dialog box will appear, define the value and then click on OK Button.

Autofit columns width ⇒ This option changed the columns width immediately to the appropriate size to fit the contents with it.

Default Width ⇒ It shows the value of the standard columns width as 8.43

How to select a cell,  range, or text in a cell 
To SelectDo this 
A single cellClick the cell, or press the arrow keys to move to the cell.
A range of cellClick the first cell in the range, and then drag to the last cell, or hold down SHIFT while you press the arrow keys to extend the selection.
You can also select the first cell in the range, and then press F8 to extend the selection by using the arrow keys. To stop extending the selection, press F8
again.
All Cells on a worksheetClick the Select All button. to select the entire worksheet, you can also press CTRL+A. Note if the worksheet contains data, CTRL+A Select the current region. pressing CTRL+A a second time selects the entire worksheet.
Nonadjacent cells or cell rangeSelect the first cell or range of cells, and then hold down URL while you select the other cells or ranges.
You can also select the first cell or range Of cells, and then press SHIFT+F8 to add another nonadjacent cell or range to the selection. To stop adding cells or ranges
to the selection, press SHIFT+F8 again.
NOTE: You cannot cancel the selection of a cell or range of cells in a nonadjacent selection without canceling the entire selection.
An entire row or columnClick the row or column heading.
1 Row heading
2 Column heading
or column by selecting
You can also select cells in a row the first cell and then pressing CTRL+SHIFT+ARROW key (RIGHT ARROW
or LEFT ARROW for rows, UP ARROW or DOWN ARROW for columns).
NOTE If the row or column contains data, CTRL+SHIFT+ARROW key selects the
row or column to the last used cell. Pressing CTRL+SHIFT+ARROW key a second time selects the entire row or column.
The first or last cell on a worksheet or in a Microsoft Office Excel table or DatabasePress CTRL+HOME to select the first cell on the worksheet or in an Excel list.
Press CTRL+END to select the last cell on the worksheet or in an Excel list that
contains data or formatting.
Cell to the last used cell on the worksheet(lower right corner)Select the first cell, and then press CTRL+SHIFT+END to extend the selection od cell to the last used cell on the worksheet(lower-right corner)
Cell to the beginning of the worksheetSelect the first cell, and then press CTRL+SHIFT+HOME to extend the selection of a cell to the beginning of the worksheet
More or fewer cells than the active selectionHold Down SHIFT while you Click the last cell that you want to include in the new selection. The rectangular range between the active cell and the cell that you click becomes the new selection.
Continue Reading

Excel

How to customize data format alignment,number grouping

Published

on

customize data format alignment,number grouping

What are the types of data Excel Supports

Excel mainly supports Two types of data: Text and Number. You can format them using the font, alignment and number grouping. The command of font group is same as MS-Word and also their usage. the alignment and number group provides some special buttons as shown in the figure.

  •  Make all content visible within a cell by displaying it on multiple lines.
  • A single cell created by combining two or more selected cells. The contents Of the single cell appear in the center of the merged cell.S
  • elect various currencies formats for the selected cells.
  • If you want to change the currency symbol, then go to Start Menu ⇒ Control PanelRegional and Language options. Change the default currency symbol to your desired one.
  • Percentage button allows a percentage sign as a suffix with the numeric data and multiplies the number by 100 (hundred).
  • These commands are used to increase or decrease the number of decimal places. Normally it is round off the figures.
  • These Indent buttons are used to change indentation within a cell(s).
  • Rotate you text diagonally or vertically. This is a great way to narrow Columns.

How to customize editing data (Cut, Copy & Paste)

Edit Data: You can change a data in a cell directly by overwriting the same or press F2 function Key / double click on the cell for editing.

Copy & Paste Data: You can copy an entry into surrounding cells by dragging the AutoFill handle of the cell contents of which you want to copy, that will appear at the right-bottom corner of the cell. Drag the fill handle in
any direction to copy the data to adjacent cells. A small box or bubble appears to let you know exactly what data is being copied.

This feature of Excel is called AutoFill. Using this dragging method of Fill handle you may copy data as well as formula. This can also be performed by using Home Tab ⇒Clipboard Group ⇒Copy and Paste command sequentially. Instead of Ribbon, you can use shortcuts also; Ctrl + C keys together for Copy option and Ctrl +
V keys together for Paste option.

Moving Data: To move data from one location to another, you can use Ribbon, i.e., Go to Home Tab ⇒ Clipboard Group ⇒ Click Cut command or press Ctrl + X keys together. Keep your cursor on the target cell and click Paste command on clipboard group or press Ctrl+V. Otherwise, drag the border of the selection to
the required area.

Delete Data: To delete the contents of a cell completely, place the cell pointer on the cell and press Delete or Del key from the keyboard, otherwise select Home Tab⇒Editing Group⇒Clear⇒Clear All.

Work With Worksheet.

Changing Sheet Name.:- You can change the Name of the sheet tabs

  1. Double-click on the sheet tab of the worksheet you want to rename or right-click
    on the tab, type the name and press enter.
  2. Select Rename option from the context-sensitive popup menu, type the name and press enter.
  3.  Right click on Sheet tab -5 the current name will be highlighted. Type a new name and press Enter key.

Adding a New Worksheet

  1. Right-Click on Sheet Tab
  2. Choose and click insert option from the popup menu.

OR – To quickly insert a new worksheet at the end of the existing worksheets, click the Insert Worksheet tab at the bottom of the screen.
OR press Shift+F11
Removing a Worksheet
1) Right-click on the sheet tab
2) and click Delete option from the popup menu.
Be careful when deleting worksheets as you cannot undo the deletion.

Want to Buy Excel Click Here 

 

Continue Reading

Facebook

Trending