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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.