Advertize

Sunday, 8 January 2017

Review and View menu of excel

http://learnwindowsandoffice.blogspot.com/
Review Menu:-

Spelling and Grammar:-                To check the spelling and grammar of typed text if mistakes than correct it.
Research:-                           To research about any topic from dictionary or other source.
Thesaurus:-                        Suggest other words with similar meanings.
Translate:-                          To Translate typed text with an other language.
New Comment:-               Insert the comment(Detail) in the document at any place.
Delete:-                                                Remove the given comment.
Next:-                                   To jump on next comment.
Previous:-                            To jump on the next given comment.
Protect sheet:-                  To set code on the sheet.
Protect share work book:- To set code on the shared work book.
Allow users to edit ranges:- To permit the users to change in particular areas in the sheet if you are on the network of the computers.
Track Changes:-               To high light changes made in the sheet after saving first one.

View menu:-

Normal:-                              To show normal view of the sheet pages.
Page layout:-                     To show print page layout of the sheet pages.
Page break:-                      To show the pages braked sheet pages.
Costume view:-                 To user defined view.
Full screen show:-            Show sheet on full screen.
Ruler:-                                   Show the scale bar on the sheet page.
Gird lines:-                          Show the cell lines in the sheet.
Formula bar:-                    Show or hide the for formula bar.
Headings:-                          Show or hide the column names and row numbers from the active sheet.
Zoom:-                                 Show small or big sized cells.
Zoom to selection:-       Show sheet longer as the selection.
New window:-                  To set active work book in  new window.
Arrange all:-                       Show all opened work book on screen.
Freeze pane:-                     To freeze left side column or top row or any selection to watch large data headings.
Split:-                                    To decide screen in parts.
Hide:-                                    To hide the active work book.
Un hide:-                             Display hidden work book.
View side by side:-           Display opened work book side by side.
Synchronous scrolling:- Scroll two documents at same time with one scrolling bar.
Save work Space:-           To store only typed worksheet cell not full work book for saving the memory space.
Switch to Window:-        To jump on an other opened work book.

Marcos:-                              to record set of commands in one macro.

No comments:

Post a Comment