Entries by Kayyum Patel

, ,

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 below. Choose Review » Comments » New Comment. Right-click the cell and choose […]

, ,

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 view the zoom slider at the right bottom of the workbook as […]

, ,

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 spell checker, Choose Review ➪ Spelling or press F7. To check the spelling in just a particular range, select […]

, ,

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 → Find or press Control + F Key. See the image below. You can see the Find and Replace dialogue as below. You […]

, ,

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 Paste To copy and paste, just select the cells you want to copy. Choose copy option after right click or press Control + C. Select the cell where you need to paste this copied content. Right click and select paste option or […]

, ,

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 column is identified by column header, which runs horizontally at the top of the sheet. For MS […]

, ,

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 the data. You can see the data is moved now.

, ,

17. Editing Worksheet: Deleting Data

MS Excel provides various ways of deleting data in the sheet. Let us see those ways. Delete with Mouse Select the data you want to delete. Right Click on the sheet. Select the delete option, to delete the data. Delete with Delete Key Select the data you want to delete. Press on the Delete Button from the keyboard, it will delete […]

, ,

16. Editing Worksheet: Selecting Data

In MS Excel, there are 1048576*16384 cells. MS Excel cell can have Text, Numeric value or formulas. An MS Excel cell can have maximum of 32000 characters. Inserting Data For inserting data in MS Excel, just activate the cell type text or number and press enter or Navigation keys. Inserting Formula For inserting formula in MS Excel go to the formula bar, enter the formula […]