MS Excel - B�i 10: cac buoc huong dan de in trong Excel

K? thu?t in, hay l�m th? n�o ?? in b?ng t�nh trong Excel?



?? in ???c, Microsoft Excel c?n m�y in ph?i ???c c�i ??t v� k?t n?i v?i m�y t�nh c?a b?n. N?u m�y in ?� ???c k?t n?i v?i m�y t�nh. H�y b?t m�y in v� ??t gi?y v�o khay m�y in.



Sau ?�y l� c�c b??c h??ng d?n v? c�ch in trong Excel.



C�i ??t trang in



C�i ??t trang in bao g?m thay ??i k�ch th??c trang, ??nh d?ng trang v� ch?t l??ng trang in



Thay ??i t�y ch?n thi?t l?p trang



- T? menu File, ch?n Page Setup.



- H?p tho?i Page Setup xu?t hi?n, ch?n tab Page

Thi?t l?p ??nh h??ng trang in



Trong ph?n Orientation, k�ch v�o c�c n�t ch?n Portrait (quay gi?y d?c) ho?c Landscape (quay gi?y ngang)



Thi?t l?p k�ch th??c trang in



- Trong ph?n Scaling, ch?n Adjust to: nh?p t? l? ph?n tr?m (b?n c� th? k�ch n�t l�n ho?c n�t xu?ng ?? t?ng ho?c gi?m k�ch th??c)



- Ch?n Fit to: thi?t l?p ?? r?ng v� chi?u cao cho trang



Thi?t l?p nh?ng l?a ch?n kh�c cho trang in

Paper size	Trong m?c Paper size: l?a ch?n kh? gi?y t? danh s�ch x? xu?ng
Print quality	Trong m?c Print quality: ch?n ch?t l??ng in t? danh s�ch x? xu?ng (dpi c�ng cao? ch?t l??ng c�ng t?t)
Page numbering	?? b?t ??u ?�nh s? trang, ch?n m?c First page number: nh?p s? trang b?n mu?n

C?n l? trang in



C?n l? trang in trong Microsoft Excel bao g?m c?n ch?nh l? tr�n, l? d??i, l? tr�i, ph?i c?a trang. B?n c?ng c� th? c?n ch?nh ?? d? li?u ??t ? gi?a trang.



?? thay ??i l? trang



- H?p tho?i Page Setup xu?t hi?n, ch?n tab Margins

- K�ch l?n l??t Top, Bottom, Left, Right v� thay ??i c�c thi?t l?p



- K�ch v�o Header ?? thay ??i l? ??u trang v� Footer ?? thay ??i l? ch�n trang



- K�ch OK. Ch� �: T?i ph?n Center on page, b?n c� th? ch?n Horizontally (theo chi?u ngang) ho?c Vertically (theo chi?u d?c) ?? c� ???c v? tr� ??t d? li?u t?t nh?t

Thi?t l?p Header/Footer



Thi?t l?p ??u trang (Header) v� ch�n trang (Footer) r?t quan tr?ng, n� t�c ??ng ??n c�ch nh�n t?ng qu�t c?a m?t trang in.



Thay ??i ti�u ?? trang v� ch�n trang



- Ch?n tab Header/Footer t? h?p tho?i Page Setup



- K�ch v�o m?i t�n x? xu?ng c?a ph?n Header: c�c ki?u header ?� c� s?n trong danh s�ch. L?a ch?n ki?u ??t header b?n mu?n



- K�ch n�t Custom Header ho?c Custom Footer ?? hi?n th? h?p tho?i Header (ho?c Footer)

- Trong ph?n Left section: Nh?p d? li?u ?? xu?t hi?n ? l? tr�i c?a header hay footer



- Trong ph?n Center section: Nh?p d? li?u ?? xu?t hi?n ? gi?a c?a header ho?c footer



- Trong ph?n Right section: Nh?p d? li?u ?? xu?t hi?n ? l? ph?i c?a header ho?c footer



- B?n c?ng c� th? l?a ch?n c�c t�y ch?n sau:

Format font	K�ch v�o n�t format font (bi?u t??ng A) sau khi ?�nh d?u ?o?n c?n thay ??i font, c? v� ki?u ch?
Page number	Ch�n s? v�o m?i trang
Number of pages	S? d?ng t�nh n?ng ?�nh s? trang ?? t?o chu?i c�c trang t? trang 1 ??n 15
Date	??a v�o ng�y hi?n t?i
Time	??a v�o gi? hi?n t?i
File path	Ch�n th�m t�n ???ng d?n (v? tr� file)
File name	Th�m t�n v�o file workbook
Tab name	Th�m t�n v�o tab worksheet
Insert picture	Ch?n v� tr� ?? ch�n ?nh
Format picture	??nh d?ng ch�n ?nh

- K�ch OK sau khi k?t th�c



- Ti�u ?? trang (ch�n trang) m?i s? ???c hi?n th? trong h?p tho?i Page Setup



- K�ch OK ?? ?�ng h?p tho?i Page Setup



Excel Printing ? Thi?t l?p b?ng t�nh



Trong vi?c in ?n Excel, thi?t l?p trang t�nh r?t quan tr?ng. N� s? ki?m so�t trang n�o ???c in v� n?i ?? in. B?i v?y ph?i ch?c ch?n b?n th?c hi?n nh?ng b??c sau th?t c?n th?n



Thay ??i c�c t�y ch?n trang t�nh



- T? menu File, ch?n Page Setup.



- H?p tho?i Page Setup hi?n th?, ch?n tab Sheet 

- Thay ??i c�c t�nh n?ng sau:

Print area	Nh?p b?ng t�nh mu?n in, ho?c k�ch v�o bi?u t??ng b�n ph?i h?p v� k�o worksheet xu?ng ?? in
Rows to repeat at top	K�ch v�o bi?u t??ng b�n ph?i h?p v� k�o d�ng b?n mu?n ?? l?p l?i ph�a tr�n c�ng c?a trang. V?i c�ch n�y th� d�ng ?� s? xu?t hi?n ? m?i trang t�nh.
Columns to repeat at left	K�ch v�o bi?u t??ng ph�a b�n ph?i h?p v� k�o c?t b?n mu?n l?p l?i ph�a b�n tr�i c?a trang. V?i c�ch n�y, khi in th� c?t b�n tr�i xu?t hi?n ? m?i trang t�nh
Elements that will print	T�ch v�o c�c h?p trong m?c Print n?u mu?n. V� d? Gridlines, Black and White (?en tr?ng), Draft Quality (in th?), Row and Column Headings (?? m?c h�ng v� c?t)
Page order	Trong m?c Page order, l?a ch?n Down, then over ho?c Over, then down. B?n s? th?y ???c hi?u ?ng n�y khi d? li?u trong trang t�nh kh�ng ?? trong m?t trang in

- M?t s? ??c t�nh ? m?c Print (khi t�ch v�o nh?ng l?a ch?n n�y):

Gridlines	S? in c? ph?n l??i c?a b?ng t�nh Excel
Black and white	In d? li?u theo m�u ?en v� tr?ng
Draft quality	In v?i ch?t l??ng th?, kh�ng ph?i ch?t l??ng in th�ng th??ng
Row and column headings	B?ng t�nh ???c in bao g?m ti�u ?? h�ng v� c?t

- Ph�a b�n ph?i h?p tho?i, c� 3 n�t:

Options	Xem l?i vi?c c�i ??t m�y in
Print Preview	Xem l?i trang t�nh tr??c khi in
Print	In trang t�nh.

Thay ??i c�i ??t in trong Excel



- T? menu File, ch?n Print.



- H?p tho?i Print hi?n th?, th?c hi?n nh?ng thay ??i c?n thi?t sau:

- ? ph?n Printer, m?c Name: l?a ch?n m�y in b?n mu?n d�ng



- Trong ph?n Page range, l?a ch?n All n?u b?n mu?n in t?t c? c�c trang trong m?t v�ng, ho?c nh?p trang b?t ??u in v�o From v� k?t th�c v�o To



- Trong ph?n Print what, l?a ch?n ph?n mu?n in. V� d?, Ph?n ???c ch?n, ph?n trang t�nh, hay to�n b? s? l�m vi?c



- Trong m?c Number of copies: ch? ??nh s? b?n ???c in ra



- K�ch v�o n�t Properties ?? hi?n th? h?p tho?i Properties



- Thay ??i c�c l?a ch?n. L?a ch?n n�y s? l�m thay ??i k?t qu? tr�n m�y in



- K�ch OK ?? ?�ng h?p tho?i



- K�ch ti?p OK ?? b?t ??u in worksheet



Ch� �: Tr??c khi k�ch n�t OK, ph?i ch?c ch?n l� b?n ?� ??t gi?y v�o khay c?a m�y in.

(QTM)

Submit Article :- Digg + Technorati + del.icio.us + Stumbleupon + Reddit + BlinkList + Furl + Yahoo+ Blogmarks + Ekstreme Socializer

|