1. To show full name at single cell - Once write full name, select all cells , press ctrl + E 2. To show age - =Datedif(select first cell of dob, Today(), "Y" ) + Enter | select all cells , ctrl + D 3. Employee id - ="Cp"&TEXT(SEQUENCE (93),"000") + Enter 4. To adjusting width and height of columns- Ctrl + A , Alt + H + O + A (for hight) Alt + H + O + I (for width) 5. For showing headers while scrolling - Alt + W + F + R