my problem is that Excel 2007 deletes hidden rows while deleting selected rows. while in other pc it does not delete hidden rows while deleting some selected row. what configuration change it required to correct it.
my problem is that Excel 2007 deletes hidden rows while deleting selected rows. while in other pc it does not delete hidden rows while deleting some selected row. what configuration change it required to correct it.
Well yes, those cells will still be in a select if your clicking and dragging. You need to select rows using the control key to avoid the problem.
Hi g45427
Welcome to the forum
One way round this is, having selected your area (including the hidden rows or columns), press Alt+; (semicolon). This will de-select any hidden cells.
Let me know if it works for you
Regards
Alastair
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks