Excel Examples

In Excel: Sometimes, you may want numbers to behave like text (for IDs, phone numbers, etc.). 1. Change Number Format to Text Now, anything you type will be treated as text (even numbers) 2. Add an Apostrophe Excel will treat it as text, but the apostrophe won’t show in the cell 3. Use the TEXT

In Excel, text is left-aligned and numbers are right-aligned. This example teaches you how to convert ‘text strings that represent numbers’ to numbers. 1. Select the range A1:A4 and change the number format to General. 2. Numbers preceded by an apostrophe are also treated as text. Select cell A5 and manually remove the apostrophe. 3a. You can also combine

In Excel, Currency and Accounting formats are used to display money values.They look similar, but they behave slightly differently. 1. Apply Currency Format Step 1: Select the cells Select the range of cells that contains numbers. Step 2: Apply the format Go to: Home → Number group → Currency Shortcut: Ctrl + Shift + 4

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: