jmichalski81
New Member
- Joined
- Apr 22, 2015
- Messages
- 22
Hi -
I have a spreadsheet used for staffing with employee names in column D and the days of the year from column C through the end of the year. We have a weekly meeting and for employees that don't move to a different project, we use the fill handle to drag them across the row through the end of the following week. Some employees have pre-scheduled days off and we currently just fill across that and re-enter "off" for the day that was previously arranged to be off. Is there a way to keep certain cell values permanent so that the fill handle does not overwrite it?
I have a spreadsheet used for staffing with employee names in column D and the days of the year from column C through the end of the year. We have a weekly meeting and for employees that don't move to a different project, we use the fill handle to drag them across the row through the end of the following week. Some employees have pre-scheduled days off and we currently just fill across that and re-enter "off" for the day that was previously arranged to be off. Is there a way to keep certain cell values permanent so that the fill handle does not overwrite it?
