View Tab MS Excel Full Information

View Tab MS Excel

All the options present in this menu are related to the page. That is to change the mode of the page, bringing the toolbar to the page as you wish. View Tab MS Excel.

Note- down at the top of the page. Spread your page all over the screen etc.  

View Tab MS Excel

Workbook View

Normal: – By running this option, you can only write on the page. Cannot create object etc. And if the object is already create. Then it will not be visible.

Page Layout: – By running this option, the page will look the same as the print.

Page Break Preview: – By turning on this option, the size in which the print usually comes out.  

The same size will be display along with the page number by dividing the sheet into different pages.

Custom View: – With the help of this option, you can view a particular page. To do this, first you have to give a name by placing cursor on all those pages.  

Full Screen: – Through this option, you can spread your page across the screen.

Show / Hide Ruler: – This option is use to fetch and remove ruler.

Gridlines: – This can bring grid lines to your page.

Message Bar: – Message Bar can be opene to complete any Required Action on a Document.

Formula Bar: – By clicking on this option, we bring and remove the formula bar.

Headings: – With this option you can show and hide the row and column headings.

Read Now PowerPoint Information

Zoom

Zoom: – Through this option, you can make your page much smaller. Zoomed  

If you want to bring the page in normal form, then click on 100%, your page will become normal.

Zoom to Selection: – By selecting this option, you can do as much as you want to zoom by selecting your page.

Window

There are all the options under this. They are all related to windows. The screen of MS Word is call the window.

New Window: – Use it to open more than one window.

Arrange All: – To minimize multiple open windows. Let’s do this option.  

Freeze Pane: – The cell that is select will have a thin line around it.

Split: – Use it to split open windows.  

Hide: – With this option, you can hide the open workbook.  

Unhide: – With the help of this option, you can show the hidden workbook.  

View Side by Side: – View two documents side by side so that you can compare their contents.  

Synochronous Scrolling: – Synchronize the scrolling of two documents so that they scroll simultaneously. To enable this feature, turn on the side view.  

Rest Window Position: – Reset the window position of the documents side-by-side so that they move the screen evenly.  

Save Workspace: – With the help of this option, you can save more than one open file under another name. So that whenever you click on this name, all the files you have saved with this name. Open together.  

Advantage: – Its advantage is that you are working in this file and sometimes in that file by opening multiple files at once. That suddenly there was a need to shut down the computer. Now when we open the computer again, it is not remembere which files were open.  

So to avoid this problem, open all the files in which you have to work initially and save all the files by any name with the help of save workspace option. Now whenever you click on this name with the help of open option, all those files will be opened.

Switch Windows: – This closes the window of Current Document.  

Macro

You can record your article by this. So that when he wants to bring it. Can bring.

On clicking this option, a strip will open which has the following options.  

1- Macros

On clicking this, the dialog box will open. Where in the box named Macro, type the name of the recorded macro, then click on the Run option button. On clicking, the recorded thing will appear in the page.   

2- Record New Macro

On clicking this, the dialog box will open. In the box where the macro name is the name with which to record the macro. Write that name and do ok. A square tool will appear in the page. And the cursor will come in the form of cassette. Whatever you write will be recorde in the given macro name. Now, to stop recording, click on the stop recording button inside the square tool present on the page. Recording will stop as soon as clicked.   

To get the recorde one, by click on the macros option, By which name the macro is record. Select it and click on run. The recorded article will come where the cursor is.  

Note – The dialog box that comes from clicking Record New Macro has two options.  

(1) Toolbars

Can bring macros recorded by it as toolbars. So that whenever there is a need to fetch the recorded macro. Click on this toolbar to bring the recorded item to the page.    

Clicking on it will open the dialog box where clicking on toolbars and clicking on new. The second dialog box will open. In which, by typing any name in the box named Toolbar, do OK, the toolbar will be created with this name. Now pick up the normal new macro in the box of the command by placing it in the toolbar we created. And close the dialog box. Now whenever you click on this toolbar, the recorded text will appear in the page.  

(2) Keyboard

It can set text recorded in any button.  

Way – Clicking on it will open the dialog box. In which, press the cursor in the box of press new short cut and press any letter with Ctrl. Then click on Assign and click Close. A toolbar named Stop will appear on the page. Now whatever you write will be record. When the record needs to be close click on Stop Record. Now whenever you press the shortcut, the recorded text will appear in the page. View Tab MS Excel.

Related posts

Leave a Comment