excel basics

Excel allows you to enter fractions, change fraction formats, and display fractions in different ways. 1. Enter a Fraction in Excel Mixed fraction To enter 1 4/7 (one and four sevenths) Simple fraction To enter 4/7, type: 0 4/7 The 0 is important, because without it Excel may think you are entering a date. Example:

In Excel, you can change how many decimal places are displayed without changing the actual number stored in the cell.You can also round numbers if you want to change the value itself. Decrease Decimal Places To show fewer decimal places, use the Decrease Decimal button. Step 1: Enter a number For example, type 2.175 in

Most charts in Excel appear on the same worksheet as the data. These are called embedded charts. However, you can move a chart to its own sheet, called a chart sheet. Move a Chart to a Chart Sheet Follow these steps: 1. Select the chart Click the chart you want to move. 2. Open the

Sometimes worksheets are hidden in Excel. You can easily make them visible again. Note: An Excel workbook must always have at least one visible sheet. Unhide a Worksheet Step 1: Right-click a sheet tab At the bottom of Excel, right-click any visible sheet tab. Then click Unhide. Step 2: Choose the sheet(s) The Unhide dialog

Excel has a Spell Check feature that helps you find and correct spelling mistakes in your worksheet.You can also add words to a custom dictionary or create AutoCorrect shortcuts. 1. Check Spelling in a Worksheet Step 1: Select where to check Step 2: Start Spell Check Go to: Review tab → Proofing group → Spelling

Comments in Excel help you start a conversation or give feedback about a cell.Excel also still supports the old style comments, which are now called Notes. Insert a Comment Follow these steps to add a comment to a cell. 1. Select a cell Click the cell where you want to add a comment. 2. Insert

Excel does not have a built-in function that directly returns the worksheet name in a cell.However, you can combine CELL, FIND, and MID functions to get it. Step 1: Get the file information First, use the CELL function: =CELL(“filename”,A1) This formula returns the full file path, workbook name, and worksheet name. Example result: C:\Users\User\Documents\[Report.xlsx]Sheet1 Note:

Sometimes you need to compare data from two worksheets in the same workbook. Excel allows you to open multiple views of the same file so you can see different sheets simultaneously. 1. Open Your Workbook Start by opening the Excel workbook that contains the worksheets you want to compare. 2. Create Another Window of the

Excel provides a Consolidate feature that allows you to combine data from several worksheets or workbooks into a single summary worksheet. This is very useful when the worksheets are not identical, because Excel can match the data using row and column labels. In this example, you have three workbooks: Each workbook contains similar data, but