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
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,336
    Articles
    0
    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)
    OK

  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
  •