imam problem da jednu stranicu u excellu iskopiram istovetno sa svim promenama ka redovima ispod prve ili jos bolje da namestim da mi se automatski iskopira recimo 5000 puta...numeraciju sam resio al ovo ne mogu.....fora je da ocu na matricni da zakacim i da mi stampa svaku stranicu sa drugim brojem a istim sadrzajem...molim vas za pomoc ko brata od tetke
If you want to number pages when you print a worksheet (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows. a worksheet is always stored in a workbook.), you can insert page numbers in the headers or footers of the worksheet pages. Page numbers that you insert are not displayed on the worksheet in Normal view — they are only displayed in Page Layout view and on the printed pages.
You can insert page numbers for a worksheet in Page Layout view where you can see them, or you can use the Page Setup dialog box if you want to insert page numbers for more than one worksheet at the same time. For other sheet types, such as chart sheets (chart sheet: A sheet in a workbook that contains only a chart. A chart sheet is beneficial when you want to view a chart or a PivotChart report separately from worksheet data or a PivotTable report.), you can only insert page numbers by using the Page Setup dialog box.
By default, pages are numbered in sequential order starting with page number 1, but you can start the sequence with a different number. You can also change the order in which the pages are numbered.
nije problem numeracija nego kopiranje....treba mi 5000 istih dokumenata recimo sa razlicitim brojem...brojevi reseni kopiranje problem...ne iskopira mi isto cell width na primer nije isti a i ko da kopira 5000 puta jel ima neki makro il nesto?
u page setup, pa imas na onom zadnjem polju, `Columns repeat from the left` i `rows repeat from the top`. I to sto oznacis pojavice se na svakoj stranici.? Za sve sto niste mogli recite da niste hteli.
Broj postavljenih tema: 60422. Broj poslatih odgovora: 647679. Trenutno niste prijavljeni na PC Berzu i zbog toga imate status 'gosta'. Kao gost ne možete da šaljete poruke na Forum. Ako ste registrovani kao član PC Berze, prijavite se. Ako ste novi korisnik, molimo registrujte se da bi dobili mogućnost aktivnog učešća u radu Foruma.
