File Menu
TO CRATE A NEW WORKBOOK.
Þ Click on file menu
Þ Click on new
Þ The a dialog box will appears
Þ To create a new, blank workbook, click a General tab.
Þ Choose Workbook icon
Þ Click on OK button.
TO SAVE A WORKBOOK.
Click on File menu.
Þ Click on Save command
Þ In the Save in list, select the drive and folder where you want to save the workbook.
Þ [If you want to save the workbook in a new folder, click on Create New folder]
Þ In the File name box, type a name fir the workbook.
TO CLOSE A WORKBOOK.
Þ Click on File menu.
Þ Click on Close command.
[To close all open workbooks without exiting the program, hold down SHIFT and click close all on the File menu.]
TO SAVE A COPY OF WORKBOOK.
Þ Open the workbook you want to make a copy of.
Þ Click on file menu.
Þ Click on Save as.
Þ In the File name box, type a new name of the workbook
Þ Click Save.
TO OPEN A WORKBOOK.
Þ Click on file menu.
Þ Click on open command.
Þ In the Look in list, click the drive, folder or location that contains the workbook you want to open and then locate a double-click the folder the contains the workbook.
Þ Select the required workbook name.
Þ Click on Open.
Þ Double click the workbook you want to open.
TO PROTECT WORKBOOK BY PASSWORD
Þ First open the workbook.
Þ Click on File menu.
Þ Click on Save as command.
Þ Then a dialog box will appear.
Þ Click on Tools of dialog box and click on General option.
Þ Type the password in Password to open box.
Þ Click on ok bottom.
Þ Then a confirm password box will appear.
Þ Type the same password Modify again.
Þ Click on ok button.
Þ Click on save button.
USING PAGE SETUP COMMAND.
This command is used to set margins, paper source, paper size, page orientation, and other layout options for the active file.
Þ First open the workbook of which you want to set page.
Þ Click on File menu.
Þ Click on Page Setup command.
Þ Then a dialog box will appear.
Þ Click on page tab.
Þ Choose the required orientation. (Portrait or landscape)
Þ Choose any paper size.
Þ Click on margin tab.
Þ Set the required margin for Top, Bottom, and Left, Right, Header& footer.
Þ Choose other required options.
Þ Click on OK button.
TO SEE THE PRINT PREVIEW OF WORKSHEET.
Þ Click on file menu.
Þ Click on Print Preview command.
Þ Now you can see the preview of your worksheet.
Þ Click on Next button to see the next page of sheet.
Þ Click on Previous button to see the previous page.
Þ Click on zoom button to reduce or enlarge the page size.
Þ Click on setup button to open the setup dialog box.
Þ Click on Margins tab to set the margin.
Þ Click on close button to close the preview.
TO SET PRINT AREA.
Þ Select the required part of sheet which you want to set as print area.
Þ Click on file menu.
Þ Click on Print area command.
Þ Choose Set print area.
[To clear print area click on File menu, choose print area and click on clear print area.]
TO PRINT A WORKSHEET.
Þ Open the worksheet which you want to print.
Þ Click on File menu.
Þ Click on Print command
Þ Then a dialog box will appear.
Þ Choose the print name from Name box.
Þ Choose any option from Print range criteria. [All, Page].
Þ Choose any option from Print what criteria. [Selection, entire workbook etc.]
Þ Choose the required number of copies to print.
Þ Click on other required options and Click on OK button.