{"id":8703,"date":"2021-08-24T16:35:05","date_gmt":"2021-08-24T09:35:05","guid":{"rendered":"https:\/\/tct.vn\/blog\/?p=8703"},"modified":"2021-08-24T16:35:05","modified_gmt":"2021-08-24T09:35:05","slug":"cach-danh-dau-mu-trong-excel","status":"publish","type":"post","link":"https:\/\/tct.vn\/blog\/cach-danh-dau-mu-trong-excel\/","title":{"rendered":"C\u00e1ch \u0111\u00e1nh d\u1ea5u m\u0169 trong Excel"},"content":{"rendered":"

1. S\u1eed d\u1ee5ng ph\u00edm t\u1eaft vi\u1ebft d\u1ea5u m\u0169 trong Excel (Ch\u1ec9 s\u1ed1 tr\u00ean)<\/strong><\/em><\/h3>\n

\u0110\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c \u0111\u00e1nh s\u1ed1 m\u0169 (ch\u1ec9 s\u1ed1 tr\u00ean) trong trang t\u00ednh Excel, b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc nh\u01b0 sau:<\/p>\n

– B\u01b0\u1edbc 1: D\u00f9ng chu\u1ed9t m\u1edf trang t\u00ednh\u00a0Excel\u00a0c\u1ea7n s\u1eeda, sau \u0111\u00f3 th\u1ef1c hi\u1ec7n thao t\u00e1c nh\u1eadp nh\u1eefng d\u1eef li\u1ec7u c\u1ea7n thi\u1ebft.<\/p>\n

V\u00ed d\u1ee5: H\u00ecnh minh h\u1ecda ph\u00eda d\u01b0\u1edbi, Unica s\u1ebd vi\u1ebft X2 v\u1edbi s\u1ed1 2 l\u00e0 s\u1ed1 m\u0169.<\/p>\n

\"c\u00e1ch<\/p>\n

– B\u01b0\u1edbc 2: \u1ede d\u00f2ng c\u1ea7n vi\u1ebft d\u1ea5u m\u0169, b\u1ea1n nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm\u00a0Ctrl +1 -> Alt +E -> Enter.<\/em><\/strong><\/p>\n

Trong \u0111\u00f3, c\u00e1c ph\u00edm th\u1ec3 hi\u1ec7n c\u00e1c n\u1ed9i dung nh\u01b0 sau:<\/p>\n

Ctrl +1 :<\/strong>\u00a0Thao t\u00e1c \u0111\u1ec3 m\u1edf b\u1ea3ng Format Cells<\/p>\n

Alt +E :<\/strong>Thao t\u00e1c \u0111\u1ec3 ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng s\u1ed1 m\u0169<\/p>\n

Enter:<\/strong>Thao t\u00e1c ch\u1ea5p nh\u1eadn l\u1ec7nh v\u00e0 th\u1ef1c hi\u1ec7n \u0111\u00f3ng b\u1ea3ng<\/p>\n

\"c\u00e1ch<\/p>\n

– B\u01b0\u1edbc 3: Cu\u1ed1i c\u00f9ng, b\u1ea1n th\u1ef1c hi\u1ec7n vi\u1ebft s\u1ed1 m\u0169. Sau khi vi\u1ebft xong, b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm \u1edf b\u01b0\u1edbc 2 \u0111\u1ec3 trang t\u00ednh Excel tr\u1edf l\u1ea1i v\u1ec1 giao di\u1ec7n b\u00ecnh th\u01b0\u1eddng.<\/p>\n

\"c\u00e1ch<\/p>\n

2. S\u1eed d\u1ee5ng ph\u00edm t\u1eaft vi\u1ebft d\u1ea5u m\u0169 trong Excel (Ch\u1ec9 s\u1ed1 d\u01b0\u1edbi)<\/strong><\/em><\/h3>\n

\u0110\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c \u0111\u00e1nh s\u1ed1 m\u0169 (ch\u1ec9 s\u1ed1 d\u01b0\u1edbi) trong trang t\u00ednh Excel, b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc nh\u01b0 sau:<\/p>\n

– B\u01b0\u1edbc 1: D\u00f9ng chu\u1ed9t m\u1edf trang t\u00ednh Excel c\u1ea7n s\u1eeda, sau \u0111\u00f3 th\u1ef1c hi\u1ec7n thao t\u00e1c nh\u1eadp nh\u1eefng d\u1eef li\u1ec7u c\u1ea7n thi\u1ebft.<\/p>\n

V\u00ed d\u1ee5: H\u00ecnh minh h\u1ecda ph\u00eda d\u01b0\u1edbi, Unica s\u1ebd vi\u1ebft H20 v\u1edbi s\u1ed1 2 l\u00e0 s\u1ed1 m\u0169.<\/p>\n

\"c\u00e1ch<\/p>\n

– B\u01b0\u1edbc 2: \u1ede d\u00f2ng c\u1ea7n vi\u1ebft d\u1ea5u m\u0169, b\u1ea1n nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edmCtrl +1 -> Alt +B -> Enter.<\/strong><\/p>\n

Trong \u0111\u00f3, c\u00e1c ph\u00edm th\u1ec3 hi\u1ec7n c\u00e1c n\u1ed9i dung nh\u01b0 sau:<\/p>\n

Ctrl +1<\/strong>: Thao t\u00e1c \u0111\u1ec3 m\u1edf b\u1ea3ng Format Cells<\/p>\n

Alt +B :<\/strong>\u00a0Thao t\u00e1c \u0111\u1ec3 ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng ch\u1ec9 s\u1ed1 d\u01b0\u1edbi<\/p>\n

Enter:<\/strong>Thao t\u00e1c ch\u1ea5p nh\u1eadn l\u1ec7nh v\u00e0 th\u1ef1c hi\u1ec7n \u0111\u00f3ng b\u1ea3ng<\/p>\n

\"c\u00e1ch<\/p>\n

– B\u01b0\u1edbc 3: Cu\u1ed1i c\u00f9ng, b\u1ea1n th\u1ef1c hi\u1ec7n vi\u1ebft s\u1ed1 m\u0169. Sau khi vi\u1ebft xong, b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm \u1edf b\u01b0\u1edbc 2 \u0111\u1ec3 trang t\u00ednh Excel tr\u1edf l\u1ea1i v\u1ec1 giao di\u1ec7n b\u00ecnh th\u01b0\u1eddng.<\/p>\n

\"c\u00e1ch<\/p>\n

L\u01b0u \u00fd: Kh\u00f4ng s\u1eed d\u1ee5ng ph\u00edm t\u1eaft n\u00e0y v\u1edbi c\u00e1c Font ch\u1eef, b\u1edfi n\u00f3 ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng v\u1edbi Font ch\u1eef Calibri v\u00e0 Arial<\/p>\n

Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng.<\/p>\n","protected":false},"excerpt":{"rendered":"

1. S\u1eed d\u1ee5ng ph\u00edm t\u1eaft vi\u1ebft d\u1ea5u m\u0169 trong Excel (Ch\u1ec9 s\u1ed1 tr\u00ean) \u0110\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c \u0111\u00e1nh s\u1ed1 m\u0169 (ch\u1ec9 s\u1ed1 tr\u00ean) trong trang t\u00ednh Excel, b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc nh\u01b0 sau: – B\u01b0\u1edbc 1: D\u00f9ng chu\u1ed9t m\u1edf trang t\u00ednh\u00a0Excel\u00a0c\u1ea7n s\u1eeda, sau \u0111\u00f3 th\u1ef1c hi\u1ec7n thao t\u00e1c nh\u1eadp nh\u1eefng d\u1eef li\u1ec7u c\u1ea7n thi\u1ebft. […]<\/p>\n","protected":false},"author":3,"featured_media":8704,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[508],"tags":[],"class_list":["post-8703","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office"],"_links":{"self":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/8703","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/comments?post=8703"}],"version-history":[{"count":0,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/8703\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media\/8704"}],"wp:attachment":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media?parent=8703"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/categories?post=8703"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/tags?post=8703"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}