Results 1 to 5 of 5

Thread: Selecting values

  1. #1

    Selecting values

    Register for a FREE account, and/
    or Log in to avoid these ads!

    What is the short cut of select the values of a column if there are missing values in the column. Ctrl +Shift + down arrow key is the short cut to select all the values of a column . how to select all the values of column if there are missing values

  2. #2
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Brussels Belgium
    Excel Version
    2010 on Xubuntu
    Select your entire column clicking on the column heading
    Press F5
    Press Special
    Select "constant"
    Select the type(s) you need to select ( appears under " Formulas)

  3. #3
    Sir I do not want to select constant only . i want to select the heading(GDP) to last know value. from heading both missing and non-missing values must be selected.

  4. #4
    Hold Ctrl-Shift-down arrow for while (it will jump all the way to the bottom), then just ONE Ctrl-Shit-up arrow.

  5. #5
    No direct short cut key?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts