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

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

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

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

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