Imenovanje ćelija

(incubating) | The Free and Open Productivity Suite


	Imenovanje ćelija

Imenovanje ćelija

Ako u vašem radnom listu često koristite neku konstantnu vrednost koju često koristite pri računanju (dnevni kurs valute) možete toj ćeliji dati ime tada ćete tu ćeliju u formuli koristiti po njenom imenu umesto po njenoj adresi.

Na primer u ćeliji A1(pretpostavite da je ime ćelije “kurs”) vam se nalazi dnevni kurs za € a u ćelijama B5-B10 imate cenu nekog artikla u € dok u ćelijama C5-C10 treba da izračunate cenu u dinarima tada umesto da računate po formulu C5=B5*A1 računate C5=B5*kurs.

Ćeliju imenujete tako što kliknete na ćeliju kojoj želite da zadate ime i preko padajućeg menija Insert / Names / Define.

U polje Name ukucate željeno ime i kliknete na dugme Add i kliknete na dugme OK da potvrdite vaš izbor.

Nazad	Kući	Napred
Kopiranje formula	Gore	Grafikoni

Apache Feather

Apache and the Apache feather logos are trademarks of The Apache Software Foundation. OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.

Apache OpenOffice is an effort undergoing incubation at The Apache Software Foundation (ASF), sponsored by the Apache Incubator. Incubation is required of all newly accepted projects until a further review indicates that the infrastructure, communications, and decision making process have stabilized in a manner consistent with other successful ASF projects. While incubation status is not necessarily a reflection of the completeness or stability of the code, it does indicate that the project has yet to be fully endorsed by the ASF.