Control Toolbox

[Ashu]

Dear All,

I would like to know how i learn to use control toolbox buttons, my aim
is to create a excel sheet which is similiar to invoice template found
in File -> new -> spreadsheet solution tab -> invoice.template.

Could any one of u explain in simple steps.

Thank you in advance,

Ashu.

 

[MeAgain]

I think the best way to learn from existing sheet is to open the sheet and
(save as) the sheet with different name and then
from the TOP MENU select DATA-PROTECTION-UNPROTECT SHEET
after removing the protection from the sheet you will able to click on any
cell.
to find the difference between press Ctrl+1 (ie press Ctrl and then 1) and
just browse to find diffence between two cell by cheking indvidual cells.

To find the formulas in ALL cells OR where ever they in the SHEET.
again from the MENU-TOOLS-OPTION and select VIEW tab from the pop up form
and CHECK Formula from the WINDOW OPTION. and OK
now you will able to see all the formulas.
for explaination of the formula

now you will be able to see all the foumulas in the cells.
HTH

 

[Ashu]

I tried the above as per the instruction but sorry to say i didn't gain
anything i wanted, i need to learn basic steps to create control
toolbox, so could you please help me in simple steps which will be of
great help.

Regards,

Sanoop.