Selecting values

sadia

New member
Joined
Jan 26, 2013
Messages
14
Reaction score
0
Points
0
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
 
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
 
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.
 
Hold Ctrl-Shift-down arrow for while (it will jump all the way to the bottom), then just ONE Ctrl-Shit-up arrow.
 
Back
Top