Problems due to sorting

[TiredofSppam]

I have a couple annoying problems with some of my worksheets and I
suspect they're caused by sorting. I've used conditional fromatting
and inserted manual page breaks in spreadsheets that I tend to sort
repeatedly in their preparation for monthly reports. The page breaks
tend to float to other rows and the condititional formatting slips to
the wrong row, although it stays is the same column. I also tend to
delete some rows and add new rows each months (it a staffing report and
the changes in staff required the adding/deleting).

So I'm wondering if these things might be caused by the repeated
sorting I have to do. Has anyone else encountered this kind of
problem?


Eldritch

 

[Guest]

I'm not sure if you're doing this, but the guru's who assist us in this forum
have repeatedly said not to use the sort icons on the toolbar, but rather to
use sort from the data menu. Apparently, repeated use of the toolbar icons
may scramble your data.

 

[TiredofSppam]

I'm not sure if you're doing this, but the guru's who assist us in this forum
have repeatedly said not to use the sort icons on the toolbar, but rather to
use sort from the data menu. Apparently, repeated use of the toolbar icons
may scramble your data.

Michael,

That's a good tip! I'm new to this forum and hadn't heard that. I'll
certainly avoid using it in the future.

In this case, I haven't been using the icon. I guess I just prefer
using the menu.

Eldritch