{"id":574,"date":"2020-07-21T13:43:10","date_gmt":"2020-07-21T06:43:10","guid":{"rendered":"https:\/\/hoctin.vn\/?p=574"},"modified":"2020-09-23T16:40:52","modified_gmt":"2020-09-23T09:40:52","slug":"cach-xuong-dong-trong-excel","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/cach-xuong-dong-trong-excel\/","title":{"rendered":"C\u00e1c C\u00e1ch Xu\u1ed1ng D\u00f2ng Trong Excel \u0110\u01a1n Gi\u1ea3n V\u00e0 Nhanh Nh\u1ea5t"},"content":{"rendered":"\t\t
Khi nh\u1eadp d\u1eef li\u1ec7u, nhi\u1ec1u l\u00fac b\u1ea1n v\u1eabn ph\u1ea3i nh\u1eadp v\u0103n b\u1ea3n v\u00e0o b\u1ea3ng t\u00ednh. Thao t\u00e1c \u1ea5n enter trong Excel kh\u00f4ng gi\u1ed1ng Word, d\u1eabn \u0111\u1ebfn \u00f4 t\u00ednh \u0111\u01b0\u1ee3c nh\u1eadp v\u0103n b\u1ea3n c\u00f3 th\u1ec3\u00a0 kh\u00f4ng hi\u1ec3n th\u1ecb h\u1ebft ch\u1eef trong Excel.<\/span><\/p> \u00a0<\/p> B\u00e0i vi\u1ebft n\u00e0y c\u1ee7a hoctin.vn s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c c\u00e1ch vi\u1ebft nhi\u1ec1u d\u00f2ng trong 1 \u00f4 Excel hay c\u00e1ch xu\u1ed1ng d\u00f2ng trong Excel 2003 2007 2010 2013 2016 2019.<\/span><\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t N\u1ebfu ch\u1ec9 s\u1eed dung c\u00e1ch Enter th\u00f4ng th\u01b0\u1eddng th\u00ec s\u1ebd kh\u00f4ng xu\u1ed1ng d\u00f2ng \u0111\u01b0\u1ee3c trong Excel. Thay v\u00e0o \u0111\u00f3, h\u00e3y nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm xu\u1ed1ng d\u00f2ng trong Excel: Alt + Enter tr\u00ean Windows ho\u1eb7c Control + Option + Return (Enter) ho\u1eb7c Command + Option + Return (Enter) tr\u00ean MacOS.<\/span><\/span><\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t Quy tr\u00ecnh<\/span><\/p><\/td> Windows<\/span><\/p><\/td> MacOS<\/span><\/p><\/td><\/tr> B\u01b0\u1edbc 1<\/span><\/p><\/td> B\u1ea5m \u0111\u00fap chu\u1ed9t v\u00e0o \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n<\/span><\/p> \u00a0xu\u1ed1ng d\u00f2ng ho\u1eb7c b\u1ea5m ph\u00edm F2<\/span><\/p><\/td> B\u1ea5m \u0111\u00fap chu\u1ed9t v\u00e0o \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n xu\u1ed1ng d\u00f2ng ho\u1eb7c t\u1ed5 h\u1ee3p ph\u00edm ^ + U<\/span><\/p><\/td><\/tr> B\u01b0\u1edbc 2<\/span><\/p><\/td> \u0110\u01b0a con tr\u1ecf chu\u1ed9t \u0111\u1ebfn v\u1ecb tr\u00ed m\u00e0 b\u1ea1n mu\u1ed1n ng\u1eaft d\u00f2ng<\/span><\/p><\/td> \u0110\u01b0a con tr\u1ecf chu\u1ed9t \u0111\u1ebfn v\u1ecb tr\u00ed m\u00e0 b\u1ea1n mu\u1ed1n ng\u1eaft d\u00f2ng<\/span><\/p><\/td><\/tr> B\u01b0\u1edbc 3<\/span><\/p><\/td> Nh\u1ea5n Alt + Enter \u0111\u1ec3 xu\u1ed1ng d\u00f2ng<\/span><\/p><\/td> Nh\u1ea5n Control + Option + Return (Enter) ho\u1eb7c Command + Option + Return (Enter) \u0111\u1ec3 xu\u1ed1ng d\u00f2ng<\/span><\/p><\/td><\/tr><\/tbody><\/table><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t H\u00ecnh minh h\u1ecda cho b\u01b0\u1edbc 2- \u0111\u01b0a con tr\u1ecf chu\u1ed9t \u0111\u1ebfn v\u1ecb tr\u00ed mu\u1ed1n ng\u1eaft d\u00f2ng:<\/span><\/span><\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t K\u1ebft qu\u1ea3 sau khi \u00e1p d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm ng\u1eaft d\u00f2ng Alt+ Enter cho to\u00e0n b\u1ed9 b\u1ea3ng:<\/span><\/span><\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t Note:<\/span> N\u1ebfu kh\u00f4ng b\u1eaft bu\u1ed9c ph\u1ea3i tr\u00ecnh b\u00e0y v\u0103n b\u1ea3n trong m\u1ed9t \u00f4, h\u00e3y t\u1ea1o m\u1ed9t nh\u1eadn x\u00e9t \u0111\u1ec3 l\u00e0m cho b\u1ea3ng t\u00ednh tr\u00f4ng g\u1ecdn g\u00e0ng h\u01a1n.<\/span><\/span><\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t Wrap Text l\u00e0 c\u00e1ch \u0111\u1ec3 g\u00f3i g\u1ecdn n\u1ed9i dung trong 1 \u00f4, ng\u1eaft d\u00f2ng trong Excel, ng\u0103n ch\u1eef b\u1ecb tr\u00e0n sang \u00f4 kh\u00e1c.<\/span><\/p> \u00a0<\/span><\/p> B\u01b0\u1edbc 1: Ch\u1ecdn c\u00e1c \u00f4 b\u1ea1n mu\u1ed1n xu\u1ed1ng d\u00f2ng<\/span><\/p> B\u01b0\u1edbc 2: Trong Tab Home, t\u1ea1i nh\u00f3m Alignment, b\u1ea5m ch\u1ecdn Wrap Text:<\/span><\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t \u00a0<\/span><\/p> K\u1ebft qu\u1ea3 sau khi \u00e1p d\u1ee5ng Wrap text: B\u1ea1n c\u00f3 th\u1ec3 t\u00f9y \u00fd c\u0103n ch\u1ec9nh \u0111\u1ed9 r\u1ed9ng c\u1ed9t b\u1eb1ng c\u00e1ch k\u00e9o chu\u1ed9t t\u1ea1i r\u00eca b\u00ean ph\u1ea3i \u00f4 \u0111\u1ec3 \u0111i\u1ec1u ch\u1ec9nh ng\u1eaft d\u00f2ng t\u1eeb v\u1ecb tr\u00ed n\u00e0o.<\/span><\/span><\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t C\u00e1ch xu\u1ed1ng h\u00e0ng trong Excel s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Justify t\u1eeb h\u1ed9p tho\u1ea1i Format Cells gi\u00fap c\u0103n l\u1ec1 \u0111\u1ec1u hai b\u00ean cho m\u1ed9t \u00f4, gi\u1ed1ng nh\u01b0 c\u00e2n b\u1eb1ng 2 l\u1ec1 trong Word. \u0110\u1ed3ng th\u1eddi, t\u00ednh n\u0103ng n\u00e0y c\u0169ng s\u1ebd gi\u00fap c\u00e1c b\u1ea1n t\u1ef1 \u0111\u1ed9ng xu\u1ed1ng d\u00f2ng trong Excel.<\/span><\/p> \u00a0<\/span><\/p> B\u01b0\u1edbc 1: Ch\u1ecdn \u00f4 c\u1ea7n ng\u1eaft d\u00f2ng: \u00f4 B4 nh\u01b0 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p> B\u01b0\u1edbc 2: B\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn Format Cells ho\u1eb7c s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm Ctrl + 1.<\/span><\/p> \u00a0<\/p> H\u1ed9p tho\u1ea1i Format Cells hi\u1ec7n l\u00ean nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t \u00a0<\/span><\/p> B\u01b0\u1edbc 3:\u00a0 Trong h\u1ed9p tho\u1ea1i, c\u00e1c b\u1ea1n ch\u1ecdn tab Alignment, t\u1ea1i khung Horizontal thu\u1ed9c Text alignment, ch\u1ecdn Justify.<\/span><\/p> K\u1ebft qu\u1ea3 sau khi \u00e1p d\u1ee5ng ch\u1ee9c n\u0103ng Justify nh\u01b0 sau:<\/span><\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t1, C\u00e1ch Xu\u1ed1ng D\u00f2ng Trong \u00d4 Excel B\u1eb1ng Alt + Enter<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
2, C\u00e1ch Xu\u1ed1ng D\u00f2ng Trong Excel B\u1eb1ng Wrap Text<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
3, C\u00e1ch Xu\u1ed1ng D\u00f2ng Trong 1 \u00d4 Excel B\u1eb1ng \u0110i\u1ec1u Ch\u1ec9nh H\u1ed9p Tho\u1ea1i Format Cells<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
4, \u1ee8ng D\u1ee5ng H\u00e0m Xu\u1ed1ng D\u00f2ng Trong Excel<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t