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 query on rounding cells

  • 27-01-2009 9:59am
    #1
    bongoboy
    Closed Accounts Posts: 53 ✭✭


    Hope someone can help with an excel query we have.

    We have a column of cells we want to round to 2 decimels.

    The formula is

    =round(A1,2)

    However, how can I copy in this formula to 300 + rows without typing it every time?

    Any help appreciated


Comments

  • #2
    Baby4
    Closed Accounts Posts: 1,407 ✭✭✭Baby4


    This post has been deleted.


  • #3
    Kine
    Closed Accounts Posts: 69 ✭✭Kine


    You can copy the cell with the formula (any formula), and highlight all the cells you wish to copy it to, right click and select paste special and I think there is a "forumla" option to select.

    Or you could just select every cell and do as poster #2 suggests!


  • #4
    susie-q
    Closed Accounts Posts: 44 ✭susie-q


    Enter the formula into the first cell then click on the bottom right of that cell and the courser will change then drag that to all the cells u want. If u want 1 part of ur formula to be fixed the whole way down but a dollar sign before and after the cell number you want to fix.
    e.g.. =B2+C5 becomes =B2+$C$5


  • #5
    bongoboy
    Closed Accounts Posts: 53 ✭✭bongoboy


    Thanks all,
    yep the drag from bottom corner is what i needed, thanks Susie.


Advertisement