Learn how to check the spelling of text in Excel. You can also add words to your custom dictionary or AutoCorrect list. 1. On the Review tab, click Spelling. 2. Select a suggestion. 3. Click Change to correct the misspelling in cell A2. 4. Click Change All to correct all instances of this misspelling (cell […]
If you want to view multiple Excel worksheets at the same time, execute the following steps. 1. Open a workbook. 2. On the View tab, click New Window. Excel opens a new window containing another view of the document. 3. On the View tab, click Arrange All. 4. Select the desired arrange setting. For example, […]
You can use Excel’s Consolidate feature to consolidate your worksheets (located in one workbook or multiple workbooks) into one worksheet. Below you can find the workbooks of three districts. Before you start: if your worksheets are identical, it’s probably easier to create 3D-references (if you have one workbook) or External References (if you have multiple […]
You can group all the worksheets which you use daily in Excel. If you want to make change in all worksheets at the same time you can do this in simple way. the following is the way having three (North, Mid and South) sheets and a blank fourth worksheet. 1. To group worksheets, hold down […]
If you have a large amount of data in Excel worksheet and at the bottom of the data or data, you can not see the column heading, to see that you need to go to the top, MS office has solved this problem, it can be useful to freeze rows or columns. This way you […]
Splitting the worksheet means to view the same worksheet but in multiple view.. To split your worksheet (window) into a upper and lower part (pane), execute the following steps. Go to View tab. Go to Window group. and click of SPLIT button, see below As you click the button, the worksheet will split into four […]
Worksheet is the collection of cells arranged in rows and columns where a user calculate and does his working. When you create a file, by default it has three worksheets, as shown in the following figure i.e. Sheet 1, Sheet 2 and Sheet 3 Select a Worksheet When you create a file, by default Sheet1 […]
Some time it is required to lock all the contents but except of some specific cell(s). MS Excel also has provided this facility to unlock specific cell or cells while protecting whole of the rest sheet. See below Suppose, in above figure you want to allow user to change his name, roll number program etc […]
Sometime user feel irritation while clicking the sheet tabs because all the tabs have same colour and it takes some time to find out the tab. so to remove this time consumption a user can change the colour of the sheet tab to differentiate from each other. See below To change the colour, perform the […]
Sometime user can not see some symbols due to his/her eye problem, that’s why MS excel has facility for them to zoom the worksheet to 400% normally. See below After opening the Worksheet, you can see at right bottom corner, there is zoom bar having the range from 10% to 400%. See Below In above […]
