Tips and Tricks for MS Excel


This article will help you learn and revise more advanced Microsoft Excel features such as Auto fill, Find and Replace, Filter and Sort, and Inserting Rows and Columns to better process, analyze, and visualize your data.


Auto fill

Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells.

  • Select one or more cells you want to use as a basis for filling additional cells.
  • For a series like 1, 2, 3, 4, 5..., type 1 and 2 in the first two cells. For the series 2, 4, 6, 8..., type 2 and 4.
  • For the series 2, 2, 2, 2..., type 2 in first cell only.
  • Drag the fill handle Fill handle.
  • If needed, click Auto Fill Options  Button image  and choose the option you want.


You can use formulas in excel in order to perform mathematical operations ranging from simple to complex operations. 

  • Select a cell.
  • Type the equal sign =.
Note: Formulas in Excel always begin with the equal sign.
  • Select a cell or type its address in the selected cell.

Screenshot of  an Excel Formula

  • Enter an operator. For example, for subtraction.
  • Select the next cell, or type its address in the selected cell.

Screenshot of  an Excel Formula

  • Press Enter. The result of the calculation appears in the cell with the formula.

Find and Replace

Use the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string. You can either locate the search item for reference, or you can replace it with something else. You can include wildcard characters such as question marks, tildes, and asterisks, or numbers in your search terms. You can search by rows and columns, search within comments or values, and search within worksheets or entire workbooks.

  • To find something, press Ctrl+F, or go to Home > Editing Find & Select > Find.

Screenshot of the Find functionality

  • To replace text or numbers, press Ctrl+H, or go to Home > Editing Find & Select > Replace.

Screenshot of the Replace Function


Filter and Sort

Sort data in Excel quickly, in just a few clicks. To change the order of your data, sort it. To focus on a specific set of data, filter a range of cells or a table.

  • Select a range of data, such as A1:L5 (multiple rows and columns), or C1:C80 (a single column). The range can include titles (headers) that you create to identify columns or rows or Select a single cell in the column you want to sort.

  • Click Sort A to Z to perform an ascending sort (A to Z or smallest number to largest) or Click Sort Z to A to perform a descending sort (Z to A or largest number to smallest).

Screenshot of the Sort and Filter Function


Inserting Rows and Columns

Insert and delete rows and columns to organize your worksheet better.

  • Select any cell within the column, then go to Home > Insert > Insert Sheet Columns or Delete Sheet Columns.

  • Alternatively, right-click the top of the column, and then select Insert or Delete


Article ID: 1100
Thu 4/20/23 4:43 PM
Tue 11/14/23 12:13 PM