You could use a smaller font size, or you could delete some of the header text, but there are better choices. What you can’t see is that the data range extends to column P–you’re missing a lot. SEE: System update policy template download (Tech Pro Research) Shrink to fitįigure A shows an example of what often happens when header text exceeds the actual data in the column. You can use your own data or download the demonstration. I’m using Office 365’s desktop version of Excel on a Windows 10 64-bit system, but you can apply these formats in older versions. How to return first and last times from timestamps in Microsoft ExcelĬhecklist: Microsoft 365 app and services deployments on Macs Get Microsoft Office Pro and lifetime access to 5 top apps for $59.99 In this article, I’ll show you three cell formats that reduce the width of the header cells so you can get all of that data back on a single screen.

But, when the problem is the header text, you have choices. Moving from screen to screen is tedious and often, there’s nothing you can do about it. In an ordinary sheet, descriptive header text often inflates the width of columns, pushing important data off screen. Use these three formats to put headers on a diet when working in Excel. Header text often takes up too much space. Excel tip: Three cell formats that will make header text fit

Angle text in excel