From the course: Excel 2016: Advanced Formatting Techniques

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Format column and row titles

Format column and row titles

From the course: Excel 2016: Advanced Formatting Techniques

Start my 1-month free trial

Format column and row titles

“

- We're looking at a worksheet called Row Column Titles and when the need arises to put titles for a column and for a row together, sometimes it's not clear what would be best. A couple of options here: in cell A1 I'd like to indicate that the dates to the right are reporting dates or report dates, and below we have the different regions. So I'm going to type initially Report Date, and press ALT-Enter. ALT-Enter introduces a line break, and now I'll type Region, and Enter. And for some situations, this can be just fine. Something else we might consider doing, I'm going to double-click in cell A1 just in front of the R, I'm in edit mode now, type in some spaces. And somewhat guesswork here perhaps, but that looks reasonable enough, press Enter, you could do that. There's also something called Rich Text Formatting, where you can format part of a cell. So double-clicking back in cell A1, and then double-clicking or dragging across the word Region, I'll just double-click here. The color…

Contents