C�c t�nh n?ng b?o v? b?ng t�nh v� file Excel cho ph�p b?o v? t�i li?u v� ch? ng??i c� quy?n m? ???c. B?n c� th? ??t m?t kh?u v� khi c� ai ?� mu?n m? t�i li?u th� c?n ph?i c� m?t kh?u ?�.
L?p m?t kh?u ?? m? v� ch?nh s?a file
- T? menu File, k�ch Save As.
- H?p tho?i Save As xu?t hi?n, k�ch Tools v� t? menu x? xu?ng ch?n General Options.
L?p m?t kh?u ?? m? v� ch?nh s?a file
- T? menu File, k�ch Save As.
- H?p tho?i Save As xu?t hi?n, k�ch Tools v� t? menu x? xu?ng ch?n General Options.
- H?p tho?i Save Options xu?t hi?n, nh?p m?t kh?u v�o m?c Password to open: V?i t�nh n?ng n�y, b?n ph?i nh?p m?t kh?u ?? m? file
- N?u b?n ch? nh?p m?t kh?u v�o Password to modify th� ?�y l� m?t c�ch v?n cho ph�p m? v� xem t�i li?u. N?u ng??i ??c mu?n ch?nh s?a v� l?u l?i th� ph?i nh?p m?t kh?u, n?u kh�ng c� m?t kh?u th� ph?i l?u v?i m?t t�n kh�c.
- K�ch n�t OK. Sau ?� b?n ph?i nh?p l?i m?t kh?u ?? ch?c ch?c m?t kh?u ho�n to�n ?�ng.
Ch� �:
+ H?p ch?n ?Always create backup? c?a Excel s? t?o m?t file sao ch�p trong m?i l�c khi l?u file. File c� ?u�i m? r?ng l� BAK, file backup s? ???c l?u trong th? m?c nh? file g?c.
+ N?u m?c "Read-only recommended" ???c t�ch, h?p tho?i sau ?�y hi?n th? khi t�i li?u ???c m? l?i
- K�ch n�t OK. Sau ?� b?n ph?i nh?p l?i m?t kh?u ?? ch?c ch?c m?t kh?u ho�n to�n ?�ng.
Ch� �:
+ H?p ch?n ?Always create backup? c?a Excel s? t?o m?t file sao ch�p trong m?i l�c khi l?u file. File c� ?u�i m? r?ng l� BAK, file backup s? ???c l?u trong th? m?c nh? file g?c.
+ N?u m?c "Read-only recommended" ???c t�ch, h?p tho?i sau ?�y hi?n th? khi t�i li?u ???c m? l?i
- K�ch Yes.
- T�i li?u s? ???c m? l?i v?i t�nh n?ng ch? ??c ?read-only?
- N?u c� thay ??i tr�n file, b?n kh�ng th? l?u v?i t�n file ?�. V� v?y mu?n l?u ???c b?n c?n thay ??i t�n file
G? b? m?t kh?u tr�n m?t file
- M? file ch?a m?t kh?u mu?n g? b? (m? b?ng c�ch nh?p m?t kh?u khi c� y�u c?u)
- T? menu File, k�ch Save As.
- H?p tho?i Save As hi?n th?, ch?n General Options t? menu x? xu?ng c?a bi?u t??ng Tools
- H?p tho?i Save Options hi?n th?, x�a m?t kh?u ?� ??t
- K�ch n�t OK ?? ?�ng h?p tho?i Save Options
- K�ch n�t Save ?? l?u file, hi?n th? m?t h?p tho?i
- K�ch n�t Yes
B?o v? file
- T? menu Tools, ch?n Protection v� k�ch Protect Workbook.
- H?p tho?i Protect Workbook hi?n th?
- T�i li?u s? ???c m? l?i v?i t�nh n?ng ch? ??c ?read-only?
- N?u c� thay ??i tr�n file, b?n kh�ng th? l?u v?i t�n file ?�. V� v?y mu?n l?u ???c b?n c?n thay ??i t�n file
G? b? m?t kh?u tr�n m?t file
- M? file ch?a m?t kh?u mu?n g? b? (m? b?ng c�ch nh?p m?t kh?u khi c� y�u c?u)
- T? menu File, k�ch Save As.
- H?p tho?i Save As hi?n th?, ch?n General Options t? menu x? xu?ng c?a bi?u t??ng Tools
- H?p tho?i Save Options hi?n th?, x�a m?t kh?u ?� ??t
- K�ch n�t OK ?? ?�ng h?p tho?i Save Options
- K�ch n�t Save ?? l?u file, hi?n th? m?t h?p tho?i
- K�ch n�t Yes
B?o v? file
- T? menu Tools, ch?n Protection v� k�ch Protect Workbook.
- H?p tho?i Protect Workbook hi?n th?
- H?p tho?i Protect Workbook cho b?n 2 l?a ch?n:
| Structure | C?u tr�c Kh�ng cho ph�p m?i thay ??i c?u tr�c file ?� ???c ch?n. V� d?, b?n s? kh�ng th? so?n th?o, ch�n, x�a, ??i t�n, copy, di chuy?n hay ?n c�c sheet |
| Windows | Kh�ng cho ph�p c�c thay ??i k�ch th??c c�c file. C�c ?i?u ch?nh v? k�ch th??c c?a s? (?�ng, m? r?ng, thu nh? v� kh�i ph?c) s? b? ?n ?i. |
- Nh?p m?t kh?u v�o c?t Password. K�ch OK.
- B?n ph?i nh?p l?i m?t kh?u ?? ch?c ch?c m?t kh?u ho�n to�n ?�ng
- K�ch OK.
B? b?o v? file
- T? menu Tools, ch?n Protection v� k�ch Unprotect Workbook.
- Nh?p m?t kh?u v� k�ch OK.
B?o v? b?ng t�nh (sheet)
- T? menu Tools, ch?n Protection v� k�ch Protect Sheet.
- H?p tho?i Protect Sheet hi?n th?
- B?n ph?i nh?p l?i m?t kh?u ?? ch?c ch?c m?t kh?u ho�n to�n ?�ng
- K�ch OK.
B? b?o v? file
- T? menu Tools, ch?n Protection v� k�ch Unprotect Workbook.
- Nh?p m?t kh?u v� k�ch OK.
B?o v? b?ng t�nh (sheet)
- T? menu Tools, ch?n Protection v� k�ch Protect Sheet.
- H?p tho?i Protect Sheet hi?n th?
- T? h?p tho?i Protect Sheet, b?n c� th? t�ch v�o c�c t�nh n?ng ? m?c ?Allow all users of this worksheet to? ?? kh�ng ai c� th? thay ??i c�c ??nh d?ng ?�. N?u m?c n�o kh�ng ???c t�ch th� ng??i kh�c c� th? c� c�c thay ??i theo m?c ?�.
- Nh?p m?t kh?u trong c?t Password to unprotect sheet, k�ch OK
- B?n ph?i nh?p l?i m?t kh?u ?? ch?c ch?c m?t kh?u ho�n to�n ?�ng
- K�ch OK.
B? b?o v? b?ng t�nh (sheet)
- T? menu Tools, ch?n Protection v� k�ch Unprotect Worksheet.
- Nh?p m?t kh?u v� k�ch OK.
- Nh?p m?t kh?u trong c?t Password to unprotect sheet, k�ch OK
- B?n ph?i nh?p l?i m?t kh?u ?? ch?c ch?c m?t kh?u ho�n to�n ?�ng
- K�ch OK.
B? b?o v? b?ng t�nh (sheet)
- T? menu Tools, ch?n Protection v� k�ch Unprotect Worksheet.
- Nh?p m?t kh?u v� k�ch OK.
Đăng nhận xét