How do you put a repeating pattern (work schedule) in Excel?
up vote
0
down vote
favorite
We use Excel for our schedules, day and night shifts. For the most part our schedules have become set. 6 nights on, 8 off, for night shift and a little more complicated schedule for days. I'm wondering if there is a way to have it auto-fill for the entire year instead of typing it all in each month. Columns are dates and rows are the employees. Thanks!
microsoft-excel
asked Nov 13 at 13:58
Heidi Wilde
11
New contributor
Heidi Wilde is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
up vote
0
down vote
favorite
We use Excel for our schedules, day and night shifts. For the most part our schedules have become set. 6 nights on, 8 off, for night shift and a little more complicated schedule for days. I'm wondering if there is a way to have it auto-fill for the entire year instead of typing it all in each month. Columns are dates and rows are the employees. Thanks!
microsoft-excel
asked Nov 13 at 13:58
Heidi Wilde
11
New contributor
Heidi Wilde is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
Hilight the whole thing, drag the small marker in the bottom right of the cell. If it's more complicated than this, you'll need to provide some kind of example.
– djsmiley2k
Nov 13 at 14:00
You can also copy paste. It'll use the same logic.
– LPChip
Nov 13 at 14:06
"Columns are dates and rows are the employees" .. so in one day there are how many slots/hours/Employees?
– p._phidot_
Nov 13 at 15:08
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
We use Excel for our schedules, day and night shifts. For the most part our schedules have become set. 6 nights on, 8 off, for night shift and a little more complicated schedule for days. I'm wondering if there is a way to have it auto-fill for the entire year instead of typing it all in each month. Columns are dates and rows are the employees. Thanks!
microsoft-excel
asked Nov 13 at 13:58
Heidi Wilde
11
New contributor
Heidi Wilde is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
We use Excel for our schedules, day and night shifts. For the most part our schedules have become set. 6 nights on, 8 off, for night shift and a little more complicated schedule for days. I'm wondering if there is a way to have it auto-fill for the entire year instead of typing it all in each month. Columns are dates and rows are the employees. Thanks!
microsoft-excel
microsoft-excel
asked Nov 13 at 13:58
Heidi Wilde
11
New contributor
Heidi Wilde is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Nov 13 at 13:58
Heidi Wilde
11
New contributor
Heidi Wilde is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Nov 13 at 13:58
Heidi Wilde
11
New contributor
Heidi Wilde is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Nov 13 at 13:58
Heidi Wilde
11
asked Nov 13 at 13:58
Heidi Wilde
11
11
New contributor
Heidi Wilde is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Heidi Wilde is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Heidi Wilde is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
Hilight the whole thing, drag the small marker in the bottom right of the cell. If it's more complicated than this, you'll need to provide some kind of example.
– djsmiley2k
Nov 13 at 14:00
You can also copy paste. It'll use the same logic.
– LPChip
Nov 13 at 14:06
"Columns are dates and rows are the employees" .. so in one day there are how many slots/hours/Employees?
– p._phidot_
Nov 13 at 15:08
add a comment |
1
Hilight the whole thing, drag the small marker in the bottom right of the cell. If it's more complicated than this, you'll need to provide some kind of example.
– djsmiley2k
Nov 13 at 14:00
You can also copy paste. It'll use the same logic.
– LPChip
Nov 13 at 14:06
"Columns are dates and rows are the employees" .. so in one day there are how many slots/hours/Employees?
– p._phidot_
Nov 13 at 15:08
1
1
Hilight the whole thing, drag the small marker in the bottom right of the cell. If it's more complicated than this, you'll need to provide some kind of example.
– djsmiley2k
Nov 13 at 14:00
Hilight the whole thing, drag the small marker in the bottom right of the cell. If it's more complicated than this, you'll need to provide some kind of example.
– djsmiley2k
Nov 13 at 14:00
You can also copy paste. It'll use the same logic.
– LPChip
Nov 13 at 14:06
You can also copy paste. It'll use the same logic.
– LPChip
Nov 13 at 14:06
"Columns are dates and rows are the employees" .. so in one day there are how many slots/hours/Employees?
– p._phidot_
Nov 13 at 15:08
"Columns are dates and rows are the employees" .. so in one day there are how many slots/hours/Employees?
– p._phidot_
Nov 13 at 15:08
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Heidi Wilde is a new contributor. Be nice, and check out our Code of Conduct.
Heidi Wilde is a new contributor. Be nice, and check out our Code of Conduct.
Heidi Wilde is a new contributor. Be nice, and check out our Code of Conduct.
Heidi Wilde is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1375034%2fhow-do-you-put-a-repeating-pattern-work-schedule-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Hilight the whole thing, drag the small marker in the bottom right of the cell. If it's more complicated than this, you'll need to provide some kind of example.
– djsmiley2k
Nov 13 at 14:00
You can also copy paste. It'll use the same logic.
– LPChip
Nov 13 at 14:06
"Columns are dates and rows are the employees" .. so in one day there are how many slots/hours/Employees?
– p._phidot_
Nov 13 at 15:08