I have 190rows in attached excel but 78rows has been selected with merged cell rows but here as its i need to copy the selected rows to new excel sheet how?
I have 190rows in attached excel but 78rows has been selected with merged cell rows but here as its i need to copy the selected rows to new excel sheet how?
Last edited by maddyrafi1987; 09-04-2019 at 09:08 AM.
78 Row : Not found any merged cell. Where is merged cell?
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
goto expiry date column and put filter and select only 2019 year and select jan to september and copy the selected rows to new excel how?
try this correct attached new excel file.
Merged cell functionality in Excel is not designed to work with Cut/Copy and Paste. That's because what merged cells are good at is displaying data, not holding data. They are a purely visual thing. If you are using them for any reason other than displaying data to human eyes, remove them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks