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

Ms Excel question

Options
  • 28-04-2004 8:14pm
    #1
    ronano
    Registered Users Posts: 3,145 ✭✭✭


    I am doing a project for my course and i am asked to

    "printout of the spreadsheet showing formula'

    Erm this confuses me is there a way you can highlight the whole sheet and allow every formula to be shown ?


Comments

  • Options
    #2
    sceptre
    Registered Users Posts: 19,608 ✭✭✭✭sceptre


    I'd tend to click Tools, Options, View tab and tick the Formulas box under Window Options and then print the sheet but I'm not too sure if there's another way.


  • Options
    #3
    KdjaCL
    Closed Accounts Posts: 20,346 ✭✭✭✭KdjaCL


    Make the boxes bigger so that it shows =sum(blah blah)
    In case there more than one otherwise what sceptre said is fine.


    kdjac


  • Options
    #4
    ronano
    Registered Users Posts: 3,145 ✭✭✭ronano


    It worked perfect but i was wrong in what i was mean't to do. I was mean't to

    a)write out in english what formula/functions were used in the spreadsheet
    b) give an example and the data code entered

    Easy enough to do

    thanks again


Advertisement