| Channel | Publish Date | Thumbnail & View Count | Actions |
|---|---|---|---|
 Rabi Gurung | 2022-11-21 16:00:00 |  1,342 Views |
To center text across multiple rows or columns in Excel, you can combine multiple cells into one big cell. Merged cells, however, are infamous for causing issues in spreadsheets, particularly when trying to sort, copy, paste, or relocate data. Because of this, unless absolutely necessary, it’s usually advisable to avoid merging cells.
Why shouldn’t you merge cells?
Merged cells are notorious for creating problems with your spreadsheets. It creates havoc with sorting, filtering, copying, pasting or moving data. You cannot drag down formulas through cells that are merged and unmerged differently.
It is generally best to avoid merging cells unless you absolutely have to.
Here are the steps outlined in this video.
1) Select row of cells
2) Ctrl + 1
3) Alignment tab
4) In Horizontal pulldown menu, select /”Center Across Selection/”
5) OK
6) Delete data from cells
#microsoft #excel #exceltips #tips #exceltricks #tricksandtips
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
