Y yaelcohen Member Mar 16, 2016 #1 Hello My question is: if I have a column of numbers that part of the lines are results of formulas but part are the numbers as written by myself Is there any easy way tp recognize where it is a result of formula and which it a written number? Thanks for your help
Hello My question is: if I have a column of numbers that part of the lines are results of formulas but part are the numbers as written by myself Is there any easy way tp recognize where it is a result of formula and which it a written number? Thanks for your help
Luke M Excel Ninja Staff member Mar 16, 2016 #2 Sure thing. Select the entire column Hit Ctrl+g (stands for GoTo) Click Special Select Formulas Hit Ok. All the selected cells have formulas.
Sure thing. Select the entire column Hit Ctrl+g (stands for GoTo) Click Special Select Formulas Hit Ok. All the selected cells have formulas.
