View original (French)

Excel: insert row, shift down

Solved
Clem -  
Morgothal Posted messages 1350 Status Member -
Hello,

I'm encountering a basic problem in Excel.
I have two tables with 17 columns, separated by three empty rows. I want to add to the first table the results from a third table, which only has 15 columns.

When I go to "Insert - Shift cells down," only the first 15 cells are shifted, which completely skews my results. Is there a way to shift the entire row instead of just the filled cells?

Thank you
Best regards,
Clem

3 answers

Answer 1 / 3
Morgothal Posted messages 1350 Status Member 184
 
I think I managed to do it like you do ^^
When you select the rows to paste into your table, make sure to select all the columns, that is, to select by including the row headers.

Then you can "insert the copied rows"
--
-------------------
Sincerely,
Clément
4