MS Excel provides Find & Replace option for finding text within the sheet. Find and Replace Dialogue Let us see how to access the Find & Replace Dialogue. To access the Find & Replace, Choose Home → Find & Select → Find or press Control + F Key. See the image below. Find option in MS Excel You can see the Find […]
Tag: Excel
Spell Check in M S Excel
MS Excel provides a feature of Word Processing program called Spelling check. We can get rid of the spelling mistakes with the help of spelling check feature. Spell Check Basis Let us see how to access the spell check. To access the spell checker, Choose Review ➪ Spelling or press F7. To check the spelling in just a particular range, select […]
Zoom In/Out in M S Excel
Zoom Slider By default, everything on screen is displayed at 100% in MS Excel. You can change the zoom percentage from 10% (tiny) to 400% (huge). Zooming doesn’t change the font size, so it has no effect on the printed output. You can view the zoom slider at the right bottom of the workbook as […]
Special Symbols in M S Excel
If you want to insert some symbols or special characters that are not found on the keyboard in that case you need to use the Symbols option. Using Symbols Go to Insert » Symbols » Symbol to view available symbols. You can see many symbols available there like Pi, alpha, beta, etc. Select the symbol you want to […]
Insert Comments in M S Excel
Adding Comment to Cell Adding comment to cell helps in understanding the purpose of cell, what input it should have, etc. It helps in proper documentation. To add comment to a cell, select the cell and perform any of the actions mentioned below. Choose Review » Comments » New Comment. Right-click the cell and choose […]
Add Text Box in M S Excel
Text Boxes Text boxes are special graphic objects that combine the text with a rectangular graphic object. Text boxes and cell comments are similar in displaying the text in rectangular box. But text boxes are always visible, while cell comments become visible after selecting the cell. Adding Text Boxes To add a text box, perform […]
Undo Changes in M S Excel
Undo Changes You can reverse almost every action in Excel by using the Undo command. We can undo changes in following two ways. From the Quick access tool-bar » Click Undo. Press Control + Z. Undo actions You can reverse the effects of the past 100 actions that you performed by executing Undo more than […]
Setting Cell Type in M S Excel
Formatting Cell MS Excel Cell can hold different types of data like Numbers, Currency, Dates, etc. You can set the cell type in various ways as shown below − Right Click on the cell » Format cells » Number. Click on the Ribbon from the ribbon. Set Cell Type Various Cell Formats Below are the […]
Setting Fonts in M S Excel
You can assign any of the fonts that is installed for your printer to cells in a worksheet. (toc) Setting Font from Home You can set the font of the selected text from Home » Font group » select the font. Set Font from Home Tab Setting Font From Format Cell Dialogue Right click on cell […]
Text Decoration in M S Excel
You can change the text decoration of the cell to change its look and feel. (toc) Text Decoration Various options are available in Home tab of the ribbon as mentioned below. Bold − It makes the text in bold by choosing Home » Font Group » Click B or Press Control + B. Italic − It makes the text italic […]