How to fill blank cells in a data range (A1:A20) with out copy paste option in simple steps?
1. Select the complete data set range (A1:A20).
2. Use CTRL + G (goto window) then, hit ALT + S and select Blanks or type 'K'.
3. Click on 'Ok' or press 'Enter'.
4. Now, all of the blank cells have been selected.
5. Now the active cell is the first blank cell in the data set.
6. Type '=' and press 'UP' arrow and press CTRL + Enter, excel will copy the respective formula to all blank cells.
7. Again select the complete data set range to copy and paste the values from formulas. The filled contents are formulas, and we need to convert the formulas to values.
8. Copy the data set and press Alt + E + S (or) Ctrl + Alt + V to enable paste special method, and select values and press enter to paste values.
9. Now the formulas are converted to values.
1. Select the complete data set range (A1:A20).
2. Use CTRL + G (goto window) then, hit ALT + S and select Blanks or type 'K'.
3. Click on 'Ok' or press 'Enter'.
4. Now, all of the blank cells have been selected.
5. Now the active cell is the first blank cell in the data set.
6. Type '=' and press 'UP' arrow and press CTRL + Enter, excel will copy the respective formula to all blank cells.
7. Again select the complete data set range to copy and paste the values from formulas. The filled contents are formulas, and we need to convert the formulas to values.
8. Copy the data set and press Alt + E + S (or) Ctrl + Alt + V to enable paste special method, and select values and press enter to paste values.
9. Now the formulas are converted to values.
No comments:
Post a Comment