Connect with us

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 

 

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

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

Continue Reading

Excel

Different components of Ms Excel worksheet

Published

on

Different components of Ms Excel worksheet

A brief discussion about the different components of Excel’s opening screen.

What are main components of Excel?

The mainly used shortcut Key+Fun Button features briefly point out in below.

  • File Button
  • Quick Access Tool Bar
  • Different Tab Ribbons
  • Title Bar
  • Home
  • Insert
  • Page Layout
  • Formulas
  • Data
  • Review
  • View
  • Control Buttons
  • Name Box
  • Formula Bar
  • Row, Column, and Cells
  • Sheet Tabs
  • Horizontal and vertical Scroll Bar
  • Zoom Slider
  • Groups
  • Dialog box luncher

So, Are going to Describe whole things in Excel Worksheet.

Here’ we started from 1st to the last countdown. Please don’t skip any point if you really want to learn everything in excel.

Main components of Ms. Excel Worksheet

File Button: The leftmost tab on the Ribbon at the top of the Excel window — replaces the Office button from Excel 2007 and the File menu from Excel 2003 and earlier versions. This is where you’ll find commands and settings to manage and share your files.

Ms Excel file button

Quick Access Tool Bar: Quick Access toolbar contains some command icons. By default, this toolbar holds Save (Ctrl +S), Undo (Ctrl+Z), and Redo (Ctrl + Y) buttons. Although Quick Access toolbar can be customized to include your favorite command that you use frequently.

Different Tab Ribbons: It contains Home, Insert, Page Layout, Formulas, Data, Review, and Views Tabs. Each Tab holds a group of commands associated with that tab.

Title Bar: The title bar displays the name of the active Spreadsheet.

Ribbon: Below the title bar is the Ribbon, which includes all commands of Excel available in a single area so that you can work efficiently with the program. The commands available in the Ribbon vary, depending upon which tab is selected. Commands related to working with workbook are represented as buttons on the tabs that make up the Ribbon. The Home tab is active by default. Other tabs can be activated by clicking one of the other tabs, such as Insert, displays that tab’s buttons. The Ribbon is arranged into groups of related commands. Here’s a quick overview of Excel’s tabs. Click on different tabs to get the respective ribbon.

Home: You’ll probably spend most Of your time with the Home tab selected. ‘This tab contains the basic Clipboard commands, formatting commands, style commands, commands to insert and delete rows or columns, plus an assortment of worksheet editing commands

Insert: Select this tab when you need to insert something in a worksheet—a table, a diagram, a chart, a symbol, and so on.

Page Layout: This tab contains commands that affect the overall appearance of your worksheet, including settings that deal with printing.

Formulas: Use this tab to insert a formula, name a range, access the formula auditing tools, or control how Excel performs calculations.

Data: Excel’ s data-related commands are on this tab.

Review: This tab contains tools to check spelling, translate words, add comments, or protect sheets.

View: The View tab contains commands that control various aspects of how a sheet is viewed. Some commands on this tab are also available in the status bar.

Control Buttons:
At the right end of the title bar are the three familiar buttons that have the same functions in all windows programs. You can temporarily hide the word window by clicking the Minimize button, adjust the size of the window with the Restore Down/ Maximize Button, and close the active document or quit excel with the close button.

Name Box:
Address bar shows the address of the active cell. In the above figure active cell is that is why we are getting A1 in the name box.

 

Formula Bar:
The formula bar is located beneath the toolbar at the top of the Excel worksheet.
Use the formula bar to enter and edit worksheet data. The contents of the active cell will always
appear in the formula bar.

Rows, Columns, and Cells:
Every worksheet consists of rows (numbered 1 through 1,048576) and columns (labeled A through XFD). Each column is identified by one, two, or three letters: The first 26 columns use the letters A to Z. The next 26 columns use AA to AZ, the following 26 BA to BZ, and so on. When the two-letter combinations are exhausted, Excel uses three letters: AAA, B AAB, and so on. Each row is identified by a number, from 1 up to 1048576.
Each cell is identified by its column lettering and its row number. For example, the cell at the intersection of Column A and Row 1 is cell A1.

Sheet Tabs: Sheet tabs hold a list of worksheets by default it provides three Worksheets named Sheet1, Sheet2, and Sheet3 respectively.

Horizontal and Vertical Scroll Bar: The Scroll Bar is used to droll up/ down/ right and left and see the column/ row number changes until you release the mouse button.
Zoom Slider: A slider that magnifies or reduces the content in the worksheet area.
Groups: On each tab, buttons are organized into groups. Depending on the size of the program window, in some groups, the button you are likely to use most often is bigger than the rest.

Dialog box launcher:

Related but less common commands are not represented as buttons in the group. Instead, they are available in a dialog box, which you can display by clicking the Dialog Box Launcher at the right end of the group’s title bar.
Continue Reading

Trending