Excel Tutorials for beginners, Intermediates and experts.
To help prevent changes to a final version of an excel file, you Mark a workbook as final. Only use this feature to discourage editing. Users can still edit the workbook. Here are steps to Mark a workbook as final below: 1. Open a workbook. 2. On the File tab, click Info. 3. Click Protect Workbook, Mark as …
To separate the contents of one Excel cell into separate columns, you can use the ‘Convert Text to Columns Wizard’. For example, when you want to separate a list of full names into last and first names. 1. Select the range with full names. 2. On the Data tab, in the Data Tools group, click Text to Columns. …
To quickly delete a row in Excel, select a row and use the shortcut key CTRL – (minus sign). To quickly delete multiple rows, select multiple rows and use the same shortcut. Delete Row To delete a row in Excel, execute the following steps. 1. Select a row. 2. Right click, and then click Delete. Result: Note: …
To quickly insert a row in Excel, select a row and use the shortcut keys CTRL SHIFT +. To quickly insert multiple rows, select multiple rows and use the same shortcut. Insert Row To insert a row in Excel, execute the following steps. 1. Select a row. 2. Right click, and then click Insert. Result: Note: instead of …
Learn how to check the spelling of text in Excel. You can also add words to your custom dictionary or AutoCorrect list. 1. Open a worksheet with some spelling errors. 2. On the Review tab, in the Proofing group, click Spelling. 3. Select a suggestion and click Change to correct the misspelling in cell A2. 4. Click Change …
Formula auditing in Excel allows you find and correct errors in formulas. Also, displays the relationship between formulas and cells using Trace Precedents, Remove Arrows, Trace Dependents, Show Formulas, Error Checking and Evaluate Formula. The example below helps you master Formula Auditing quickly and easily. Trace Precedents You have to pay $96.00. To show arrows that indicate which cells are used …
Example of how to find the most frequently occurring word in an Excel Worksheet. You can use the MODE function to find the most frequently occurring number. However, the MODE function only works with numbers. You can use the COUNTIF function to count the number of occurrences of each word. However, we are looking for a single formula that returns the most …
The Currency format and the Accounting format in Excel are very similar to each other. This example shows the difference. 1. Enter the following values. 2. The Currency format places the dollar sign right next to the number. 3. The Accounting format aligns the dollar signs at the left edge of the cell and displays a dash for zero values. Note: …
When you have empty rows cluttering your spreadsheet and you need to tighten it up, easy and fast? Removing blank rows is the first thing you should do! This example teaches you how to delete blank rows or rows that contain blank cells. 1. On the Home tab, in the Editing group, click Find & Select. 2. …
If you have a large table of data in Excel, it can be useful to freeze rows or columns. This way you can keep rows or columns visible while scrolling through the rest of the worksheet. Freeze Top Row To freeze the top row, execute the following steps. 1. On the View tab, in the Window group, click …