Double lines? Ooh, dotted lines! Or maybe dashes? What about the color? A standard one? Or a themed set?
And that's without considering whether you want the same border on all sides of your box, or something different across the top or along the bottom. Before you realize it, you can lose half your morning on irrelevant esthetics. Surely there's a simpler, distraction-free way of applying a border. You won't notice the change until you select another cell.
Oops: You or a colleague succumbed to the temptations of the Format Cells - Border dialog box see previous slide , with its cornucopia of line styles, colors, orientations and spacings, and your worksheet now looks like a Mondrian-Jackson Pollock mash-up. You distractedly type in a whole series of labels, then realize that you meant them to go across a row, and not down a column.
Adding New Lines to Cells in Excel for the Mac
Start by selecting the column of labels or other data you want to transpose. You can click and drag or, if the column is very long, try this: Select the first cell in the column, hold down the shift key, and double-click on the lower border of the selected cell: Excel will extend the selection downward until it encounters an empty cell. Copy the selection, then select the leftmost of the cells where you would like the transposed labels to appear. As long as the source and destination areas don't overlap, you should see your cell entries spread across the sheet rather than down it.
Note: This trick also works the other way, for transposing a horizontal block of cells into a vertical one. This is a quick one. Curious minds will want to know: What happens if you do both simultaneously?
Excel on Mac: How to type newline inside a cell? – Manhattan Dave
This is a little like clicking on the triangle at the top-left of the sheet, with the difference being that it leaves the current cell selection unchanged, while clicking the triangle makes A1 the current cell. You selected something in Excel — a cell, a drawing, or a chart — and want to reformat it. But what or where is the command to do that? There are so many different formatting functions in Excel it can be hard to find the right one.
It works whatever the selection: cells or groups of cells; drawings, or even parts of charts such as legends or axes. If there's one thing I learned at college, it's that there's no shame in looking it up.
You don't have to know all the answers, but it helps to learn where to find them. So it is with building formulas in Excel: There are so many functions, with so many parameters, that it's nigh-on impossible to remember them all. Happily, you don't have to. Excel already provides a modicum of help, listing the parameters to a function when you type the opening parenthesis following its name. But that's not always enough of a clue.