Forum Discussion
Solved
Shifting of excel rows
So I want to shift all the rows /columns to the left .If you see that if i filter education columns now it will show that marital status has blanks. so, every content those cells are shifted to the r...
- Remove the filer
Go to 2nd cycle
Select the data next to it in D column
With right click select delete
Select “shift cells left”
yeah true there is no problem with the filter the data is misplaced so how do we fix that , lke how do i put the misplaced data to its correct columns .
- Thanks for your help and patience ,all my doubts are clear now 😄
- Remove the filer
Go to 2nd cycle
Select the data next to it in D column
With right click select delete
Select “shift cells left” jitinm with filter on if we try to delete it shows to delete the entire row .without the filter on we can delete that column and shift it . but here for other education types the placement of these columns are perfect.
if i try deleting with filter on then it is just deleting the entire rows
theInsider You select the cells say D4(1st data) till D200(where data for it ends). Then right click from mouse and select Delete and select Shift cells left
- yeah we need to remove cycle from column D while applying the filter for 2nd cycle .
But is there more efficient way other than just copying and paste of all other columns to its respective places . like some type of function or something because it will be laborious task to just copying and pasting those values to its respective columns. - Yes of course. For 2nd Cycle, you need to delete the D Coulmn data. Remember only for 2nd Cycle.