Data entry is the heart of Excel. Worksheets cannot enter data quickly and accurately, you can easily use the tools that can analyze and report advanced Excel users sometimes have to pick up more complex approach.





Quick access shortcuts
Try this quick and easy shortcut to entering data in Excel:

    Enter the current date: [Ctrl] +;
    Immediately above or to replicate data from cell line [Ctrl] + '(single quotes)

Add a hard return / to the cell material [Enter] when typing long paragraphs of text, if you move in the same cell, but would a new line, you just [Enter] can not suppress. It will take you to the next cell. Instead, in the same room at a line break or new line, press [Alt] + [Enter]. The trick is a new line or carriage return.

Keep leading zero you enter data
Are you the product code, charter number, or other attributes that one or more leading zeros to start? When this type of data entry, Excel, the number of entries and removes the leading zeros. Excel to convince you to enter a value with leading zeros, such as text and number formatting your worksheet cells.

There are two different approaches tried:

Text Approach # 1: Changing a text format for each item, the information in front of an apostrophe (') type. Will correctly sort the list.

Text Approach # 2: In preparation for entering data, the selected cells as text format.

    Choose (even an entire column) cells that contain numbers stored as text.
    Right-click on the selection and choose Format Cells, click the Number tab.
    Category list, click in the text and then apply to the right.
Go to last line in the list
Additional Navigation Excel shortcut for a list:

    [Ctrl] + [up arrow] take the first cell in the current column
    [Ctrl] + [Right Arrow] to the last cell in the current row
    [Ctrl] + [Left Arrow] to the active cell line used in

Copy and paste more than one item at a time
In another application, like Word or even - if you often want items from an Excel workbook that each cell time-consuming, object or image copy to copy and paste one by one. The Office Clipboard instead of the items you cut or copy (24 items in Office 2010, 2007, 2003 and XP/2002) is the last set of use. The big plus to the Office Clipboard is shared by each Office application. Excel 2010 or Excel 2007 to turn on the Office Clipboard:

    Click on the tab.
    Clipboard group stopped.
    To open the Office Clipboard in the task pane under groups - right-click on the button.

If the Office Clipboard in Excel 2003:

    Edit> Office Clipboard to choose.

Every item you cut or copy will appear in the Office Clipboard. Follow these steps to the clipboard with one of:

    Click Options to customize how you want to work with the Office Clipboard.
    Click an item to paste into your worksheet.
    Each item in the clipboard to paste into your worksheet, click Paste All.
    Clear all to delete the clipboard click each item.
To remove individual items, the mouse pointer over an item, the down arrow that appears next click,               remove it and choose Delete.



Thanks For Reading This Post.