![]() |
How do I cause a sort to quit seeing a normal row as a header row
I have set up 10 Scheduling boards for a printing company. Column B is a
5-digit job number, but is not one of the sort criteria. All the boards were set up exactly alike. PROBLEM: 2 of them see header rows; 1 sees line 2, the other sees line 1, so the sort criteria needs to re-established multiple times per day on those two boards. If I eliminate the job number in that row only, it retains the sort criteria and the problem goes away. All the other boards retain the sort criteria and work perfectly. Column B's cells are formatted as "text" on all the boards, but I have tried re-formatting those two boards as "number" and re-entering the data. Makes no difference. There is no visible difference on the boards! Help! |
All times are GMT +1. The time now is 06:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com