If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
can i input info in excell one page at a time instead of seeing .
i am new to using excell and my accountant has created a spead sheet for me ,
i was wondering can i set up a page so that the information i enter is done on its own page and then put in the speadsheet behind the scenes a bit like entering you contact details then it creates a address book |
#2
|
|||
|
|||
can i input info in excell one page at a time instead of seeing .
Hi,
Sure you can , you will need to be more specific on what you want to do, an example will help "barry" wrote: i am new to using excell and my accountant has created a spead sheet for me , i was wondering can i set up a page so that the information i enter is done on its own page and then put in the speadsheet behind the scenes a bit like entering you contact details then it creates a address book |
#3
|
|||
|
|||
can i input info in excell one page at a time instead of seeing .
Hi Barry, yes you can.
Simply single right click in the tab in which you are working (for example Sheet1) / then select Hide from the list of options that are presented. If my comments have helped please hit Yes. Thanks! "barry" wrote: i am new to using excell and my accountant has created a spead sheet for me , i was wondering can i set up a page so that the information i enter is done on its own page and then put in the speadsheet behind the scenes a bit like entering you contact details then it creates a address book |
#4
|
|||
|
|||
can i input info in excell one page at a time instead of seeing .
"barry" wrote in message
... i am new to using excell and my accountant has created a spead sheet for me , i was wondering can i set up a page so that the information i enter is done on its own page and then put in the speadsheet behind the scenes a bit like entering you contact details then it creates a address book Yes you can and it is something I would recommend. It's good to separate user data from the 'main' part of the spreadsheet. That way if a user inputs inaccurate information whilst it will go through to the 'main' part it can be corrected. On the other hand allowing a user to the mechanics (formulae) of the spreadsheet could spell disaster. Have a look at my web site www.1001solutions.co.uk and, in particular, "Designing a spreadsheet" for more information. Bill R |
#5
|
|||
|
|||
can i input info in excell one page at a time instead of seeing .
I setup one with cash columns and account columns. The total of each column
feeds the Trial Balance and that feed the P&L - Balance sheet. NO need to go over the P&L or B.S. -all transactions are fed from the transactions journal. "Bill R" wrote in message ... "barry" wrote in message ... i am new to using excell and my accountant has created a spead sheet for me , i was wondering can i set up a page so that the information i enter is done on its own page and then put in the speadsheet behind the scenes a bit like entering you contact details then it creates a address book Yes you can and it is something I would recommend. It's good to separate user data from the 'main' part of the spreadsheet. That way if a user inputs inaccurate information whilst it will go through to the 'main' part it can be corrected. On the other hand allowing a user to the mechanics (formulae) of the spreadsheet could spell disaster. Have a look at my web site www.1001solutions.co.uk and, in particular, "Designing a spreadsheet" for more information. Bill R |
Thread Tools | |
Display Modes | |
|
|