, ,

27. Editing Worksheet: Undo and Redo

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.You can reverse the effects of the…
, ,

26. Editing Worksheet: Adding Text Box

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…
, ,

25. Editing Worksheet: Inserting Comments

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…
, ,

24. Editing Worksheet: Inserting Special Symbols

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…
, ,

23. Editing Worksheet: Zoom Controls

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…
, ,

22. Editing Worksheet: Using Spell Check

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…
, ,

21. Editing Worksheet: Find and Replace

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 →…
, ,

20. Editing Worksheet: Copy and Paste

MS Excel provides copy paste option in different ways. The simplest method of copy paste is as below. Copy PasteTo copy and paste, just select the cells you want to copy. Choose copy option after right click or press Control + C. …
, ,

19. Editing Worksheet: Rows and Columns

Row and Column Basics MS Excel is in tabular format consisting of rows and columns.Row runs horizontally while Column runs vertically. Each row is identified by row number, which runs vertically at the left side of the sheet. Each…
, ,

18. Editing Worksheet: Moving Data

Let us see how we can Move Data with MS Excel.Step 1 − Select the data you want to Move. Right Click and Select the cut option.Step 2 − Select the first cell where you want to move the data. Right click on it and paste…