:: HOME :: ABOUT US :: CLIENTS :: REGISTER DOMAIN :: SERVICES :: NASSCOM :: PRODUCTS :: DOWNLOADS :: FAQ :: FEED BACK :: CONTACT US
 
File
New
Open
Save
Close
Page Setup
Print Preview
Print
Exit
 
Edit
Cut
Copy
Paste
Fill
Clear
Delete
Delete Sheet
Move or Copy Sheet
Find
Replace
 
View
Toolbar
Formula Bar
Status Bar
Header & Footer
Full Screen
Zoom
 
Insert
Cells
Rows
Columns
Worksheet
Chart
Function
Comment
Picture from ClipArt
Picture from file
Picture from WordArt
Hyperlink
 
Format
Cells
Row AutoFit
Row Height
Row Hide
Row Unhide
Column AutoFit
Column Hide
Column Standard Width
Column Width
Sheet Background
Sheet Hide
Sheet Rename
Sheet Unhide
Autoformat
Conditional Format
Style
Tools
Spelling
Protect Sheet
Protect Workbook
Scenarios
Customize
Options
 
Data
Sort
AutoFilter
 
Window
New Window
Arrange
Hide
Unhide
 
 
Help
MS Excel Help
Show Office Assistant
What's This
 
 
New  
Creates a new blank Spreadsheet.
  1. Click on File menu.
  2. Select New from the menu items.
  3. New dialog box will appear with two tabs. The first tab contains the General workbook.
  4. The Second tab contains many Statement Templates.
  5. Select the appropriate one.
  6. Click on OK.
  7. A new blank spreadsheet will be opened.
Top
Open  
Opens or finds an existing Spreadsheet.
  1. Click on File menu.
  2. Select Open from the list.
  3. Open dialog box will appear.
  4. Click on the down arrow of the Look in Combo box.
  5. Click on the Drive letter, which contains the file to be opened.
  6. If the file is in any folder, select the folder.
  7. Click on Open Button.
  8. Select the file to be opened.
  9. Click on Open button to open the Spreadsheet.
Top
Save  
Saves the active file with its current file name, location, and file format.
  1. Click on File menu.
  2. Click on Savefrom the list.
  3. Save As dialog box will appear.
  4. Click on the down arrow of the Save in Combo box
  5. Click on the drive letter where you want to save the document
  6. If you want to create a new folder Click on Create New Folder icon.
  7. You will be prompt for a folder name. Type a folder name.
  8. Click on OK to create New Folder with the typed name.
  9. Type the File Name for the document in the specified area.
  10. Click on OK to Save the document.

If the document is already saved, then the Save As dialog box will not appear. But the document will be saved to the old location.
Top
Close  
Closes the Active File without exiting the Microsoft Excel program. If the file contains any unsaved changes, you will be prompted for save the file.
  1. Click on File menu.
  2. Select Close from the list.
Top
Page SetUp  
Sets margins, paper source, paper size, page orientation, and other layout options for the active file.
  1. Click on File menu.
  2. Click on Page Setup.
  3. The Page tab contains options for Orientation, scaling, paper size and print quality.
  4. Select the paper size from the combo box.
  5. In the Margin tab you can set the top, bottom, left, right, header and footer margin.
  6. On the Header/Footer tab you can create header and footer.
  7. On the Sheet tab you can set the print area, and print options.
  8. To select the print area click on the Red Arrow right to the Print area field.
  9. Select the cells to print.
  10. Click on the Red Arrow again.
  11. Click on OK
Top
Print Preview  
Shows how a file will look when you print it.
  1. Click on File menu.
  2. Click on Print Preview.
  3. You will see the print preview of the sheet.
  4. Click Close button to exit.
Top
Print  
Prints the active file or selected items.
  1. Click on File menu.
  2. Click on Print.
  3. Print dialog will appear.
  4. Select the print range.
  5. Enter number of copies to print.
  6. Click on OK.
Top
Exit  
Closes the program after prompting you to save any unsaved files.
  1. Click on File menu.
  2. Click on Exit.
  3. If the the active file is unsaved then a prompt for saving will appear.
  4. If you want to save, click on "Yes" otherwise click on "No".
Top
Cut  
Removes the selection from the active document and places it on the Clipboard.
  1. Select the Cell or Cells that is to be cut
  2. Click on Edit menu.
  3. Select cut.
  4. The selection will be cut.
Top
Copy  
Copies the selection to the clipboard so that into paste to another cell.
  1. Select the Cell or Cells that are to be copied.
  2. Click on Edit menu.
  3. Select copy.
  4. The selection will be copied to the clipboard.
Top
Paste  
Inserts the contents of the Clipboard at the insertion point, and replace any selection. This command is available only if you have cut or copied an object, text, or contents of a cell.
  1. Cut or Copy cell or cells from the Spreadsheet
  2. Select the Cell to be paste
  3. Click on Edit menu.
  4. Click on Paste.
  5. The content of the clipboard will be pasted to the selected cell.
Top
Fill  
Fills a series of data.
  1. Click on Edit menu.
  2. Select Fill from the list.
  3. Click on the command you need.

    • Down :-Copies the contents and formats of the topmost cells of a selected range into the cells below. To fill a selected range up instead of down, hold down SHIFT and click this command.

    • Right :-Copies the contents and formats of the leftmost cell or cells of a selected range into the cells to the right. To fill the selection to the left instead of the right, hold down SHIFT and click this command.

    • Series:-Fills the selected range of cells with one or more series of numbers or dates. The content of the first cell or cells in each row or column of the selection is used as the starting values for the series.

    • Justify:-Redistributes the text contents of the cell to fill the selected range. Numbers or formulas cannot be filled and justified. Except for the first column, cell in the range should be blank.
Top
Clear  
Removes the cell contents and formatting, comments, hyperlinks from selected cells depending on the option selected.
  1. Click on Edit menu.
  2. Select Clear from the list.
  3. From the submenu select an option.

    • All :-Removes all cell contents and formatting, including comments and hyperlinks from selected cells.

    • Content :-Removes the cell contents (data and formulas) from selected cells without affecting cell formats or comments.

    • Format :-Removes only the cell formats from selected cells; cell contents and comments are unchanged.

    • Comments:-Removes only the comments attached to selected cells; cell contents and formats are unchanged.
Top
Delete  
Removes the selected objects.
  1. Select the Cells or object to Delete.
  2. Click on Edit menu.
  3. Click on Delete from the list.
  4. Delete dialog box will appear.
  5. Select the option you want.

    • Shift cells left :-Delete the selected cell and the rest of the cells will be shifted left.

    • Shift cells up :-Delete the selected cell and the rest of the cells will be shifted up

    • Entire Row :-Delete the Row containing the selected cells.

    • Entire Column :-Delete the Columns containing selected cells.

  6. Click on OK.
Top
Delete Sheet  
Deletes the selected sheets from the workbook. You cannot undo this command.
  1. Open the Spreadsheet to delete.
  2. Click on Edit menu
  3. Click on Delete Sheet
  4. A Microsoft Excel warning message will be displayed.
  5. Click on OK in the Microsoft Excel warning.
Top
Move or Copy Sheet  
Moves or copies the selected sheets to another workbook or to a different location within the same workbook.
  1. Click on Edit menu
  2. Click on Move or Copy Sheet from the list.
  3. Move or Copy Dialog will appear.
  4. If you want to create a copy of existing sheet, check the Create a Copy.
  5. In the before sheet field, select the new position of the current sheet
  6. Click on Ok
Top
Find  
Searches selected cells or sheets for the characters you specify, and selects the first cell that contains those characters.
  1. Click on Edit menu.
  2. Click on Find.
  3. Find Dialog will appear.
  4. Type the value that is to be found.
  5. Select Values in the Look in field.
  6. Click on Find Next Button.
  7. The Value containing the cell will be selected in the Spreadsheet if found.
Top
Replace  
Searches for and replaces the specified text and formatting.
  1. Click on Edit menu.
  2. Click on Replace.
  3. Replace Dialog will appear.
  4. Type the text that is to be found.
  5. Click on Find Next button.
  6. The text will be selected if found.
  7. Now type the text to be replaced with.
  8. Click on Replace button.
  9. The text will be replaced with the new word.
  10. Click on Close Button to close the dialog box.
Top
Toolbar  
Displays or hides toolbars.
  1. Click on View menu.
  2. Select Toolbars from the list.
  3. From the Sub Menus Check the toolbars you needed and Uncheck the Toolbars that you don’t needed.
  4. If new toolbar is selected it will present in the screen.
  5. You can drag it to the toolbar area.
Top
Formula Bar  
Displays or hides the formula bar.
  1. To display the Formula Bar

    • Click on View menu.
    • Click on the check box near the Formula Bar.

  2. To Hide the Formula Bar

    • Click on View menu.
    • Click on the uncheck box near the Formula Bar.
Top
Status Bar  
Displays or hides the Status Bar.
  1. To display the Status Bar

    • 1. Click on View menu.
    • 2. Click on the check box near the Status Bar.

  2. To hide the Status Bar

    • 1. Click on View menu.
    • 2. Click on the uncheck box near the Status Bar.
Top
Header & Footer  
Adds or changes the text that appears at the top and bottom of every page.
  1. Click on View menu.
  2. Click on Header and Footer.
  3. Page Setup Dialog will appear.
  4. On Header/Footer Tab in the Dialog, click on Custom Header…
  5. Header Dialog will appear.
  6. Type the Left, Center, Right sections as you needed
  7. Click on OK
  8. You can see the print preview by clicking on Print Preview on the Page Setup Dialog
  9. Click on Custom Footer button.
  10. The Footer dialog will appear.
  11. You can add left, center, right footers.
  12. If you want to add page no, date, time etc click on the appropriate button on the dialog.
  13. Click on OK.
  14. If you want to view the print preview, click on Print Preview button.
  15. To close Print Preview, Click on the Close button.
Top
Full Screen  
Hides most of the screen elements so that you can view more of your document.
  1. Click on View menu.
  2. Click on Full Screen.
  3. To Close Full Screen, Click on Close Full Screen on the Full Screen dialog.
Top
Zoom  
Controls how large or small the current file appears on the screen.
  1. Click on View menu.
  2. Click on Zoom.
  3. Zoom dialog will appear.
  4. Select the percentage of zooming..
  5. Click on OK.
Top
Cells  
Inserts cells starting at the insertion point. You can choose to shift other cells in the table to the right or down.
  1. Select the cell where you have to add a new cell; the cell may or may not contain values.
  2. Click on Insert menu.
  3. Click on Cells from the list.
  4. Insert dialog will appear.
  5. Select the appropriate option.
  6. Click on OK.
Top
Rows  
Inserts a new Row.
  1. Select the cell where you want to insert a new Row.
  2. Click on Insert menu.
  3. Click on Rows from the list.
  4. A new Row will be appeared in the position.
Top
Columns  
Inserts a new Column.
  1. Select the cell where you want to insert a new Column.
  2. Click on Insert menu.
  3. Click on Column from the list.
  4. A new Column will be appeared in the position.
Top
Worksheet  
Inserts a new Worksheet to the left of the selected sheet.
  1. Click on Insert menu.
  2. Click on Worksheet from the list.
  3. A new Worksheet will be added.
Top
Chart  
Starts the Chart Wizard, which guides you through the steps for creating an embedded chart on a worksheet or modifying an existing chart.
  1. Firstly select the fields which is to be included in the chart.
  2. Click on Insert menu.
  3. Click on Chart from the list.
  4. The Chart Wizard will appear.
  5. The chart wizard has four steps to follow.

    1. On the first step select the Chart type from the list.
    2. Select the Chart sub-type from the right side
    3. Click on Next to enter into the second step

    4. On the second step select the Series in option. The default is Column.
    5. Click on Next to enter into the third step

    6. On the third step
    7. Enter the Chart title.
    8. Enter X-axis label.
    9. Enter Y-axis label.
    10. Click on Next to enter into the forth step

    11. On the forth step you have to select the location of the chart.
    12. Click on Finish to finish the chart.

  6. The chart will be displayed on the sheet.
Top
Function  
Inserts Function in a Spreadsheet
  1. Select a Cell where you want to see the result.
  2. Click on Insert menu.
  3. Click on Function from the list.
  4. Paste Function Dialog will appear.
  5. From the Function Category select Math & Trig.
  6. From the Function name select SUM.
  7. Click on OK
  8. A new dialog will appear
  9. Click on the red arrow of the Number1 field
  10. The dialog will be reduced so that to select the values.
  11. Select the cells to which you have to find the sum.
  12. Click on the red arrow on the reduced dialog.
  13. Click on OK
  14. The Sum will be placed on the cell.
Top
Comment  
Inserts a comment at the insertion point.
  1. Click on the cell where you want to place a comment.
  2. Click on Insert menu.
  3. Click on Comment.
  4. A small Editor window will appear.
  5. Type your comment in the Editor window.
  6. To hide the comment, click on View menu.
  7. Click on Comments from the list.
  8. To display the comment, click on View Menu
  9. Click on Comment from the list.
Top
Picture from ClipArt  
Opens the Clip Gallery where you can select the clip art image you want to insert in your file or update your clip art collection.
  1. Click on a cell where you want to place the picture.
  2. Click on Insert menu.
  3. Select Picture from the list.
  4. Click on ClipArt.
  5. Insert Clipart dialog will appear with many ClipArt categories.
  6. Click on a category to view the pictures.
  7. Click on the picture that you want to insert.
  8. From the menu click on Insert Clip icon.
  9. The ClipArt image will be inserted into the spreadsheet.
  10. You can scale the image by Clicking, holding and dragging the sides.
  11. You can move the image by Clicking, holding and dragging it.
Top
Picture from file  
Inserts an existing picture in the active file at the insertion point.
  1. Select a cell where you want to place the picture.
  2. Click on Insert menu.
  3. Select Picture from the list.
  4. Click on From FilE from the Sub Menu.
  5. Insert Picture Dialog will appear.
  6. Click the down arrow of the Look in combo box.
  7. Click on the drive letter where the picture file is available.
  8. Select the folder containing the picture file.
  9. Click on Open to open the folder.
  10. Select the picture.
  11. Click on Insert.
  12. The Picture will be inserted to the spreadsheet.
Top
Picture from WordArt  
Creates text effects by inserting a Microsoft Office drawing object.
  1. Click on a cell where you want to place the WordArt image.
  2. Click on Insert menu.
  3. From the list select Picture.
  4. From the sub menu click on WordArt.
  5. WordArt Gallery will appear.
  6. From the Gallery select a WordArt Style and click on OK.
  7. Edit WordArt Text dialog will appear.
  8. Type your text.
  9. Select the Font and Size.
  10. Click on OK.
  11. WordArt will be inserted.
  12. You can scale the WordArt image by Clicking, holding and dragging the sides.
  13. You can move the WordArt image by Clicking, holding and dragging it.
Top
Hyperlink  
Inserts a new Hyperlink or edits the selected hyperlink.
  1. Select the cell where you want to place the Hyperlink.
  2. Click on Insert menu.
  3. Click on Hyperlink from the list.
  4. Insert Hyperlink dialog will appear.
  5. Type a Text which is displayed as the Hyperlink.
  6. Type the webpage address.
  7. Click on OK.
  8. The hyperlink will be placed on the cell.
  9. If you have an internet connection you can view the webpage by clicking on the Hyperlink.
Top
Cells  
Applies formats to the selected cells. This command might not available if the sheet is protected.
  1. Click on the cell you want to format.
  2. Click on Format menu.
  3. Click on Cells.
  4. Format Cells dialog will appear.
  5. On the Number tab, select Text.
  6. Click on Alignment tab.
  7. Select the alignment from the combo box.
  8. Click on the required Text Control options.
  9. Change the orientation by clicking and dragging the red dot or enter the angle in degrees directly below.
  10. Click on Font tab.
  11. Select the font from the list.
  12. Select the Font Style.
  13. Select the Font size.
  14. Select the Color.
  15. Select necessary effects by clicking on the box near to corresponding effect
  16. Click on Border Tab.
  17. On border tab select the required Presets, Line Style, Border and Color.
  18. Click on OK.
  19. The cell will be formatted.
Top
Row AutoFit  
Adjusts the row height to the minimum necessary to display the height of the tallest cell in the selection. If you change the cell contents later, you must fit the selection again. This command is not available in protected sheets.
  1. Select the Cell by clicking on it.
  2. Click on Format menu.
  3. Select Row from the list.
  4. Click on AutoFit from the submenu.
  5. The Row will be Autofit to the contents.
Top
Row Height  
Changes the height of the selected Rows. This command is not available in protected sheets.
  1. Select the Cell by clicking on it.
  2. Click on Format menu.
  3. Select Row form the list.
  4. Click on Height from the submenu.
  5. Row Height dialog will appear.
  6. Enter the Height in the dialog.
  7. Click on OK.
Top
Row Hide  
Hides the selected Rows. Hiding the row does not delete them from the worksheet.
  1. Select the Row by clicking on the row number.
  2. Click on Format menu.
  3. Select Row from the list.
  4. Click on Hide from the submenu.
  5. The Row will be hidden.
Top
Row Unhide  
Displays Rows in the current selection that was previously hidden.
  1. Click on Format menu.
  2. Select Row from the list.
  3. Click on Unhide from the submenu.
  4. All hidden Rows will be shown.
Top
Column AutoFit  
Adjusts the column width to the minimum necessary to display the contents of the selected cells. This command might not be available in protected sheets.
  1. Select the column or cell.
  2. Click on Format menu.
  3. Select Column from the list.
  4. Click on AutoFit Selection from the submenu.
  5. The column will Autofit to the content
Top
Column Hide  
Hides the selected columns. Hiding a column does not delete them from the worksheet.
  1. Select a cell in the column to hide.
  2. Click on Format menu.
  3. Select Column from the list.
  4. Click on Hide from the submenu.
  5. The Column will be hidden.
Top
Column Standard Width  
Changes the standard width of columns on a worksheet. This command is not available in protected sheets.
  1. Click on Format menu.
  2. Select Column form the list.
  3. Click on Standard Width from the submenu.
  4. Standard Width dialog will appear.
  5. Enter the width in the dialog.
  6. Click on OK.
Top
Column Width  
Changes the width of the selected columns. This command is not available in protected sheets.
  1. Select the cell that you want to change the width.
  2. Click on Format menu.
  3. Select Column form the list.
  4. Click on Width from the submenu.
  5. Column Width dialog will appear.
  6. Enter the width in the dialog.
  7. Click on OK.
Top
Sheet Background  
Inserts a tiles graphic image in the worksheet background, based on the bitmap you select.
  1. Click on Format menu.
  2. Select Sheet from the list.
  3. Click on Background from the submenu.
  4. Sheet Background dialog will appear.
  5. Click on the down arrow of the Look in combo box.
  6. Click on the drive letter that contains the picture.
  7. Select the folder and click on open button.
  8. Select the Image.
  9. Click on Insert.
Top
Sheet Hide  
Hides the active sheet. The sheet remains open and accessible to other sheets, but it is not visible.
  1. Select the Sheet that you want to hide.
  2. Click on Format menu.
  3. Select Sheet from the list.
  4. Click on Hide from the Sub menu.
  5. The sheet will be hidden.
Top
Sheet Rename  
Renames the active sheet.
  1. Select the sheet that you want to rename.
  2. Click on Format menu.
  3. elect Sheet from the list.
  4. Click on Rename from the sub menu.
  5. The sheet name will be shown as “selected” to rename.
  6. Just type the new name for the sheet.
  7. Press Enter key on the keyboard.
Top
Sheet Unhide  
Displays the previously hidden sheet. The command is active only if any sheet is hidden.
  1. Click on Format menu.
  2. Select Sheet from the List.
  3. Click on Unhide from the sub menu.
  4. Unhide dialog will appear.
  5. Select the Sheets that you want to show.
  6. Click on OK.
  7. The Sheets will be shown.
Top
Autoformat  
Applies a built-in combination of formats, called an AutoFormat, to a cell range or PivotTable report. If a single cell is selected, Excel automatically selects the range surrounded by blank cells and applies the AutoFormat to that range. This command is not available in protected sheets.
  1. Select the range of cells where you want to apply AutoFormat.
  2. Click on Format menu.
  3. Click on AutoFormat from the menu items.
  4. AutoFormat dialog will appear.
  5. From the given set of formats, select the format you like.
  6. Click on OK.
Top
Conditional Format  
Applies formats to selected cells that meet specific criteria based on values or formulas you specify.
  1. Select the Cells that you want to format
  2. Click on Format menu.
  3. Click on Conditional Formatting from the list.
  4. Conditional Formatting dialog will appear.
  5. Select the conditions from the list.
  6. Enter Criteria value.
  7. Click on Format button to format.
  8. Select the Formatting Options from the Format Cells dialog.
  9. Click on OK.
  10. Click on OK in the Conditional Formatting dialog.
  11. The selected cells will be conditionally formatted.
Top
Style  
Defines or applies to the selection a combination of formats, called styles.
  1. Click on Format menu.
  2. Click on Style from menu items.
  3. Style dialog will appear with the default style choices.
  4. To modify the style click on Modify.
  5. Format cell dialog will appear.
  6. Modify the style using Number, Alignment, Font, Border, Patterns and Protection tabs.
  7. Apply the formats you needed.
  8. Click on OK.
Top
Spelling  
Checks spelling in the active document, file, workbook, or item.
  1. Click on Tools menu.
  2. Click on Spelling.
  3. If any error detected then Spelling dialog will appear.
  4. You can change or ignore the error.
  5. To exit the dialog box click on the Cancel Button.
Top
Protect Sheet  
Prevents changes to cells on worksheet, items in a chart, graphic objects on a worksheet or chart sheet, or code in visual basic editor form.
  1. Click on Tools menu.
  2. Select Protection from the list.
  3. Click on Protect Sheet from the sub menu.
  4. Protect Sheet dialog will appear.
  5. Select the options that you want.
  6. If you want password protection then type a password.
  7. Click on OK
  8. Re-Enter the password.
  9. Click on OK.
  10. Then if you try to edit the sheet a message will appear.
  11. To unprotect the sheet, Click on Tools menu.
  12. Point to Protection
  13. Click on Unprotect Sheet
  14. You will be prompted for the password.
  15. Enter the password.
  16. Click on OK.
Top
Protect Workbook  
Protects a workbook’s structure and windows. You can prevent the changes to the structure of a workbook so that sheets can’t be deleted, moved, hidden, unhidden, or renamed, and new sheets cannot be inserted. You can also protect windows from being moved or resized. When the active document is protected, the command name changes to Unprotect Workbook.
  1. Click on Tools menu.
  2. Select Protection from the list.
  3. Click on Protect Workbook from sub menu.
  4. Select protection options.
  5. If you want password protection then type a password.
  6. Click on OK.
  7. Conform password dialog will appear.
  8. Re-Enter the password.
  9. Click on OK, the workbook will be protected.
  10. To check the protection, click on Format menu.
  11. Point to Sheet.
  12. The commands will be disabled, so that you cannot alter the sheet’s structure.
Top
Scenarios  
Creates and saves scenarios, which is a facility wherein more than one data will be accepted in each single cell.
  1. Click on Tools menu.
  2. Click on Scenario from the list.
  3. Scenario Manager will appear.
  4. Click on Add button.
  5. Add Scenario dialog will appear.
  6. Enter Scenario name.
  7. Click on the red arrow.
  8. The dialog will be reduced.
  9. Select the cell where you want add the scenario.
  10. Again click on the red arrow on the reduced dialog.
  11. Click on OK.
  12. Scenario Values dialog will appear.
  13. Enter the alternate value for the cell.
  14. Click on OK.
  15. To show a Scenario, click on Show button in Scenario Manager.
Top
Customize  
Customizes toolbar buttons, menu commands, and shortcut key assignments.
  1. Click on Tools menu.
  2. Click on Customize.
  3. Customize dialog will appear, which contains three tabs, Toolbar, Commands, Options.
  4. The Toolbar tab, lists the available toolbars. To display a toolbar, select the check box next to the name. To hide a toolbar, clear the check box.
  5. The Commands tab displays a list of commands fro