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
 

Pecoflyer

Admin Alumnus
Joined
Oct 13, 2011
Messages
1,766
Reaction score
0
Points
36
Location
Brussels Belgium
Excel Version(s)
2010 on Xubuntu - O365
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
 

sadia

New member
Joined
Jan 26, 2013
Messages
14
Reaction score
0
Points
0
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.
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Hold Ctrl-Shift-down arrow for while (it will jump all the way to the bottom), then just ONE Ctrl-Shit-up arrow.
 
Top