There are two similar text formatting options in Excel. The well-known Merge & Center and the hidden away Center across selection. Both have their advantages, the choice is yours. Merge & Center Most Excel users know ‘Merge & Center’ because it’s atop the Merge list at Home | Alignment | Merge. It does two things: […]
A recent Windows update is causing VBA code to fail in Excel, Access and other VBA parts of Office. The culprit isn’t Office, but the version of Windows that it’s running on. After the 2019-08 Cumulative Update KB4511553 is applied, some VBA code will stop working. The patch bug is in Windows 10, 8.1 and […]
Despite all the possibilities for importing or sharing appointments, most of the time we have to manually type in new appointments or events. Here’s some tips to do it faster and get it right. We’ve all been there, a web page or email (below right) with details that need copying into a blank Outlook appointment […]
The Format Cells dialog can be accessed from Home | Alignment | Orientation, or by right-clicking on selected cells and selecting Format Cells. See Excel’s text and number alignment choices Text formatting in Excel with wrapping, line breaks and merging This dialog gives you more detailed options to choose from than are available in the Orientation […]
Under Excel’s Home | Alignment ribbon you can change the indents, alignment or angle of the text in selected cells. As usual, a seemingly simple set of buttons have some hidden tricks. See Text formatting in Excel with wrapping, line breaks and merging Alignment Adjust alignment of the text, both across and up/down, use the […]
