You can check the meaning of Word written on the page under Tools Menu MS Excel 2003. And can do online collaboration etc. And can apply protection to the sheet.
Spelling – Tools Menu MS Excel 2003
Tools Menu MS Excel 2003 By this you can check the spelling and grammar of the article. On clicking on it the following dialog box will open.
Not in Dictionary: In this box, the word will appear which is not in the dictionary of the computer. Now either the spelling of this word is wrong. Or is it a word from some other language? That is, a wrong spelling word will appear in this box.
Change to: That word will appear in this box. The word is to be replace with the word above.
Research – Tools Menu MS Excel 2003
This option is use to get complete information about the word or sentence. If this option does not work in Tools Menu MS Excel 2003 then you connect your computer to the Internet. And then you will be able to use the research option easily.
Speech – Tools Menu MS Excel
To listen to the paragraph aloud, use this option in Tools Menu MS Excel 2003. And to do formatting in paragraphs through voice itself. By clicking on it, the language bar will appear in the top right corner of the screen.
Correction This option is use to correct the incorrect spell of the word by speaking it. Microphones use this to do formatting through voice in a paragraph. You cannot use the microphone on the computer without this option turned on. Dictation will convert what we are speaking into text after turning it on.
Note- To use it, it is necessary that both the keyboard layout and the language of speech are the same. Voice Command menu to do formatting in text. To open the tool bar, dialog box and task pane etc. by speaking. So that you can use the options present in it by speaking.
Method- After turning on this option to select the text, give a speech like this. “Select next word” “Select last word” “Select next line” “Select last line” and “Select paragraph” To open a menu Enter the name of the menu you want to open.
For example, say “Format” for the format menu and to open the dialog box of the font option present in it. “Font” then say the command whose effect is to be apply.
Like- “bold”, “underline” etc. Speak Use this button to listen to a paragraph.
Note- Will start reading beyond the line in which the cursor is in the paragraph. Pause is used to interrupt the sound.
To add/delete any word like company name etc. in the speech dictionary, click on this option Add/Delete word(s).
This option is use to share the information related to the changes made in the project online.
Shared Workbook – Tools Menu MS Excel
With the help of this option, you can allow your file to work for others. So that he can work by opening our file on his computer. But this will happen at the time when networking has been done on your computer.
Track Change – Tools Menu MS Excel
Its advantage is this. That when we are writing an article and there is doubt about any sentence in it. Whether to keep this sentence or not, then use this option. Clicking on this option will open a bar with three options.
(1) Highlight Changes Clicking on it will open the dialog box. Where by clicking in the box of Track change while editing OK.
And write the sentence about which there is doubt, then the color of that sentence will turn red. Then again when you click OK in the box of track change while editing.
So now what you have written. He will come in real condition. In this way all the sentences about which there is doubt. Whether to include it in the article or not.
You can highlight it through this option. So that we can bring it when we want to bring it into the article. And you can finish when you want to.
(2) By clicking Accept or Reject Changes, the dialog box will open. Where the text highlighted by accept all can be included in the article. And you can eliminate the highlighted text by rejecting all. And whichever of those two is run by Undo. Can cancel its effect.
(3) Compare Document By this, any file can be added to the open file. and can compare with each other. This method is of word 2000. In word 2003 the following toolbar will appear.
Through the option present in it, you can keep track of change comment markup, etc., which you want to keep. And you can delete whatever you want to delete.
Protection – Tools Menu MS Excel
With the help of this option, you can lock the workbook or sheet. So that no one can make any changes to it.
Online Collaboration – Tools Menu MS Excel
This option is used to hold online meetings with people from different places at the same time. When you start online meetings through the office program.
So the net meeting will automatically start running in the background. Now you can share the content of your document.
You can share programs and documents while you are in an online meeting. You can send a message to chat. Can transfer files.
And can work on the whiteboard. Whiteboard This is a separate window. In which there is a facilities like writing text, creating shapes, copying, paste, highlight delete.
Goal Seek – Tools Menu MS Excel
What is the answer after adding it with the help of this option? You can increase or decrease this number as per your wish. If you added 40+70+49, the answer is 200. Now you want this answer which is 200 to become 300.
So to do this, you have to increase the number that rises to any one of those numbers (40+70+90) as low as it is falling. So that is as much as you want to total. Let that be completed.
Method- First of all, add all those numbers and find out its gain. And after selecting the obtained number, click on the Goal Seek option. A dialog box named goal seek will appear in front of you.
Set cell: – Give the range of the number received in this box. eg- B4.
To Value:- In this box, write the number as much as you want to do more or less. eg- 300.
By Change cell: – Give the range of any one of the numbers 40,70,90 added in this box.
For example – B1 then ok. After that, a dialog box will come in which on clicking ok the number achieved will change from 200 to 300.
Scenarios – Tools Menu MS Excel
With the help of the scenario option in Tools Menu MS Excel 2003, you can set any number or word according to your wish in one or more cells with any name.
So that whenever you want to see the set number or word, you can see it by clicking on the show button. The advantage of this is that we don’t have to write an account that we don’t want to reveal. Or we want it. That if this account is erased from the page, then you can see it whenever you want.
Formula Auditing – Tools Menu MS Excel
Tools Menu MS Excel 2003 you can use any function like addition, subtraction, multiplication, division, etc. Take any result in another cell and you are in doubt as to which result is whose?
So to solve this, first of all, select that result. Which is to be found out whose result it is. Then use this option. By using this option, arrow marks will be made from here to there. Which will let you know whose result it is.
Macro – Tools Menu MS Excel
Through this, you can record your article in Tools Menu MS Excel. So that you can bring it whenever you want. On clicking this option, a bar 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.
After that click on the Run option button. On clicking, the recorded item will appear on the page.
2- Record New Macro: On clicking this, the dialog box will open. Where in the box is named Macro with the name of the macro to be recorded? Enter that name and click OK.
A square tool will appear on the page. And the cursor will come in the form of a cassette. Now whatever you type will continue to be recorded in the given macro name.
Now to stop the recording, click on the stop recording button inside the square tool on the page. Once clicked, the recording will stop. Now click on the macros option to get the recorded name with which the macro is recorded. Select it and click on run. Where the cursor is, the recorded text will come.
Note- There are two options in the dialog box that comes by clicking on Record New Macro.
Toolbar And Keyboard
(1) Toolbars: It can bring the recorded macro as a toolbar. So that whenever there is a need to fetch the recorded macro. Click on this toolbar to bring the recorded object to the page. Clicking on it will open the dialog box where click on toolbars and click on new.
Another dialog box will open. In which ok by typing any name in the box named Toolbar, the toolbar will be ready with the same name.
Now in the command box, lift the Normal new macro with the mouse and put it in the toolbar that we have created. And close the dialog box. Now whenever you click on this toolbar, the recorded text will appear on the page.
(2) Keyboard: Through this, you can set the recorded text in any button.
Method- Clicking on it will open the dialog box. Press any letter with Ctrl by placing the cursor in the box of press new shortcut. After that click on Assign and click on Close. A toolbar named Stop will appear on the page.
Whatever you write now will continue to be recorded. Now when to close the record click on stop record. Now whenever you press the shortcut button, the recorded article will appear on the page.
In Microsoft Excel 2003, auto-correct is a feature that automatically changes misspelled words to their correct spelling. To turn off auto-correct, click the checkbox next to “Do not use automatic corrections”. Through this, you can set anything in any ms word.
Method- Clicking on it will open the dialog box. Write any word in the where replace box. For example, in the box of S and with, write the word which is to be set in that box.
Like- https:/hinditekzone.com / After that click on add and click on OK. Now whenever you press the space button by typing s, then https:/hindtekzone.com/ will come.
Through this also you can create shortcut keys and toolbars as per your wish. Use the same method described above. On clicking this option, click on the options button in the dialog box that will open. From the drop-down list of Menu animations at the bottom, select the way the menu opens.
Option – Tools Menu MS Excel 2003
Inside it, all the options and toolbars of the MS Excel program are present, on which the click will start.