Ticker

6/recent/ticker-posts

Advertisement

How to Preview an Excel Worksheet Saved As a Web Page | Smart Computer Tutorial

 

How to Preview an Excel Worksheet Saved As a Web Page | Smart Computer Tutorial

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 and design the matter like below:

2.          Save the file by using web page option.

Follow the steps like the image shown below:


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.

  

Now it will shows the preview like below:


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.

 

1.          Click on “File menu”.



 (ads)

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 as above.

5.          Click on “ok” button as above.


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.


Post a Comment

0 Comments