Xem bản tiếng việt đầy đủ tại đây : http://60s.com.vn/index/1537578/13072008.aspx

MS Excel - Bai 10: Cac buoc huong dan de in trong Excel
Ky thuat in, hay lam the nao de in bang tinh trong Excel? 

De in duoc, Microsoft Excel can may in phai duoc cai dat va ket noi voi may tinh cua ban. Neu may in da duoc ket noi voi may tinh. Hay bat may in va dat giay vao khay may in.

Sau day la cac buoc huong dan ve cach in trong Excel.

Cai dat trang in

Cai dat trang in bao gom thay doi kich thuoc trang, dinh dang trang va chat luong trang in

Thay doi tuy chon thiet lap trang

- Tu menu File, chon Page Setup.

- Hop thoai Page Setup xuat hien, chon tab Page

Thiet lap dinh huong trang in 

Trong phan Orientation, kich vao cac nut chon Portrait (quay giay doc) hoac Landscape (quay giay ngang)

Thiet lap kich thuoc trang in

- Trong phan Scaling, chon Adjust to: nhap ty le phan tram (ban co the kich nut len hoac nut xuong de tang hoac giam kich thuoc)

- Chon Fit to: thiet lap do rong va chieu cao cho trang

Thiet lap nhung lua chon khac cho trang in

Paper size Trong muc Paper size: lua chon kho giay tu danh sach xo xuong
Print quality Trong muc Print quality: chon chat luong in tu danh sach xo xuong (dpi cang cao– chat luong cang tot)
Page numbering De bat dau danh so trang, chon muc First page number: nhap so trang ban muon

Can le trang in

Can le trang in trong Microsoft Excel bao gom can chinh le tren, le duoi, le trai, phai cua trang. Ban cung co the can chinh de du lieu dat o giua trang.

De thay doi le trang

- Hop thoai Page Setup xuat hien, chon tab Margins

- Kich lan luot Top, Bottom, Left, Right va thay doi cac thiet lap

- Kich vao Header de thay doi le dau trang va Footer de thay doi le chan trang

- Kich OK. Chu y: Tai phan Center on page, ban co the chon Horizontally (theo chieu ngang) hoac Vertically (theo chieu doc) de co duoc vi tri dat du lieu tot nhat

Thiet lap Header/Footer

Thiet lap dau trang (Header) va chan trang (Footer) rat quan trong, no tac dong den cach nhin tong quat cua mot trang in.

Thay doi tieu de trang va chan trang

- Chon tab Header/Footer tu hop thoai Page Setup

- Kich vao mui ten xo xuong cua phan Header: cac kieu header da co san trong danh sach. Lua chon kieu dat header ban muon

- Kich nut Custom Header hoac Custom Footer de hien thi hop thoai Header (hoac Footer)

- Trong phan Left section: Nhap du lieu de xuat hien o le trai cua header hay footer

- Trong phan Center section: Nhap du lieu de xuat hien o giua cua header hoac footer

- Trong phan Right section: Nhap du lieu de xuat hien o le phai cua header hoac footer

- Ban cung co the lua chon cac tuy chon sau:

 

Format font Kich vao nut format font (bieu tuong A) sau khi danh dau doan can thay doi font, co va kieu chu
Page number Chen so vao moi trang
Number of pages Su dung tinh nang danh so trang de tao chuoi cac trang tu trang 1 den 15
Date Dua vao ngay hien tai
Time Dua vao gio hien tai
File path Chen them ten duong dan (vi tri file)
File name Them ten vao file workbook
Tab name Them ten vao tab worksheet
Insert picture Chon vi tri de chen anh
Format picture Dinh dang chen anh

- Kich OK sau khi ket thuc

- Tieu de trang (chan trang) moi se duoc hien thi trong hop thoai Page Setup

- Kich OK de dong hop thoai Page Setup

Excel Printing – Thiet lap bang tinh

Trong viec in an Excel, thiet lap trang tinh rat quan trong. No se kiem soat trang nao duoc in va noi de in. Boi vay phai chac chan ban thuc hien nhung buoc sau that can than

Thay doi cac tuy chon trang tinh

- Tu menu File, chon Page Setup.

- Hop thoai Page Setup hien thi, chon tab Sheet 

- Thay doi cac tinh nang sau:

Print area Nhap bang tinh muon in, hoac kich vao bieu tuong ben phai hop va keo worksheet xuong de in
Rows to repeat at top Kich vao bieu tuong ben phai hop va keo dong ban muon de lap lai phia tren cung cua trang. Voi cach nay thi dong do se xuat hien o moi trang tinh.
Columns to repeat at left Kich vao bieu tuong phia ben phai hop va keo cot ban muon lap lai phia ben trai cua trang. Voi cach nay, khi in thi cot ben trai xuat hien o moi trang tinh
Elements that will print Tich vao cac hop trong muc Print neu muon. Vi du Gridlines, Black and White (den trang), Draft Quality (in thu), Row and Column Headings (de muc hang va cot)
Page order Trong muc Page order, lua chon Down, then over hoac Over, then down. Ban se thay duoc hieu ung nay khi du lieu trong trang tinh khong du trong mot trang in

- Mot so dac tinh o muc Print (khi tich vao nhung lua chon nay):

Gridlines Se in ca phan luoi cua bang tinh Excel
Black and white In du lieu theo mau den va trang
Draft quality In voi chat luong thu, khong phai chat luong in thong thuong
Row and column headings Bang tinh duoc in bao gom tieu de hang va cot

- Phia ben phai hop thoai, co 3 nut:

Options Xem lai viec cai dat may in
Print Preview Xem lai trang tinh truoc khi in
Print In trang tinh.

Thay doi cai dat in trong Excel

- Tu menu File, chon Print.

- Hop thoai Print hien thi, thuc hien nhung thay doi can thiet sau:

- O phan Printer, muc Name: lua chon may in ban muon dung

- Trong phan Page range, lua chon All neu ban muon in tat ca cac trang trong mot vung, hoac nhap trang bat dau in vao From va ket thuc vao To

- Trong phan Print what, lua chon phan muon in. Vi du, Phan duoc chon, phan trang tinh, hay toan bo so lam viec

- Trong muc Number of copies: chi dinh so ban duoc in ra

- Kich vao nut Properties de hien thi hop thoai Properties

- Thay doi cac lua chon. Lua chon nay se lam thay doi ket qua tren may in

- Kich OK de dong hop thoai

- Kich tiep OK de bat dau in worksheet

Chu y: Truoc khi kich nut OK, phai chac chan la ban da dat giay vao khay cua may in.

Ngan NT