Skip to main content

Getting Started With Excel

Open the workbook to start your work on a worksheet .At times , you might required name to insert or Delete a worksheet , and cells to be selected .

Create a Workbook -Select the New ..command from the File menu. The workbook is opened by Default Name of BOOK1.

Open a Workbook -To open an existing workbook ,sheet Open option from the File menu. Names of The Recently used files are listed in the file menu and can be selected by merely clicking on the name Of the file to be opened .
Find a Workbook -Choose File ->Open command .Select Find File . option from the dialogue box That is opened .Consequently ,another dialogue box is opened in which the details like name ,directory are to be given.

Insert a Worksheet -To insert a workbook between two worksheets choose Worksheet option from the Insert menu.

Delete a Worksheet -To remove a worksheet from the workbook ,select Delete Sheet from the Edit menu. A dialogue box will appear to confirm this action.

Move the Worksheet -To move the worksheet in the same workbook, place the mouse pointer on the sheet tab, press the left mouse button and drag it to the desired position. Release the button.

Selecting Cells-You can select a single cell or a group of cells using mouse or keyboard .

Using Mouse-Click on the cell with the left mouse button .The cell gets selected and becomes the active cell. Whatever you type goes into this cell. To select a range of cells, click on one cell, hold down the left mouse button and drag the mouse pointer to the last cell of the range you want to select.

Using Keyboard- 

To Select                                                                                                           Press                          
Current Cell                                                                                                     Enter 
Entire Column                                                                                                 Ctrl +  Spacebar 
Entire Row                                                                                                       Shift + Spacebar 
Entire Worksheet                                                                                            Ctrl+ Shift +Spacebar 
Extend Selection to End of                                                                             End,  Shift +Arrow Key
Data Block
 


Labels:

Comments

Post a Comment

Popular posts from this blog

Worksheet Layout and Print Setup एक्सेल में प्रिंट लेआउट कैसे सेटअप करें

  Page set -up within worksheet Formatting and Printing worksheet :- As with other Windows programs, Excel also provides you with the feature of WYSIWYG (What You see is what get).Therefore it is always better to start with the page layout which you want as a printer copy also .for this :- 1. Open the File menu by clicking on the File . 2. Click on the Page Set -up. The following dialogue box is displayed . The Page option allows you to set the paper size , orientation of the data ,scaling of the area etc. Excel inserts automatic page -breaks also . The Margins tab, when clicked , displays the displays the dialogue box. You can set the top ,bottom ,left and right margins of the page . These are the distances in inches from the edge of page . This also allows you to see the preview of the data when it will be printed . Header / Footer tab gives you option to set the header ( which will be displayed on top of every page ) and the footer ( which will be displayed at the bottom of ev...
Post a Comment
Read more

Rearrange Cell Contents within Excel

Rearrange Cell Contents Within MS Excel :-  Rearrange cell contents includes moving or copying or clearing cell contents . This also involves inserting or deleting rows or columns . This can be done either by cut and paste method or drag and drop method .   Move or Copy Cell Contents . Drag and Drop method  1. Select the range of cells which are to be moved . 2. Point to the border or range . The mouse pointer will change its shape to an arrow. 3. To move , press the left mouse button, drag it to the new location and release the mouse button . 4. To copy , Press the cell key while dragging the contents. Short -end menu.    1. Press the right mouse button while dragging and dropping cell contents . 2. From the short  -end menu, choose Move to move the contents copy to copy the contents. Cut and Paste Method  1. Select the cell range . 2. Select Edit - > Cut ( to move the range of cells )                 ...
1 comment
Read more

What is a spreadsheet # how to make a spreadsheet

A spreadsheet is a computer application for the computation, organization, analysis, and storage of data in tabular form—spreadsheets we re-developed as computerized Analogy of paper accounting Worksheets. The program operates on data entered in cells of a table. Each cell may contain either numeric or text data or the results of formulas that automatically calculate and display a value based on the contents of Other cells. The term spreadsheet may also refer to one such electronic document. Spreadsheet users can adjust any stored value and observe the effects on calculated values. This makes the spreadsheet useful for "what-if "analysis Since many cases can be rapidly investigated without manual Recalculation. Modern spreadsheet software can have multiple interacting sheets and can Display data either as text and numerals or in graphical form. Besides performing basic arithmetic and mathematical functions, Modern spreadsheets provide built-in functions of common financial ...
1 comment
Read more