Excel-2003 Tutorial 7 - Smart Computer Tutorial
View menu
Page Break Preview:- This option is used to show the page break preview with blue dotted line that helps you to adjust the no of rows and columns in a page.
Steps:-
1. Design the matter more than one page.
2. Click on “View menu”.
3. Select “Page break Preview” option.
4. Adjust the blue dotted line as per your need.
Normal:-This option is used to swith to the normal view that is useful for the normal working.
Steps:-
1. Click on View menu.
(ads)
2. Select normal option.
Task Pane:- This option is used to show or hide the task pane.
Steps:-
1. Click on “view” menu.
2. Select “Taskpane” option.
Toolbars:- This option is used to show or hide the tool bars from the active window.
Steps:-
1. Click on “View” menu.
2. Select “Toolbars” option.
3. Click on any toolbar to show or hide the toolbars.
Formula bar: - This option is used to show or hide the formula bar.
Steps:-
1. Click onView menu.
2. Select “Formula bar” option.
Status bar :- This option is used to show or hide the status bar.
Steps:-
1. Click onView menu.
2. Select “Status bar” option.
Comments: This option is used to show or hide the inserted comment in the active sheet.
Steps;-
1. Click on “View” menu.
2. Select “Comments” option.
Full Screen:- This option is used to view the active window in the full screen.
Steps:-
1. Click on “View” menu.
(ads)
2. Select “Full screen” option.
Note :- Click on “Close full screen” to close the full screen.
Zoom:- This option is used to Zoom the active window at the desired selected zoom percent.
Steps:-
1. Click on “View” menu.
2. Select Zoom option.
3. Select any ration button of percentage.
4. Click on ok button.
Header and footer:- This option is used to insert the header and footer in the active sheet where header is inserted at the top of the page while footer is inserted at the bottom of the page.
Steps:-
1. Design the matter.
2. Click on “View” menu.
3. Select “header and footer” option.
4. Click on “Custom header” option.
5. Insert the text for header in the given section for left , right, and center.
6. Click on “ok” button.
7. Click on “Custom” footer button.
8. Insert the footer text for left, center and right.
9. Click on “ok” button.
10. Click on “ok” button.
Second Way:-
1. Click on “file” menu.
2. Select “Page setup” option.
(ads)
3. Click on “Header/footer” tab.
4. Follow the process for inserting the header and footer text like above steps.
5. Click on “ok” button.
How to see the inserted header and footer text?
Steps:-
1. Click on “file” menu.
2. Select “Print Preview” option.
Here you can see the inserted header and footer text.
Custom views:- This option is used to highlight the selected data or range of cells.
Steps:-
1. Design the data.
2. Select the range of cells.
3. Click on “View” menu.
4. Select “Custom views” option.
5. Click on “Add” button.
6. Feed the name of the view.
7. Click on “ok” button.
How to show the custom view?
1. Click on “View” menu.
2. Select “Custom views” option.
3. Select the added name.
4. Click on “Show” button.
How to delete the added custom views?
Steps :-
1. Click on “view menu”.
2. Select “custom views” option.
3. Select the added name which you want to delete.
4. Click on “Delete” button.
5. Click on “yes” button.
6. Click on “Close” button.
