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

MS Excel 2016 Best Fit Or AutoFit

  1. If the cell width is not adequate for the contents of a column, you can change to its exact required size using either Best Fit feature or Auto Fit option. Best Fit is used not only to change the cell width as well as to change the row height also.
  2. Place the mouse pointer on the separator of the column letters or row numbers, then double«click on it, immediately the Column width or Row height will be changed to display the widest entry within that particular column or row. Always you have to consider the separator between the current column or row and next column or row. This is known as Best Fit feature.
  3. To make AutoFit, select the particular columns and then go to Home TabCell Group ⇒Click FormatAutoFit Column Width. The columns are automatically adjusted so that each column is wide enough to show the widest content in that particular column.
Place the mouse Pointer on the separator of two column letter or row number when a mouse pointer converts a Symbol like below then double-click on it.

 

 

 

Similarly. to adjust the height Of the row automatically, 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 each row’s height
is enough 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 a time.

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