Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel auto fill non-sequential numbers

  • 25-11-2016 6:45pm
    #1
    Shiftworker
    Registered Users, Registered Users 2 Posts: 35 ✭


    Hi all,

    Is there a way to auto fill nine non-sequential numbers over & over in Excel?

    example: 3,3,2,2,1,1,0,0,0

    It's for a shift work annual calendar with nine people on the above shift cycle which continues in the same format without changing.

    I really don't want to manually drag and fill these cells as there are thousands of rows...

    Any help please, thank you.


Comments

  • #2
    golfcaptain
    Registered Users, Registered Users 2 Posts: 149 ✭✭golfcaptain


    - Select 9 cells with formula e.g. B1:B9
    - Hover mouse over lower right corner to display + icon
    - Right-click and drag down (takes seconds to do 1000's of rows)
    - Click "Copy Cells" on the menu that pops up when you release the mouse at desired end cell


  • #3
    Shiftworker
    Registered Users, Registered Users 2 Posts: 35 ✭Shiftworker


    Thank you


Advertisement