Khi l�m vi?c v?i b?ng t�nh, ?�i khi b?n mu?n s? d?ng c�ng layout ho?c thi?t k?. B?n c� th? t?o l?i thi?t k? m?i l�c ?? s? d?ng ho?c c� th? t? t?o m?t m?u.
B?n c� th? t?o m?u cho c�c workbook v� worksheet. D?ng m?u m?c ??nh cho workbook g?i l� Book.xlt. D?ng m?c ??nh cho worksheet g?i l� Sheet.xlt
T?o c�c d?ng m?u g?m c�c ph?n sau:
- T?o workbook g?m t?t c? c�c layout v� ??nh d?ng c�c ph?n t? b?n mu?n ?? l?u l?i th�nh m?t d?ng m?u
- T? menu File, k�ch Save As.
- ??t t�n m?u trong m?c File name
- T? Save as type: k�ch v�o m?i t�n x? xu?ng danh s�ch, ch?n Template.
- Ch?n Save. ?u�i m? r?ng .XLT ???c th�m v�o t�n file v� d?ng m?u ?� ???c l?u trong th? m?c Templates
S? d?ng m?u
- T? menu File, k�ch New ?? hi?n th? ph?n New Workbook
- T? New Workbook, k�ch v�o ???ng link On my computer? ?? hi?n th? h?p tho?i Template
- Ch?n tab General ho?c Spreadsheet Solutions ?? ??nh v? m?u b?n mu?n. V?i m?u ?� m?c ??nh, ch?n tab General v� ch?n bi?u t??ng Workbook
Ch� �: Trong tab Spreadsheet Solutions, c� th? th?y 5 m?u c� s?n. B?n c� th? s? d?ng ??a Microsoft Office ?? c�i ??t nh?ng t�nh n?ng v� s? d?ng ch�ng.
- K�ch OK ?? m? ra m?t m?u
Ch� �: Excel 2003 cho ph�p truy c?p th�m c�c m?u tr�n website c?a Microsoft Office Ch? c?n k�ch v�o ???ng link Templates on Office Online tr�n pane New Workbook, t? ?� c� th? t�m ki?m nh?ng m?u m� b?n c?n.
S? kh�c nhau gi?a Excel template v� Excel style?
Style l� m?t t?p h?p c�c ??nh d?ng th�ng tin c?a � nh? font size (c? ch?), patterns (ki?u d�ng), alignment (canh l?),? b?n c� th? x�c ??nh v� l?u l?i th�nh m?t nh�m
N?u vi?c ??nh d?ng th�ng tin s? d?ng style, n� c� th? c?p nh?t m?t c�ch d? d�ng h�nh th?c sheet b?ng c�ch thay ??i styles.
Excel c� m?t s? ki?u kh�ng x�c ??nh r�, t?t c? c�c � ??u c� ki?u Normal. N� c� th? copy style t? m?t Workbook n�y t?i Workbook kh�c.
T?o m?t style
- L?a ch?n m?t � ??nh d?ng v?i c�c thu?c t�nh
- T? menu Format, k�ch Style.
- H?p tho?i Style xu?t hi?n, g� t�n ki?u v�o Style name ho?c k�ch v�o m?i t�n x? xu?ng v� ch?n
- L?a ch?n n�t Modify ?? thay ??i c�c thu?c t�nh. H?p tho?i Format Cells hi?n th?
- K�ch ch?n c�c tab Number, Alignment, Font, Border, Patterns, Protection v� th?c hi?n c�c thay ??i. K�ch OK ?? tr? l?i h?p tho?i Style
- K�ch OK
�p d?ng m?t style
- L?a ch?n v�ng b?n mu?n ??nh d?ng
- T? menu Format, k�ch Style.
- L?a ch?n style t? Style name
- K�ch OK.
B?n c� th? t?o m?u cho c�c workbook v� worksheet. D?ng m?u m?c ??nh cho workbook g?i l� Book.xlt. D?ng m?c ??nh cho worksheet g?i l� Sheet.xlt
T?o c�c d?ng m?u g?m c�c ph?n sau:
- V?n b?n v� ?? h?a
- Layout v� c�c ki?u ??nh d?ng
- ??u trang (Headers) v� ch�n trang (Footers)
- C�c c�ng th?c
- Macro
- T?o workbook g?m t?t c? c�c layout v� ??nh d?ng c�c ph?n t? b?n mu?n ?? l?u l?i th�nh m?t d?ng m?u
- T? menu File, k�ch Save As.
- ??t t�n m?u trong m?c File name
- T? Save as type: k�ch v�o m?i t�n x? xu?ng danh s�ch, ch?n Template.
S? d?ng m?u
- T? menu File, k�ch New ?? hi?n th? ph?n New Workbook
- T? New Workbook, k�ch v�o ???ng link On my computer? ?? hi?n th? h?p tho?i Template
Ch� �: Trong tab Spreadsheet Solutions, c� th? th?y 5 m?u c� s?n. B?n c� th? s? d?ng ??a Microsoft Office ?? c�i ??t nh?ng t�nh n?ng v� s? d?ng ch�ng.
- K�ch OK ?? m? ra m?t m?u
Ch� �: Excel 2003 cho ph�p truy c?p th�m c�c m?u tr�n website c?a Microsoft Office Ch? c?n k�ch v�o ???ng link Templates on Office Online tr�n pane New Workbook, t? ?� c� th? t�m ki?m nh?ng m?u m� b?n c?n.
S? kh�c nhau gi?a Excel template v� Excel style?
Style l� m?t t?p h?p c�c ??nh d?ng th�ng tin c?a � nh? font size (c? ch?), patterns (ki?u d�ng), alignment (canh l?),? b?n c� th? x�c ??nh v� l?u l?i th�nh m?t nh�m
N?u vi?c ??nh d?ng th�ng tin s? d?ng style, n� c� th? c?p nh?t m?t c�ch d? d�ng h�nh th?c sheet b?ng c�ch thay ??i styles.
Excel c� m?t s? ki?u kh�ng x�c ??nh r�, t?t c? c�c � ??u c� ki?u Normal. N� c� th? copy style t? m?t Workbook n�y t?i Workbook kh�c.
T?o m?t style
- L?a ch?n m?t � ??nh d?ng v?i c�c thu?c t�nh
- T? menu Format, k�ch Style.
- L?a ch?n n�t Modify ?? thay ??i c�c thu?c t�nh. H?p tho?i Format Cells hi?n th?
- K�ch ch?n c�c tab Number, Alignment, Font, Border, Patterns, Protection v� th?c hi?n c�c thay ??i. K�ch OK ?? tr? l?i h?p tho?i Style
- K�ch OK
�p d?ng m?t style
- L?a ch?n v�ng b?n mu?n ??nh d?ng
- T? menu Format, k�ch Style.
- L?a ch?n style t? Style name
- K�ch OK.
Đăng nhận xét