Connect with us

Excel

What are the types of data you enter in MS Excel

Published

on

types of data you enter in MS Excel

How to Entering Data in Cell.

Whenever you enter in excel you are given a blank file (Workbook) containing one worksheet. The worksheet is the combination of multiple cells (In each worksheet there are multiple rows and columns, intersect, areas ‘frows and columns create a rectangular each rectangular zone is called a cell) we will enter data under different cells.

Source:-https://advanceexcelxp.blogspot.in

Types of data you can enter in Excel.

An Excel workbook can hold any number of worksheets, and each worksheet is made up 0 more than 17 billion cells. A cell can hold

  • Numerical values
  • Text
  • Date & Time
  • A formula that returns a value, logical value or text.

The text is any combination of letters, numbers, and spaces. By default, a text is automatically left aligned in a However, Numbers, and Dates are right aligned.

A worksheet Can also hold charts, diagrams, pictures, buttons, and Other Objects. These Objects contained in cells. Rather, they reside on the worksheet draw layer, which is an invisible layer on each worksheet.

Moving around a Worksheet.

At the opening interface excel provides you a default workbook name book1. When you want to place your cursor or activate a cell in order to insert, edit or format the cells, there are ways to help you.
You can use:

  • Mouse
  • Keyboard
  • Name box on the formula bar and Go To Dialog box

Navigating with your keyboard

You can use the standard navigational keys on your keyboard to move around a worksheet. These keys work just as you’d expect: The down arrow moves the active cell down one row, the right arrow moves it one column to the right, and so on. PgUp and PgDn move the active cell up or down one full window. (The actual a number of rows moved depends on the number of rows displayed in the window.

Source:http://www.thecompanyrocks.com

Navigating with your mouse.

To change the active cell by using a mouse, click another cell; it the active cell. If the cell that you want to activate isn’ t visible in workbook window; you Can use scrollbars to scroll the window in any direction. To scroll one cell, click either arrow on the scrollbar. To scroll through a complete screen. click either side of the scrollbar’s scroll box, You also can drag the scroll box for faster scrolling.

press Ctrl while you use the mouse wheel to zoom the worksheet. if you prefer to use the mouse wheel to zoom the worksheet without Ctrl. office ButtonExcel Options and select the Advanced section. Place a checkmark next to the Zoom on Roll with IntelliMouse check box.

Using the scrollbars or scrolling with your doesn’t change the Etive cell. It simply scrolls the worksheet. To change the active cell. you must dick a cell after smiling.

If your mouse has a wheel on it. you can use the mouse wheel to scroll vertically. Also, if you click the wheel and move the mouse in that direction. the worksheet scroll automatically in that direction. The more you move the mouse, faster the scrolling.

Name box on the formula bar and GO to the Dialogue box

Source: www.advanceexcelxp.blogspot.in

GO TO

Source: https://advanceexcelxp.blogspot.in

 

Cell Box 

Source:-https://advanceexcelxp.blogspot.in

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 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.

Continue Reading

Facebook

Trending