Fill Blank Cells - Inbuilt option in Excel

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.

How to Paste MS Excel sheet data without losing its Format in Gmail?

When you copy a range of cells from Excel, you are only copying data. No HTML is copied, as Excel doesn't generate it.

The grid lines are non-printing in any case, so you need first to turn on cell borders in Excel for any grid lines you want to appear. You then need to copy the selection into a program that understands Excel formatting and can show the grid lines and colors on screen.

So select your cell range and copy-paste into a Word document. Word will generate the HTML code required to display the table, and you can then copy-paste from Word into a Gmail compose message.

It's an extra step, but works every time AND should be received correctly by any recipient.