Select Special Cells for Microsoft Excel is a program that allows you to quickly find all cells that meet your criteria. This handy add-in extends the standard Microsoft Excel “Go to Special” dialog with essential options to select cells by value :
– Select cells based on a numeric value, find the max / min value in a range.
– Find dates within the specified range.
– Select cells of a particular type: constants, objects, comments, formulas or conditional formatting.

Use the Go To command to quickly find and select all cells that contain specific types of data, such as formulas. Also, use Go To to find only the cells that meet specific criteria,—such as the last cell on the worksheet that contains data or formatting.

Follow these steps:

1. Begin by doing either of the following:
   • To search the entire worksheet for specific cells, click any cell.
   • To search for specific cells within a defined area, select the range, rows, or columns that you want. For more information, see Select cells, ranges, rows, or columns on a worksheet.

     Select one or more cells

     1. Click on a cell to select it. Or use the keyboard to navigate to it and select it.
     2. To select a range, select a cell, then with the left mouse button pressed, drag over the other cells.Or use the Shift + arrow keys to select the range.
     3. To select non-adjacent cells and cell ranges, hold Ctrl and select the cells.
        

        Fill Blank Cells in Excel Column

        Some Microsoft Excel worksheets contain cells that have been left blank, in order to make the headings and subheadings easier to read. However, if you want to sort or filter the list, you need to fill in the blanks, by copying the value from the first filled cell above the blank. Follow the instructions on this page to fill the blank cells, manually, or with an Excel macro.

        Fill Blank Cells From Above

        In the screenshot below, cells that have been left blank, so the report headings and subheadings are easier to read. If you need to sort or filter this data, you need to fill the blanks cells, by copying the value from the first filled cell above the blank

        To fill the blank cells manually, you will select all the blanks, enter a simple formula in each cell, then convert the formulas to values. Watch the video below, to see the steps, and the written steps are below the video.

        What is the Go To Special function in Excel?

        The Go To Special function in Excel allows you to quickly select all cells that meet certain criteria, such as cells containing:

        • Formulas (numbers, text, logicals, errors)
        • Constants (numbers, text, logicals, errors)
        • Blank cells

          Press Ctrl + Q on any cell to bring up the Arixcel Explorer window. It will show the formula components with their values and locations. You can use the arrow keys to explore the logical tree. Arixcel Explorer will be highlighting the selected formula parts and navigating to the referenced cells on the spreadsheet.

          • You can continue working with the spreadsheet while the window is open and you can open as many Arixcel Explorer windows as you like. You can close all the windows by clicking on Excel Ribbon > Arixcel > Close All.
          • Showing the target locations of VLOOKUP, OFFSET, INDEX and INDIRECT, as well as the cells selected by SUMIF, SUMIFS, COUNTIF, MIN, MAX, MAXIFS, etc.
          • Showing the cells selected by logical filters inside array formulae. For example, the cells in column B corresponding to the year 2018 in column A, will be shown for the following formula:
            =SUMPRODUCT(–(YEAR(A1:A100)=2018),B1:B100)

          • You can click on the formula in the bottom box to select its part and navigate to the relevant location, and you can Ctrl + click to select multiple parts.
          • The logical choices of functions IF, IFS, CHOOSE, SWITCH are shown in bold.
          • After closing the window, press Ctrl + Backspace to navigate back to the last explored cell. You can go as far as 100 “explorations” back.
          • All highlight colours and keyboard shortcuts are customisable via Arixcel tab > Keyboard Shortcuts > Setup.