Copy cell contents in empty rows below it till any unempty row com

  • Thread starter Thread starter vtmalhan
  • Start date Start date
V

vtmalhan

How would I copy cell contents of one cell in empty rows below it till any
unempty row comes?
 
You can use the shift & cntl and down arrow keys

If you had a 1 in A1 and a 5 in A10. To copy the 1 to rows 2 to 9 you can
do the following

1) Click on cell A1 and copy
2) Click on cell A2. Press shift and Cntl and then down arrow. A2 to A10
will be highlighted.
3) Release Cntl and down arrow while still holding the Shift. Now press up
arrow. A2 to A9 will be highlighted.
4) Perform a Paste (Cntl - V or use edit menu)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
delete row if 2 cells are empty 1
Using one row, how do I fill the row below (numerous times)? 2
how do I shift the contents of the cells up to remove empty cells. 2
Delete empty rows 1
VBA set thick borders around non empty cells in range 0
I am stumped. Help with Formula... 5
Inserting data to next available empty cells 2

Back
Top