Excel-2003 Tutorial 3 - Smart Computer Tutorial
HOW TO SAVE ANY FILE IN
TXT(TAB DELIMITED) FORMAT?
STEPS:-
1. Design the matter.
2. Select “File->save” option.
3. Select the location such as “Desktop”.
4. Feed the “file name” such as “my file”.
5. Select the “Txt(Tab Delimited)” under “File type”.
6. Click on “Save” button.
How to save any file as
web page /single file web page format?
Steps:-
1. Design the matter.
2. Select “File->save” option.
3. Select the location such as “desktop”.
(ads)
4. Feed the file name such as “my file”
5. Select the type such as “single web page/web page”
from “Save as type”.
6. Click on “Change title” button.
7. Feed the title for the web page file.
8. Click on “ok” button.
9. Click on “Save” button.
10.
Click on “ok”
button.
11.
Click on “yes”
button.
Note :- Now if you open this
file it will open within browse that is installed on your computer.
File->Save as:-
This option is used to save
the active saved file at any location with another name. Actually it is used to
create a copy of the active file.
Steps:-
1. Design the matter.
2. Select “File->Save As” option.
3. Select the location.
4. Feed the “file name”
5. Click on “save” button.
Save as web page:- This option is used to save the active book as web
page. A web page is a special page that is visible on any web browser such as
internet explorer.
Steps:-
1. Design the matter.
2. Select “File->save as web page” option.
3. Select the location such as “Desktop”.
4. Feed the “file name” such as “second web page”.
5. Click on “Change title” button.
6. Feed the “title of the web page”.
7. Click on “ok” button.
8. Click on “Save” button.
File->Save work
space:- This option is used to save more than one
files/books into the active file with the given name at the selected location.
(ads)
Steps:-
1. Design the matter.
2. Click on “File->save or save as” option.
3. Feed the file name.
4. Click on “save button.
5. Press “Ctrl+n” to open new file.
6. Repeat the steps from “1 to 5” .
7. Click on “file->save work space” option.
8. Select the location such as “Desktop”.
9. Feed the file name such as “my work space”.
10.
Click on ”Save”
button.
Note:- Now if you open the
saved workspace file it will open all file within it.
File->Web page Preview:- This option is used to preview the save file in web page. You will have to save the file in web page before using this option.
Steps:-
1. Open New File.
2. Save the file by using web page option.
3. Click on file->menu.
4. Select “Web page preview” option.
Note:- it will open the selected file in a browser as internet explorer.
FILE->PRINT PREVIEW:- This option is used to show the preview of the active document before printing the page and after that you can adjust your printing document.
Steps:-
1. Design the matter.
2. Select “File->Print preview” option.
Print area->set print area
This option is used to set the printing area of the selected data range which you want to print.
Steps:-
1. Design the matter.
2. Select the Data which you want to print.
3. Click on “File menu”
4. Select “Print Area->Set Print area”.
Print area->Clear Print Area:- This option is used to clear the print area that is already set.
(ads)
1. Click on “File menu”.
2. Select Print Area->Clear print area”
Page Setup:- This option is used to apply the page property on the active sheet or selected range of cells of active sheet of active work book. Such as Gridline, Page border, page in center, insert header and footer.
How to activate the Grid lines in Printing?
Steps:-
1. Design the matter.
2. Select “file->Page setup” option.
3. Click on “Sheet tab”
4. Check the checkbox of “Grid lines”.
5. Click on “ok” button.
Now if you see the print preview it will show the gridline also.
How to fit the page in center during printing?
Steps:-
1. Design the matter.
2. Select File->Page setup” option.
3. Click on “Margins” Tab.
4. Check the checkbox of “Horizontally” and “Vertically” in Center to page section.
5. Click on “ok” button.
Now if you see the print preview of the active page it will shows the content in the center of the page.
How to change the page border?
1. Click on “File menu”.
2. Select “Page setup” option.
3. Click on “Sheet” tab.
4. Select the Radio button of the following:-
a. Over the down.
b. Down the over.
5. Click on “ok” button.
