{"id":4399,"date":"2025-11-11T17:04:46","date_gmt":"2025-11-11T10:04:46","guid":{"rendered":"https:\/\/autofillform.com\/blog\/huong-dan-5-cach-go-bo-che-do-read-only-trong-excel\/"},"modified":"2025-11-11T17:04:46","modified_gmt":"2025-11-11T10:04:46","slug":"huong-dan-5-cach-go-bo-che-do-read-only-trong-excel","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/huong-dan-5-cach-go-bo-che-do-read-only-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn 5 C\u00e1ch g\u1ee1 b\u1ecf ch\u1ebf \u0111\u1ed9 Read Only trong Excel"},"content":{"rendered":"
\n
\u00a0<\/div>\n

Khi m\u1edf file Excel v\u00e0 th\u1ea5y th\u00f4ng b\u00e1o \u201cRead Only\u201d, b\u1ea1n s\u1ebd kh\u00f4ng th\u1ec3 ch\u1ec9nh s\u1eeda hay l\u01b0u thay \u0111\u1ed5i trong t\u00e0i li\u1ec7u. T\u00ecnh tr\u1ea1ng n\u00e0y th\u01b0\u1eddng x\u1ea3y ra khi file \u0111\u01b0\u1ee3c t\u1ea3i t\u1eeb Internet, chia s\u1ebb qua m\u1ea1ng n\u1ed9i b\u1ed9 ho\u1eb7c c\u00e0i \u0111\u1eb7t ph\u00e2n quy\u1ec1n b\u1ea3o m\u1eadt. C\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch g\u1ee1 b\u1ecf ch\u1ebf \u0111\u1ed9 Read Only trong Excel chi ti\u1ebft trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n

\"G\u1ee1Thao t\u00e1c g\u1ee1 b\u1ecf ch\u1ebf \u0111\u1ed9 Read Only trong Excel, gi\u00fap ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda v\u00e0 l\u01b0u file<\/em><\/p>\n

\n

1. Tr\u01b0\u1eddng h\u1ee3p n\u00e0o c\u1ea7n t\u1eaft ch\u1ebf \u0111\u1ed9 Read Only trong Excel?<\/h2>\n<\/div>\n

Ch\u1ebf \u0111\u1ed9 Read Only trong Excel th\u01b0\u1eddng \u0111\u01b0\u1ee3c k\u00edch ho\u1ea1t khi b\u1ea1n m\u1edf m\u1ed9t t\u1ec7p t\u1ea3i v\u1ec1 t\u1eeb Internet ho\u1eb7c nh\u1eadn t\u1eeb ng\u01b0\u1eddi kh\u00e1c. \u1ede ch\u1ebf \u0111\u1ed9 n\u00e0y, ng\u01b0\u1eddi d\u00f9ng ch\u1ec9 c\u00f3 quy\u1ec1n xem m\u00e0 kh\u00f4ng th\u1ec3 ch\u1ec9nh s\u1eeda, nh\u1eb1m b\u1ea3o v\u1ec7 n\u1ed9i dung g\u1ed1c v\u00e0 ng\u0103n ng\u1eeba thay \u0111\u1ed5i ngo\u00e0i \u00fd mu\u1ed1n. Tuy nhi\u00ean, trong m\u1ed9t s\u1ed1 t\u00ecnh hu\u1ed1ng, vi\u1ec7c g\u1ee1 b\u1ecf gi\u1edbi h\u1ea1n n\u00e0y l\u00e0 c\u1ea7n thi\u1ebft \u0111\u1ec3 thu\u1eadn ti\u1ec7n cho c\u00f4ng vi\u1ec7c.<\/p>\n

C\u1ee5 th\u1ec3, b\u1ea1n c\u00f3 th\u1ec3 c\u1ea7n t\u1eaft Read Only trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p nh\u01b0:<\/p>\n

    \n
  • L\u00e0m vi\u1ec7c nh\u00f3m ho\u1eb7c c\u1ea7n chia s\u1ebb, ch\u1ec9nh s\u1eeda d\u1eef li\u1ec7u chung tr\u00ean c\u00f9ng m\u1ed9t file.<\/li>\n
  • File b\u1ecb v\u00f4 hi\u1ec7u h\u00f3a ch\u1ec9nh s\u1eeda do xung \u0111\u1ed9t v\u1edbi Add-ins VNTools.<\/li>\n
  • C\u1ea7n \u0111i\u1ec1u ch\u1ec9nh ho\u1eb7c c\u1eadp nh\u1eadt ph\u00e2n quy\u1ec1n trong m\u1ee5c Security c\u1ee7a Microsoft Office.<\/li>\n<\/ul>\n

    Vi\u1ec7c hi\u1ec3u r\u00f5 nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch x\u1eed l\u00fd s\u1ebd gi\u00fap b\u1ea1n ch\u1ee7 \u0111\u1ed9ng kh\u1eafc ph\u1ee5c l\u1ed7i Read Only, \u0111\u1ea3m b\u1ea3o qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi Excel di\u1ec5n ra tr\u01a1n tru v\u00e0 hi\u1ec7u qu\u1ea3 h\u01a1n.<\/p>\n

    \"H\u01b0\u1edbngNh\u1eefng tr\u01b0\u1eddng h\u1ee3p c\u1ea7n g\u1ee1 b\u1ecf ch\u1ebf \u0111\u1ed9 Read Only trong file Excel<\/em><\/p>\n

    \n

    2. C\u00e1ch g\u1ee1 b\u1ecf ch\u1ebf \u0111\u1ed9 Read Only trong Excel<\/h2>\n<\/div>\n
    \n

    2.1 T\u1eaft b\u1eb1ng n\u00fat Enable Editing<\/h3>\n<\/div>\n

    Khi m\u1edf m\u1ed9t t\u1ec7p Excel v\u00e0 xu\u1ea5t hi\u1ec7n th\u00f4ng b\u00e1o y\u00eau c\u1ea7u quy\u1ec1n ch\u1ec9nh s\u1eeda, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n Enable Editing<\/strong> \u0111\u1ec3 m\u1edf kh\u00f3a ch\u1ebf \u0111\u1ed9 xem. Thao t\u00e1c n\u00e0y cho ph\u00e9p b\u1ea1n t\u1ef1 do ch\u1ec9nh s\u1eeda, c\u1eadp nh\u1eadt v\u00e0 l\u01b0u n\u1ed9i dung nh\u01b0 v\u1edbi b\u1ea5t k\u1ef3 t\u1ec7p Excel th\u00f4ng th\u01b0\u1eddng n\u00e0o.<\/p>\n

    \"N\u00fatTh\u00f4ng b\u00e1o Protected View trong Excel, nh\u1ea5n \u201cEnable Editing\u201d \u0111\u1ec3 cho ph\u00e9p ch\u1ec9nh s\u1eeda d\u1eef li\u1ec7u<\/em><\/p>\n

    \n

    2.2 T\u1eaft Protected View<\/h3>\n<\/div>\n

    B\u01b0\u1edbc 1:<\/strong> T\u1ea1i giao di\u1ec7n ch\u00ednh c\u1ee7a Excel, nh\u1ea5n v\u00e0o File<\/strong>, sau \u0111\u00f3 ch\u1ecdn Options<\/strong> \u0111\u1ec3 m\u1edf c\u1eeda s\u1ed5 thi\u1ebft l\u1eadp c\u00e1c t\u00f9y ch\u1ecdn cho ch\u01b0\u01a1ng tr\u00ecnh.<\/p>\n

    \"M\u1edfGiao di\u1ec7n m\u1ee5c File trong Excel<\/em><\/p>\n

    B\u01b0\u1edbc 2: <\/strong>Khi c\u1eeda s\u1ed5 Excel Options<\/strong> xu\u1ea5t hi\u1ec7n, ch\u1ecdn m\u1ee5c Trust Center<\/strong>, sau \u0111\u00f3 nh\u1ea5n Trust Center Settings<\/strong> v\u00e0 b\u1ea5m OK<\/strong> \u0111\u1ec3 truy c\u1eadp c\u00e1c t\u00f9y ch\u1ecdn b\u1ea3o m\u1eadt n\u00e2ng cao.<\/p>\n

    \"TruyM\u1ee5c Trust Center trong Excel Options, cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng t\u00f9y ch\u1ec9nh c\u00e0i \u0111\u1eb7t b\u1ea3o m\u1eadt<\/em><\/p>\n

    B\u01b0\u1edbc 3: <\/strong>Trong c\u1eeda s\u1ed5 Trust Center<\/strong>, ch\u1ecdn m\u1ee5c Protected View<\/strong>, sau \u0111\u00f3 b\u1ecf d\u1ea5u t\u00edch \u1edf ba t\u00f9y ch\u1ecdn li\u00ean quan \u0111\u1ebfn ch\u1ebf \u0111\u1ed9 b\u1ea3o v\u1ec7. Cu\u1ed1i c\u00f9ng, nh\u1ea5n OK<\/strong> \u0111\u1ec3 l\u01b0u l\u1ea1i thay \u0111\u1ed5i v\u00e0 ho\u00e0n t\u1ea5t thao t\u00e1c.<\/p>\n

    \"T\u1eaftTh\u1ebb Protected View trong Trust Center<\/em><\/p>\n

    Xem th\u00eam: <\/strong>Nh\u1eefng c\u00e1ch x\u1eed l\u00fd qu\u00ean m\u1eadt kh\u1ea9u file Excel c\u1ef1c k\u1ef3 \u0111\u01a1n gi\u1ea3n<\/div>\n
    \n

    2.3 T\u1eaft thu\u1ed9c t\u00ednh Read-Only c\u1ee7a File<\/h3>\n<\/div>\n

    B\u01b0\u1edbc 1:<\/strong> \u0110\u00f3ng t\u1ec7p Excel \u0111ang m\u1edf. Nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0o t\u1ec7p c\u1ea7n ch\u1ec9nh s\u1eeda, ch\u1ecdn Properties<\/strong>.<\/p>\n

    \"B\u1ecfMenu chu\u1ed9t ph\u1ea3i tr\u00ean file Excel hi\u1ec3n th\u1ecb t\u00f9y ch\u1ecdn Properties<\/em><\/p>\n

    B\u01b0\u1edbc 2:<\/strong> Trong c\u1eeda s\u1ed5 Properties<\/strong>, b\u1ecf d\u1ea5u ch\u1ecdn t\u1ea1i m\u1ee5c Read-Only<\/strong>, sau \u0111\u00f3 nh\u1ea5n OK<\/strong> \u0111\u1ec3 l\u01b0u thay \u0111\u1ed5i.<\/p>\n

    \"M\u1edfC\u1eeda s\u1ed5 Properties c\u1ee7a file Excel v\u1edbi m\u1ee5c Read-only, cho ph\u00e9p b\u1eadt ho\u1eb7c t\u1eaft ch\u1ebf \u0111\u1ed9 ch\u1ec9 \u0111\u1ecdc<\/em><\/p>\n

    \n

    2.4 Sao ch\u00e9p d\u1eef li\u1ec7u sang file m\u1edbi<\/h3>\n<\/div>\n

    B\u01b0\u1edbc 1: <\/strong>T\u1ea1i giao di\u1ec7n c\u1ee7a t\u1ec7p Excel v\u1eeba m\u1edf, nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm Ctrl + A<\/strong> \u0111\u1ec3 ch\u1ecdn to\u00e0n b\u1ed9 d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh. Nh\u1ea5n Ctrl + C<\/strong> \u0111\u1ec3 copy d\u1eef li\u1ec7u hi\u1ec7n c\u00f3 tr\u00ean file Excel \u0111ang m\u1edf.<\/p>\n

    \"Ph\u00edmT\u1ed5 h\u1ee3p ph\u00edm Ctrl + A \u0111\u1ec3 ch\u1ecdn t\u1ea5t c\u1ea3 t\u00e0i li\u1ec7u<\/em><\/p>\n

    B\u01b0\u1edbc 2:<\/strong> Ti\u1ebfp theo, nh\u1ea5n Ctrl + N<\/strong> \u0111\u1ec3 t\u1ea1o m\u1ed9t b\u1ea3ng t\u00ednh m\u1edbi.<\/p>\n

    \"Ph\u00edmT\u1ed5 h\u1ee3p ph\u00edm Ctrl + N t\u1ea1o trang t\u00ednh m\u1edbi<\/em><\/p>\n

    B\u01b0\u1edbc 3:<\/strong> Trong b\u1ea3ng t\u00ednh m\u1edbi, nh\u1ea5n Ctrl + V<\/strong> \u0111\u1ec3 d\u00e1n d\u1eef li\u1ec7u v\u1eeba sao ch\u00e9p.<\/p>\n

    \"Ph\u00edmT\u1ed5 h\u1ee3p ph\u00edm Ctrl + V \u0111\u1ec3 d\u00e1n d\u1eef li\u1ec7u<\/em><\/p>\n

    B\u01b0\u1edbc 4:<\/strong> Cu\u1ed1i c\u00f9ng, nh\u1ea5n Ctrl + S<\/strong> \u0111\u1ec3 l\u01b0u l\u1ea1i t\u1ec7p v\u1edbi t\u00ean mong mu\u1ed1n.<\/p>\n

    \"Ph\u00edmT\u1ed5 h\u1ee3p ph\u00edm Ctrl + S \u0111\u1ec3 l\u01b0u l\u1ea1i d\u1eef li\u1ec7u<\/em><\/p>\n

    \n

    2.5 T\u1ea1o b\u1ea3n sao<\/h3>\n<\/div>\n

    B\u01b0\u1edbc 1: <\/strong>Nh\u1ea5n v\u00e0o File<\/strong>, ch\u1ecdn Save As<\/strong> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i l\u01b0u t\u1ec7p, sau \u0111\u00f3 ch\u1ecdn v\u1ecb tr\u00ed mu\u1ed1n l\u01b0u b\u1ea3n sao.<\/p>\n

    \"Ch\u1ecdnM\u1edf v\u1ecb tr\u00ed l\u01b0u b\u1ea3n sao Excel tr\u00ean m\u00e1y t\u00ednh<\/em><\/p>\n

    B\u01b0\u1edbc 2:<\/strong> Khi h\u1ed9p tho\u1ea1i Save As<\/strong> xu\u1ea5t hi\u1ec7n, nh\u1ea5n v\u00e0o Tools<\/strong> \u1edf g\u00f3c d\u01b0\u1edbi c\u00f9ng b\u00ean ph\u1ea3i, r\u1ed3i ch\u1ecdn General Options<\/strong>.<\/p>\n

    \"M\u1edfT\u00f9y ch\u1ecdn General Options trong Excel<\/em><\/p>\n

    B\u01b0\u1edbc 3:<\/strong> Trong h\u1ed9p tho\u1ea1i General Options<\/strong>, b\u1ecf d\u1ea5u ch\u1ecdn t\u1ea1i m\u1ee5c Read-only recommended<\/strong>, sau \u0111\u00f3 nh\u1ea5n OK<\/strong> \u0111\u1ec3 x\u00e1c nh\u1eadn.<\/p>\n

    \"B\u1ecfC\u1eeda s\u1ed5 General Options trong Excel, hi\u1ec3n th\u1ecb t\u00f9y ch\u1ecdn b\u1ecf t\u00edch Read-only recommended<\/em><\/p>\n

    B\u01b0\u1edbc 4:<\/strong> Cu\u1ed1i c\u00f9ng, nh\u1ea5n Save<\/strong> \u0111\u1ec3 l\u01b0u l\u1ea1i t\u1ec7p. L\u00fac n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 m\u1edf v\u00e0 ch\u1ec9nh s\u1eeda n\u1ed9i dung m\u1ed9t c\u00e1ch b\u00ecnh th\u01b0\u1eddng.<\/p>\n

    \n

    3. C\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p<\/h2>\n<\/div>\n
    \n

    3.1 Excel Online c\u00f3 ch\u1ebf \u0111\u1ed9 Read-Only kh\u00f4ng?<\/h3>\n<\/div>\n

    Excel Online (Excel for the Web) v\u1eabn c\u00f3 ch\u1ebf \u0111\u1ed9 Read-Only, nh\u01b0ng trong phi\u00ean b\u1ea3n tr\u1ef1c tuy\u1ebfn, ch\u1ebf \u0111\u1ed9 n\u00e0y \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb d\u01b0\u1edbi t\u00ean \u201cCan view<\/strong>\u201d, cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng ch\u1ec9 xem m\u00e0 kh\u00f4ng th\u1ec3 ch\u1ec9nh s\u1eeda n\u1ed9i dung t\u1ec7p.<\/p>\n

    \n

    3.2 T\u1eaft \u201cEnable Editing\u201d c\u00f3 an to\u00e0n kh\u00f4ng?<\/h3>\n<\/div>\n

    Vi\u1ec7c t\u1eaft th\u00f4ng b\u00e1o \u201cEnable Editing<\/strong>\u201d ti\u1ec1m \u1ea9n r\u1ee7i ro b\u1ea3o m\u1eadt, v\u00ec c\u00f3 th\u1ec3 khi\u1ebfn m\u00e1y t\u00ednh d\u1ec5 b\u1ecb \u1ea3nh h\u01b0\u1edfng b\u1edfi c\u00e1c t\u1ec7p ch\u1ee9a m\u00e3 \u0111\u1ed9c ho\u1eb7c n\u1ed9i dung kh\u00f4ng an to\u00e0n. Do \u0111\u00f3, b\u1ea1n ch\u1ec9 n\u00ean v\u00f4 hi\u1ec7u h\u00f3a t\u00ednh n\u0103ng n\u00e0y khi th\u01b0\u1eddng xuy\u00ean l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c t\u1ec7p c\u00f3 ngu\u1ed3n g\u1ed1c tin c\u1eady v\u00e0 mu\u1ed1n b\u1ecf qua b\u01b0\u1edbc cho ph\u00e9p ch\u1ec9nh s\u1eeda m\u1ed7i l\u1ea7n m\u1edf t\u1ec7p.<\/p>\n

    Tr\u00ean \u0111\u00e2y l\u00e0 c\u00e1c c\u00e1ch g\u1ee1 b\u1ecf ch\u1ebf \u0111\u1ed9 Read Only trong Excel gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng ch\u1ec9nh s\u1eeda, l\u01b0u v\u00e0 qu\u1ea3n l\u00fd d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3 h\u01a1n. T\u00f9y t\u1eebng nguy\u00ean nh\u00e2n, b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng c\u00e1ch t\u1eaft Read Only qua Trust Center, Properties ho\u1eb7c Save As. \u0110\u1eebng qu\u00ean theo d\u00f5i chuy\u00ean m\u1ee5c Kinh nghi\u1ec7m c\u1ee7a Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 c\u1eadp nh\u1eadt th\u00eam nhi\u1ec1u m\u1eb9o h\u1eefu \u00edch kh\u00e1c.<\/p>\n

    N\u1ebfu b\u1ea1n \u0111ang t\u00ecm chu\u1ed9t, b\u00e0n ph\u00edm hay c\u00e1c ph\u1ee5 ki\u1ec7n vi t\u00ednh gi\u00fap thao t\u00e1c Excel m\u01b0\u1ee3t m\u00e0 h\u01a1n, h\u00e3y gh\u00e9 Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn. Nhi\u1ec1u m\u1eabu ph\u1ee5 ki\u1ec7n ch\u00ednh h\u00e3ng, b\u1ec1n b\u1ec9 v\u00e0 gi\u00e1 t\u1ed1t s\u1ebd h\u1ed7 tr\u1ee3 b\u1ea1n l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 m\u1ed7i ng\u00e0y.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

    \u00a0 Khi m\u1edf file Excel v\u00e0 th\u1ea5y th\u00f4ng b\u00e1o \u201cRead Only\u201d, b\u1ea1n s\u1ebd kh\u00f4ng th\u1ec3 ch\u1ec9nh s\u1eeda hay l\u01b0u thay \u0111\u1ed5i trong t\u00e0i li\u1ec7u. T\u00ecnh tr\u1ea1ng n\u00e0y th\u01b0\u1eddng x\u1ea3y ra khi file \u0111\u01b0\u1ee3c t\u1ea3i t\u1eeb Internet, chia s\u1ebb qua m\u1ea1ng n\u1ed9i b\u1ed9 ho\u1eb7c c\u00e0i \u0111\u1eb7t ph\u00e2n quy\u1ec1n b\u1ea3o m\u1eadt. C\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch g\u1ee1 b\u1ecf […]<\/p>\n","protected":false},"author":1,"featured_media":4400,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-4399","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat"],"jetpack_featured_media_url":"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/19254.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4399","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/comments?post=4399"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4399\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/4400"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=4399"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=4399"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=4399"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}