{"id":279577,"date":"2023-11-04T12:13:56","date_gmt":"2023-11-04T05:13:56","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=279577"},"modified":"2023-11-04T12:13:56","modified_gmt":"2023-11-04T05:13:56","slug":"cach-xoa-dong-ke-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-xoa-dong-ke-trong-excel\/","title":{"rendered":"C\u00e1ch x\u00f3a d\u00f2ng k\u1ebb trong Excel \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng"},"content":{"rendered":"

Grindlines c\u00f2n \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 d\u00f2ng k\u1ebb, \u0111\u01b0\u1eddng l\u01b0\u1edbi, \u0111\u01b0\u1eddng k\u1ebb. Ch\u00fang l\u00e0 nh\u1eefng \u0111\u01b0\u1eddng m\u1edd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb theo m\u1eb7c \u0111\u1ecbnh trong Microsoft Excel. B\u1ea1n c\u00f3 th\u1ec3 b\u1eadt, \u1ea9n hay x\u00f3a ch\u00fang trong b\u1ea3ng t\u00ednh v\u00e0 th\u1eadm ch\u00ed ch\u1ecdn xem ch\u00fang tr\u00ean c\u00e1c trang in. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch x\u00f3a d\u00f2ng k\u1ebb trong Excel \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng.<\/p>\n

Gridlines l\u00e0 g\u00ec?<\/h2>\n

Gridlines trong Microsoft Excel l\u00e0 nh\u1eefng d\u00f2ng k\u1ebb nh\u1ecf. Ch\u00fang th\u01b0\u1eddng c\u00f3 m\u00e0u x\u00e1m nh\u1ea1t, t\u1ea1o th\u00e0nh m\u1ed9t h\u1ec7 th\u1ed1ng l\u01b0\u1edbi chia c\u00e1ch \u00f4, h\u00e0ng, c\u1ed9t trong b\u1ea3ng t\u00ednh. Gridlines kh\u00f4ng ch\u1ec9 l\u00e0 c\u00e1c \u0111\u01b0\u1eddng k\u1ebb \u0111\u01a1n thu\u1ea7n. Ch\u00fang l\u00e0 h\u1ec7 th\u1ed1ng th\u1ecb gi\u00e1c quan tr\u1ecdng trong Excel, gi\u00fap ng\u01b0\u1eddi d\u00f9ng qu\u1ea3n l\u00fd v\u00e0 l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. B\u1eb1ng c\u00e1ch ph\u00e2n chia \u00f4, h\u00e0ng v\u00e0 c\u1ed9t th\u00e0nh c\u00e1c ph\u1ea7n nh\u1ecf h\u01a1n, Gridlines gi\u00fap b\u1ea1n x\u00e1c \u0111\u1ecbnh r\u00f5 r\u00e0ng bi\u00ean gi\u1edbi c\u1ee7a m\u1ed7i \u00f4 v\u00e0 kho\u1ea3ng c\u00e1ch gi\u1eefa ch\u00fang. Nh\u1edd \u0111\u00f3, ch\u00fang l\u00e0m cho b\u1ea3ng t\u00ednh tr\u1edf n\u00ean d\u1ec5 \u0111\u1ecdc h\u01a1n.<\/p>\n

H\u01a1n n\u1eefa, Gridlines l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh gi\u00fap trong vi\u1ec7c c\u0103n ch\u1ec9nh. N\u00f3 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed v\u00e0 k\u00edch th\u01b0\u1edbc c\u1ee7a c\u00e1c \u00f4 v\u00e0 d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh. Ch\u00fang gi\u00fap b\u1ea1n quan s\u00e1t, x\u00e1c \u0111\u1ecbnh v\u00e0 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u ch\u00ednh x\u00e1c. \u0110\u1ed3ng th\u1eddi n\u00f3 t\u1ea1o s\u1ef1 \u0111\u1ed3ng nh\u1ea5t v\u00e0 c\u00e2n \u0111\u1ed1i trong thi\u1ebft k\u1ebf c\u1ee7a b\u1ea3ng t\u00ednh.<\/p>\n

\"cach-xoa-dong-ke-trong-excel-1\"<\/picture>
Gridlines trong Microsoft Excel l\u00e0 nh\u1eefng d\u00f2ng k\u1ebb nh\u1ecf, th\u01b0\u1eddng c\u00f3 m\u00e0u x\u00e1m nh\u1ea1t<\/figcaption><\/figure>\n

T\u00f9y ch\u1ec9nh Gridlines l\u00e0 m\u1ed9t ph\u1ea7n quan tr\u1ecdng trong quy tr\u00ecnh thi\u1ebft k\u1ebf b\u1ea3ng t\u00ednh. B\u1ea1n c\u00f3 c\u00e1ch b\u1eadt, \u1ea9n v\u00e0 x\u00f3a d\u00f2ng k\u1ebb trong Excel theo \u00fd mu\u1ed1n. \u0110i\u1ec1u n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi b\u1ea1n mu\u1ed1n in b\u1ea3ng t\u00ednh v\u00e0 mu\u1ed1n \u1ea9n gridlines \u0111\u1ec3 l\u00e0m cho b\u1ea3n in tr\u00f4ng chuy\u00ean nghi\u1ec7p h\u01a1n. V\u00ec v\u1eady, Gridlines kh\u00f4ng ch\u1ec9 l\u00e0 m\u1ed9t ph\u1ea7n giao di\u1ec7n. Ch\u00fang c\u00f2n l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 quan tr\u1ecdng gi\u00fap b\u1ea1n t\u1ea1o v\u00e0 qu\u1ea3n l\u00fd b\u1ea3ng t\u00ednh chuy\u00ean nghi\u1ec7p.<\/p>\n

C\u00e1ch x\u00f3a d\u00f2ng k\u1ebb trong Excel<\/h2>\n

Khi m\u1edf t\u00e0i li\u1ec7u Excel, b\u1ea1n c\u00f3 th\u1ec3 nh\u00ecn th\u1ea5y Gridlines nh\u01b0 m\u1eb7c \u0111\u1ecbnh. N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ec3 b\u1ea3ng t\u00ednh tr\u00f4ng d\u1ec5 tr\u00ecnh b\u00e0y h\u01a1n n\u1ebfu kh\u00f4ng c\u00f3 ch\u00fang, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m \u1ea9n c\u00e1c \u0111\u01b0\u1eddng k\u1ebb. B\u1ea1n c\u00f3 m\u1ed9t s\u1ed1 c\u00e1ch \u0111\u1ec3 \u1ea9n d\u00f2ng k\u1ebb trong Excel nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n

S\u1eed d\u1ee5ng t\u00ednh n\u0103ng No Borders \u0111\u1ec3 x\u00f3a Gridlines<\/h3>\n

C\u00f3 c\u00e1ch x\u00f3a d\u00f2ng k\u1ebb trong Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng t\u00f9y ch\u1ecdn \u201cNo Border\u201d. C\u00e1c b\u01b0\u1edbc \u0111\u1ec3 x\u00f3a d\u00f2ng k\u1ebb nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n

B\u01b0\u1edbc 1: Tr\u01b0\u1edbc ti\u00ean, m\u1edf t\u1ec7p Excel m\u00e0 b\u1ea1n mu\u1ed1n thao t\u00e1c. Trong t\u1ec7p n\u00e0y, h\u00e3y ch\u1ecdn sheet m\u00e0 b\u1ea1n mu\u1ed1n ch\u1ec9nh s\u1eeda.<\/p>\n

B\u01b0\u1edbc 2: Ti\u1ebfp theo, h\u00e3y ch\u1ecdn c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n x\u00f3a gridlines. N\u1ebfu b\u1ea1n mu\u1ed1n x\u00f3a gridlines t\u1eeb to\u00e0n b\u1ed9 sheet, h\u00e3y ch\u1ecdn to\u00e0n \u1edf ph\u00eda g\u00f3c tr\u00e1i trang t\u00ednh.<\/p>\n

B\u01b0\u1edbc 3: Sau khi \u0111\u00e3 ch\u1ecdn, h\u00e3y nh\u00ecn l\u00ean ph\u00eda tr\u00ean v\u00e0 t\u00ecm \u0111\u1ebfn tab Home tr\u00ean Ribbon. Trong nh\u00f3m Font tr\u00ean tab Home, b\u1ea1n s\u1ebd th\u1ea5y m\u1ed9t n\u00fat c\u00f3 bi\u1ec3u t\u01b0\u1ee3ng l\u01b0\u1edbi ho\u1eb7c l\u01b0\u1edbi \u00f4 vu\u00f4ng. H\u00e3y nh\u1ea5p v\u00e0o n\u00fat n\u00e0y.<\/p>\n

B\u01b0\u1edbc 4: Khi b\u1ea1n nh\u1ea5p v\u00e0o n\u00fat n\u00e0y, m\u1ed9t menu th\u1ea3 xu\u1ed1ng s\u1ebd xu\u1ea5t hi\u1ec7n. Trong menu th\u1ea3 xu\u1ed1ng n\u00e0y, h\u00e3y ch\u1ecdn \u201cNo Border\u201d. Khi b\u1ea1n ch\u1ecdn No Border, gridlines s\u1ebd \u0111\u01b0\u1ee3c x\u00f3a kh\u1ecfi c\u00e1c \u00f4 m\u00e0 b\u1ea1n \u0111\u00e3 ch\u1ecdn tr\u01b0\u1edbc \u0111\u00f3.<\/p>\n

\"cach-xoa-dong-ke-trong-excel-2\"<\/picture>
Ch\u1ecdn No Border t\u1eeb tab Home tr\u00ean Ribbon<\/figcaption><\/figure>\n

N\u1ebfu b\u1ea1n mu\u1ed1n t\u00f9y ch\u1ec9nh d\u00f2ng k\u1ebb k\u1ef9 h\u01a1n, h\u00e3y ch\u1ecdn More Border. Sau \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh v\u1ecb tr\u00ed, m\u00e0u s\u1eafc, \u0111\u1ed9 \u0111\u1eadm nh\u1ea1t hay h\u00ecnh d\u1ea1ng d\u00f2ng k\u1ebb. Xin l\u01b0u \u00fd c\u00e1ch n\u00e0y ch\u1ec9 x\u00f3a trong ph\u1ea1m vi c\u00e1c \u00f4 \u0111\u00e3 ch\u1ecdn. N\u1ebfu b\u1ea1n mu\u1ed1n \u1ea9n d\u00f2ng k\u1ebb cho t\u1ea5t c\u1ea3 c\u00e1c trang t\u00ednh, b\u1ea1n s\u1ebd c\u1ea7n l\u1eb7p l\u1ea1i c\u00e1c b\u01b0\u1edbc n\u00e0y cho m\u1ed7i sheet.<\/p>\n

\"cach-xoa-dong-ke-trong-excel-3\"<\/picture>
N\u1ebfu b\u1ea1n mu\u1ed1n t\u00f9y ch\u1ec9nh d\u00f2ng k\u1ebb k\u1ef9 h\u01a1n, h\u00e3y ch\u1ecdn More Border<\/figcaption><\/figure>\n

C\u00e1ch x\u00f3a d\u00f2ng k\u1ebb trong Excel b\u1eb1ng \u0111\u1ed5i m\u00e0u ch\u00fang<\/h3>\n

B\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i m\u00e0u c\u1ee7a Gridlines trong Microsoft Excel. \u0110\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9nh theo c\u00e1c b\u01b0\u1edbc chi ti\u1ebft d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

B\u01b0\u1edbc 1: M\u1edf t\u1ec7p Excel v\u00e0 ch\u1ecdn t\u1edd c\u00f4ng vi\u1ec7c b\u1ea1n mu\u1ed1n ch\u1ec9nh s\u1eeda.\u00a0Ti\u1ebfp theo, \u0111\u1ea3m b\u1ea3o b\u1ea1n \u0111\u00e3 ch\u1ecdnsheet ch\u1ee9a b\u1ea3ng t\u00ednh m\u00e0 b\u1ea1n mu\u1ed1n t\u00f9y ch\u1ec9nh Gridlines.<\/p>\n

B\u01b0\u1edbc 2: Nh\u1ea5p v\u00e0o tab File, n\u1eb1m \u1edf ph\u00eda b\u00ean tr\u00e1i tr\u00ean c\u00f9ng worksheet. T\u1ea1i \u0111\u00e2y, b\u1ea1n s\u1ebd th\u1ea5y m\u1ed9t lo\u1ea1t t\u00f9y ch\u1ecdn cho t\u1ec7p c\u1ee7a b\u1ea1n.<\/p>\n

B\u01b0\u1edbc 3: Trong menu t\u00f9y ch\u1ecdn, b\u1ea1n s\u1ebd th\u1ea5y t\u00f9y ch\u1ecdn Options \u1edf ph\u00eda d\u01b0\u1edbi. Nh\u1ea5p v\u00e0o n\u00f3 \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i t\u00f9y ch\u1ecdn Excel.<\/p>\n

\"cach-xoa-dong-ke-trong-excel-4\"<\/picture>
Nh\u1ea5p v\u00e0o tab File > ch\u1ecdn Options<\/figcaption><\/figure>\n

B\u01b0\u1edbc 4: Truy c\u1eadp t\u00f9y ch\u1ecdn Advanced. Cu\u1ed9n xu\u1ed1ng cho \u0111\u1ebfn khi b\u1ea1n th\u1ea5y ph\u1ea7n Display options for this worksheet. Trong ph\u1ea7n n\u00e0y, b\u1ea1n s\u1ebd th\u1ea5y t\u00f9y ch\u1ecdn “Gridline color”.<\/p>\n

B\u01b0\u1edbc 6: Nh\u1ea5p v\u00e0o \u00f4 b\u00ean c\u1ea1nh “Gridline color” \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i ch\u1ecdn m\u00e0u. T\u1ea1i \u0111\u00e2y, b\u1ea1n c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn m\u00e0u t\u1eeb b\u1ea3ng m\u00e0u ho\u1eb7c t\u00f9y ch\u1ec9nh m\u00e0u d\u1ef1a tr\u00ean m\u00e3 m\u00e0u RGB ho\u1eb7c HSL.<\/p>\n

B\u01b0\u1edbc 7: Sau khi b\u1ea1n \u0111\u00e3 ch\u1ecdn m\u00e0u m\u1edbi, h\u00e3y nh\u1ea5p OK \u0111\u1ec3 l\u01b0u c\u00e1c thay \u0111\u1ed5i v\u00e0 \u0111\u00f3ng h\u1ed9p tho\u1ea1i.\u00a0M\u00e0u c\u1ee7a Gridlines s\u1ebd thay \u0111\u1ed5i theo m\u00e0u b\u1ea1n \u0111\u00e3 ch\u1ecdn. N\u00f3 gi\u00fap d\u00f2ng k\u1ebb tr\u1edf n\u00ean ‘v\u00f4 h\u00ecnh’ theo \u00fd mu\u1ed1n.<\/p>\n

\"cach-xoa-dong-ke-trong-excel-5\"<\/picture>
Ch\u1ecdn m\u00e0u cho Gridlines \u0111\u1ec3 ch\u00fang “v\u00f4 h\u00ecnh”<\/figcaption><\/figure>\n

C\u00e1c b\u01b0\u1edbc tr\u00ean ch\u1ec9 \u00e1p d\u1ee5ng cho b\u1ea3ng t\u00ednh Excel hi\u1ec7n t\u1ea1i. C\u00e1ch n\u00e0y kh\u00f4ng \u00e1p d\u1ee5ng cho to\u00e0n b\u1ed9 s\u1ed5 l\u00e0m vi\u1ec7c. N\u1ebfu mu\u1ed1n thay \u0111\u1ed5i m\u00e0u cho t\u1ea5t c\u1ea3 c\u00e1c trang t\u00ednh, b\u1ea1n ph\u1ea3i nh\u00f3m c\u00e1c trang t\u00ednh l\u1ea1i b\u1eb1ng c\u00e1ch gi\u1eef ph\u00edm \u201cCtrl\u201d v\u00e0 ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c tab. K\u1ebf \u0111\u1ebfn b\u1ea1n thay \u0111\u1ed5i m\u00e0u h\u00e0ng lo\u1ea1t trong khi c\u00e1c trang t\u00ednh \u1edf ch\u1ebf \u0111\u1ed9 nh\u00f3m. Sau khi b\u1ea1n th\u1ef1c hi\u1ec7n xong c\u00e1c thay \u0111\u1ed5i, h\u00e3y nh\u1edb Ungroup ch\u00fang.<\/p>\n

C\u00e1ch x\u00f3a d\u00f2ng k\u1ebb trong Excel t\u1eeb tab View<\/h3>\n

B\u1ea1n v\u1eabn c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh hi\u1ec3n th\u1ecb c\u1ee7a gridlines t\u1eeb tab View. C\u00e1ch n\u00e0y \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n kh\u00e1 nhanh g\u1ecdn v\u00e0 d\u1ec5 d\u00e0ng. Quy tr\u00ecnh \u0111\u1ec3 \u1ea9n d\u00f2ng k\u1ebb tu\u1ea7n t\u1ef1 theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n

B\u01b0\u1edbc 1: M\u1edf t\u1ec7p Excel v\u00e0 \u0111i\u1ec1u h\u01b0\u1edbng \u0111\u1ebfn sheet mu\u1ed1n t\u00f9y ch\u1ec9nh.<\/p>\n

B\u01b0\u1edbc 2:\u00a0T\u00ecm v\u00e0 nh\u1ea5p v\u00e0o tab View. N\u00f3 th\u01b0\u1eddng n\u1eb1m \u1edf v\u1ecb tr\u00ed gi\u1eefa c\u00e1c tab Formulas v\u00e0 Review tr\u00ean thanh Ribbon. Tab View ch\u1ee9a c\u00e1c t\u00f9y ch\u1ecdn li\u00ean quan \u0111\u1ebfn c\u00e1ch b\u1ea3ng t\u00ednh.<\/p>\n

B\u01b0\u1edbc 3:\u00a0Trong nh\u00f3m Show, b\u1ea1n s\u1ebd th\u1ea5y m\u1ed9t t\u00f9y ch\u1ecdn c\u00f3 t\u00ean Gridlines. H\u00e3y b\u1ecf ch\u1ecdn \u1edf h\u1ed9p ki\u1ec3m b\u00ean c\u1ea1nh n\u00f3. Nh\u01b0 v\u1eady c\u00e1c d\u00f2ng k\u1ebb \u0111\u00e3 \u0111\u01b0\u1ee3c x\u00f3a kh\u1ecfi trang t\u00ednh.<\/p>\n

\"cach-xoa-dong-ke-trong-excel-6\"<\/picture>
C\u00e1ch x\u00f3a Gridlines trong Excel t\u1eeb tab View<\/figcaption><\/figure>\n

C\u00e1c b\u01b0\u1edbc cho ph\u00e9p b\u1ea1n \u0111i\u1ec1u ch\u1ec9nh c\u00e1ch gridlines xu\u1ea5t hi\u1ec7n theo \u00fd mu\u1ed1n. N\u1ebfu b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i tr\u1ea1ng th\u00e1i c\u1ee7a gridlines, b\u1ea1n ch\u1ec9 c\u1ea7n tr\u1edf l\u1ea1i tab View v\u00e0 b\u1eadt ch\u1ecdn nh\u01b0 c\u0169.<\/p>\n

S\u1eed d\u1ee5ng ph\u00edm t\u1eaft \u0111\u1ec3 \u1ea9n d\u00f2ng k\u1ebb<\/h3>\n

N\u1ebfu b\u1ea1n \u0111ang s\u1eed d\u1ee5ng h\u1ec7 \u0111i\u1ec1u h\u00e0nh Windows v\u00e0 mu\u1ed1n \u1ea9n nhanh gridlines, c\u00f3 c\u00e1ch x\u00f3a d\u00f2ng k\u1ebb trong Excel b\u1eb1ng ph\u00edm t\u1eaft v\u00f4 c\u00f9ng ti\u1ec7n l\u1ee3i. H\u00e3y th\u1ef1c hi\u1ec7n theo gi\u1ea3i th\u00edch chi ti\u1ebft d\u01b0\u1edbi \u0111\u00e2y nh\u00e9.<\/p>\n

B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, m\u1edf file Excel v\u00e0 \u0111i \u0111\u1ebfn sheet m\u00e0 b\u1ea1n mu\u1ed1n \u1ea9n gridlines.<\/p>\n

B\u01b0\u1edbc 2: Sau \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u00edm t\u1eaft Alt + W + V + G. \u0110\u00e2y l\u00e0 m\u1ed9t chu\u1ed7i c\u00e1c ph\u00edm. V\u00ec v\u1eady h\u00e3y nh\u1ea5n ch\u00fang theo th\u1ee9 t\u1ef1: tr\u01b0\u1edbc ti\u00ean l\u00e0 Alt, sau \u0111\u00f3 W, sau \u0111\u00f3 V, v\u00e0 cu\u1ed1i c\u00f9ng l\u00e0 G.<\/p>\n

B\u01b0\u1edbc 3: Sau khi nh\u1ea5n chu\u1ed7i ph\u00edm n\u00e0y, b\u1ea1n s\u1ebd th\u1ea5y r\u1eb1ng gridlines \u0111\u00e3 bi\u1ebfn m\u1ea5t kh\u1ecfi b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n.<\/p>\n

\"cach-xoa-dong-ke-trong-excel-7\"<\/picture>
S\u1eed d\u1ee5ng ph\u00edm t\u1eaft Alt + W + V + G \u0111\u1ec3 x\u00f3a Gridlines<\/figcaption><\/figure>\n

Ph\u00edm t\u1eaft n\u00e0y l\u00e0 m\u1ed9t ch\u1ee9c n\u0103ng chuy\u1ec3n \u0111\u1ed5i. \u0110i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0 n\u00f3 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u1ea9n v\u00e0 hi\u1ec3n th\u1ecb gridlines. N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u01b0a gridlines tr\u1edf l\u1ea1i, ch\u1ec9 c\u1ea7n nh\u1ea5n l\u1ea1i c\u00f9ng m\u1ed9t chu\u1ed7i ph\u00edm: Alt + W + V + G. Chu\u1ed7i c\u00e1c ph\u00edm t\u1eaft nh\u01b0 ph\u00edm t\u1eaft n\u00e0y c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian \u0111\u00e1ng k\u1ec3. Ngo\u00e0i ra, n\u00f3 c\u0169ng h\u1ea1n ch\u1ebf thao t\u00e1c ph\u1ea3i s\u1eed d\u1ee5ng chu\u1ed9t v\u00e0 \u0111i\u1ec1u h\u01b0\u1edbng menu.<\/p>\n

C\u00e1ch x\u00f3a d\u00f2ng k\u1ebb trong Excel b\u1eb1ng Page Layout<\/h3>\n

Gridlines tr\u00f4ng tuy\u1ec7t v\u1eddi tr\u00ean m\u00e0n h\u00ecnh. N\u00f3 l\u00e0m cho vi\u1ec7c t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u d\u1ec5 d\u00e0ng h\u01a1n. Nh\u01b0ng khi in tr\u00ean gi\u1ea5y, n\u00f3 l\u1ea1i g\u00e2y kh\u00f3 nh\u00ecn t\u00e0i li\u1ec7u h\u01a1n. May m\u1eafn thay, c\u00f3 m\u1ed9t c\u00e1ch d\u00f2ng k\u1ebb trong Excel cho vi\u1ec7c in \u1ea5n. N\u00f3 s\u1ebd \u00e1p d\u1ee5ng hi\u1ec7u qu\u1ea3 v\u1edbi c\u00e1c t\u00e0i li\u1ec7u sau khi \u0111\u01b0\u1ee3c in ra.<\/p>\n

B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, h\u00e3y m\u1edf t\u1ec7p Excel b\u1ea1n d\u1ef1 \u0111\u1ecbnh in. Trong t\u1ec7p n\u00e0y, h\u00e3y ch\u1ecdn sheet m\u00e0 b\u1ea1n mu\u1ed1n ch\u1ec9nh s\u1eeda.<\/p>\n

B\u01b0\u1edbc 2: Ti\u1ebfp theo, h\u00e3y nh\u00ecn l\u00ean ph\u00eda tr\u00ean v\u00e0 t\u00ecm \u0111\u1ebfn tab Page Layout tr\u00ean Ribbon. Tr\u00ean tab Page Layout, b\u1ea1n s\u1ebd th\u1ea5y m\u1ed9t ph\u1ea7n c\u00f3 t\u00ean l\u00e0 Sheet Options.<\/p>\n

B\u01b0\u1edbc 3: Trong ph\u1ea7n Sheet Options, h\u00e3y t\u00ecm \u0111\u1ebfn m\u1ee5c Gridlines. D\u01b0\u1edbi m\u1ee5c Gridlines, b\u1ea1n s\u1ebd th\u1ea5y m\u1ed9t t\u00f9y ch\u1ecdn c\u00f3 t\u00ean l\u00e0 Print. H\u00e3y b\u1ecf ch\u1ecdn t\u00f9y ch\u1ecdn n\u00e0y. Khi b\u1ea1n b\u1ecf ch\u1ecdn t\u00f9y ch\u1ecdn Print, gridlines s\u1ebd \u0111\u01b0\u1ee3c \u1ea9n khi b\u1ea1n in b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh.<\/p>\n

\"cach-xoa-dong-ke-trong-excel-8\"<\/picture>
\u1ea8n d\u00f2ng k\u1ebb khi in \u1ea5n trong Excel t\u1eeb Page Layout<\/figcaption><\/figure>\n

Ngo\u00e0i ra, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 \u1ea9n gridlines khi in ho\u1eb7c l\u01b0u d\u01b0\u1edbi d\u1ea1ng PDF b\u1eb1ng c\u00e1ch ch\u1ecdn File > Print > Sheet options > Gridlines. Sau \u0111\u00f3, b\u1ea1n b\u1ecf ch\u1ecdn n\u00f3.<\/p>\n

Xin l\u01b0u \u00fd r\u1eb1ng theo m\u1eb7c \u0111\u1ecbnh, gridlines s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c in ra. N\u1ebfu b\u1ea1n mu\u1ed1n in gridlines, h\u00e3y \u0111\u1ea3m b\u1ea3o r\u1eb1ng t\u00f9y ch\u1ecdn Print d\u01b0\u1edbi m\u1ee5c Gridlines.<\/p>\n

S\u1eed d\u1ee5ng VBA Macro \u0111\u1ec3 x\u00f3a Gridlines<\/h3>\n

N\u1ebfu b\u1ea1n l\u00e0 ng\u01b0\u1eddi s\u1eed d\u1ee5ng \u0111\u00e3 quen v\u1edbi Visual Basic for Applications (VBA), b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u00e3 VBA \u0111\u1ec3 t\u1eaft Gridlines. C\u00e1ch x\u00f3a d\u00f2ng k\u1ebb trong Excel n\u00e0y tuy h\u01a1i c\u1ea7u k\u1ef3 nh\u01b0ng l\u1ea1i kh\u00f4ng \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn vi\u1ec7c in \u1ea5n. H\u00e3y l\u00e0m theo c\u00e1c b\u01b0\u1edbc \u1edf d\u01b0\u1edbi \u0111\u1ec3 th\u1ef1c hi\u1ec7n m\u00e3 VBA n\u00e0y:<\/p>\n

B\u01b0\u1edbc 1: M\u1edf t\u1ec7p Excel m\u00e0 b\u1ea1n mu\u1ed1n x\u00f3a Gridlines. Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o sheet b\u1ea1n c\u1ea7n x\u00f3a d\u00f2ng k\u1ebb \u1edf d\u01b0\u1edbi c\u00f9ng c\u1ee7a c\u1eeda s\u1ed5 Excel. K\u1ebf \u0111\u1ebfn ch\u1ecdn View Code. C\u00e1ch kh\u00e1c \u0111\u1ec3 ch\u1ea1y m\u00e3 l\u00e0 nh\u1ea5n t\u1ed5 h\u1ee3p Alt + F11 khi \u0111ang \u1edf trong b\u1ea3ng t\u00ednh. Ho\u1eb7c l\u00e0 b\u1ea1n \u0111i \u0111\u1ebfn tab Developer > ch\u1ecdn Visual Basic.<\/p>\n

\"cach-xoa-dong-ke-trong-excel-9\"<\/picture>
Ch\u1ea1y m\u00e3 b\u1eb1ng c\u00e1ch nh\u1ea5n t\u1ed5 h\u1ee3p Alt + F11<\/figcaption><\/figure>\n

B\u01b0\u1edbc 2:\u00a0Trong c\u1eeda s\u1ed5 so\u1ea1n th\u1ea3o m\u00e3 VBA, nh\u1ea5n Insert > Module \u0111\u1ec3 ch\u00e8n m\u00e3.<\/p>\n

B\u01b0\u1edbc 3: Sao ch\u00e9p v\u00e0 d\u00e1n m\u00e3 VBA v\u00e0o m\u00f4-\u0111un. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t v\u00ed d\u1ee5 \u0111\u1ec3 x\u00f3a trong sheet \u0111ang m\u1edf.<\/p>\n

Sub<\/span> Remove_Gridlines_Active_Sheet(<\/span>)<\/span>\r\n\r\nActiveWindow.<\/span>DisplayGridlines =<\/span> False<\/span>\r\n\r\nEnd<\/span> Sub<\/span><\/code><\/em><\/pre>\n
N\u1ebfu mu\u1ed1n x\u00f3a t\u1eeb sheet b\u1ea5t k\u1ef3, b\u1ea1n s\u1ebd d\u00f9ng m\u00e3 code sau:<\/p>\n
Sub<\/span> Hide_Gridlines_Specific_Sheet(<\/span>)<\/span>\r\n\r\nDim<\/span> xSheet As<\/span> Worksheet\r\nSet<\/span> xSheet =<\/span> Worksheets(<\/span>\"sSheet\"<\/span>)<\/span>\r\n'Gridlines in \"sSheet\" will be hidden<\/span>\r\n\r\nxSheet.<\/span>Activate\r\nActiveWindow.<\/span>DisplayGridlines =<\/span> False<\/span>\r\n\r\nEnd<\/span> Sub<\/span><\/code><\/em><\/pre>\n
B\u01b0\u1edbc 4: \u0110\u00f3ng tr\u00ecnh so\u1ea1n th\u1ea3o VBA. B\u00e2y gi\u1edd b\u1ea1n c\u00f3 th\u1ec3 ch\u1ea1y m\u00e3 VBA b\u1eb1ng c\u00e1ch nh\u1ea5p n\u00fat Macros trong tab Developer. B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 nh\u1ea5n t\u1ed5 h\u1ee3p ALT + F8. K\u1ebf \u0111\u1ebfn ch\u1ecdn HideGridlines v\u00e0 nh\u1ea5p v\u00e0o Run.<\/p>\n
\"cach-xoa-dong-ke-trong-excel-10\"<\/picture>
Nh\u1eadp m\u00e3 v\u00e0 ch\u1ea1y cho worksheet<\/figcaption><\/figure>\n
B\u1ea1n c\u00f3 th\u1ec3 sao ch\u00e9p m\u00e3 tr\u00ean v\u00e0 ch\u1ea1y n\u00f3 trong m\u00f4i tr\u01b0\u1eddng VBA c\u1ee7a Excel. C\u00e1ch x\u00f3a n\u00e0y s\u1ebd t\u1eaft ch\u00fang cho c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c hi\u1ec7n t\u1ea1i. D\u00f9 v\u1eady, VBA ch\u1ec9 thay \u0111\u1ed5i c\u00e1ch hi\u1ec3n th\u1ecb gridlines tr\u00ean m\u00e0n h\u00ecnh. N\u00f3 kh\u00f4ng \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn vi\u1ec7c in b\u1ea3n gi\u1ea5y. \u0110i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0 n\u1ebfu b\u1ea1n mu\u1ed1n \u1ea9n gridlines khi in t\u00e0i li\u1ec7u, b\u1ea1n s\u1ebd c\u1ea7n s\u1eed d\u1ee5ng c\u00e1c t\u00f9y ch\u1ecdn in \u1ea5n kh\u00e1c.<\/p>\n
K\u1ebft lu\u1eadn<\/h2>\n
B\u1ea1n \u0111\u00e3 th\u1ea5y c\u00f3 nhi\u1ec1u c\u00e1ch x\u00f3a d\u00f2ng k\u1ebb trong Excel kh\u00e1c nhau. B\u1ea1n ch\u1ec9 c\u1ea7n ch\u1ecdn m\u1ed9t trong nh\u1eefng c\u00e1ch ph\u00f9 h\u1ee3p nh\u1ea5t v\u1edbi b\u1ea1n l\u00e0 \u0111\u01b0\u1ee3c. C\u1ea7n l\u01b0u \u00fd r\u1eb1ng Gridlines lu\u00f4n \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng cho to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh ho\u1eb7c workbook v\u00e0 n\u00f3 kh\u00f4ng th\u1ec3 \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng cho c\u00e1c \u00f4 ho\u1eb7c ph\u1ea1m vi c\u1ee5 th\u1ec3. N\u1ebfu b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng \u0111\u01b0\u1eddng k\u1ebb c\u00f3 ch\u1ee7 \u0111\u00edch, b\u1ea1n n\u00ean s\u1eed d\u1ee5ng Border thay v\u00ec Gridlines m\u1eb7c \u0111\u1ecbnh.<\/p>\n
\u0110\u1eebng qu\u00ean kh\u00e1m ph\u00e1 th\u00eam c\u00e1c m\u1eb9o v\u1eb7t Excel h\u1eefu \u00edch kh\u00e1c \u1edf d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n