You can shift Cells Down in Excel by right-clicking, clicking and dragging, via the Home tab, using Shift-Click-Drag, Right-click and drag, Inserting copied cells, etc.

Trying to make all of the text or words fit properly in your Excel spreadsheet? Learn how to make text fit in Excel with our tutorial.

If you want the entire Long-term debt account listed on row 7, simply select cells A7:A8. Go to Home on the Ribbon, go to the group Editing, click the dropdown arrow next to Fill, and choose Justify.

Microsoft Excel updates cell references when you copy an expression. Here are a couple of workarounds for those rare occasions when you don't want to change the cell references.

You can wrap text in Excel in several ways to ensure that all the text in a cell is visible at once. You may also want to edit the cell height.