Hard Return




For visual reasons, there are times that you may wish to have multiple lines of text within an Excel cell rather than one long string. Do you know how to do this? Hint: you don’t want to use the TAB or space bar button because this spacing will be incorrect if you resize your cells! Instead you want to place what is known as a “hard return” (or a new line of text) within the cell.

A hard return is very easy to insert in a cell. Simply type your first line of text. When you reach the end of that line, hold down the Alt button of your keyboard as you hit the Enter (or Return) button. A new line will be started inside the cell.

An excel sheet is open with 4 lines of text in cell A1. There is a green arrow pointing at the cell.

You can add as many lines of text as you would like this way. When you are finished with that cell, simply hit Enter or Tab as normal to proceed to the next cell. Your cell should automatically resize to accommodate the multiple hard returns you have created in the cell. Best of all, if you manually resize your cells, columns, or rows, the hard returns will remain in place and the separate lines of text will remain separate lines of text!

An excel sheet is open with 3 lines of text in cell A1. There is a green arrow pointing at the cell.

Now consider these questions: In what situations would a hard return be useful? Would you ever use this feature? Why or why not?

  • a month ago
  • 07.05.2022
  • 4
Report Issue


  • Discount Assign
  • Maria the tutor
  • Dr Michelle Ella
  • Teacher A+ Work
  • Flexible Tutor
  • Brilliant Geek
  • Tutor Cyrus Ken
  • Prof Nato(PhD)
  • Michelle Malk
  • Ashley Ellie
  • bennetsandova
  • ConsultThanos
  • Brainy Brian
  • Amanda Smith
  • miracle tutor
  • Expert Humaira
  • Michelle GoodMan
  • JudithTutor

  • BUS475-FinalExam-Set2 Latest Updates to the BUS 475 Final Exam Guide
  • Japanese Auto Supply Chain
  • International Business
  • Interest expense $2,000 Sales revenue 297,000 Selling expenses 38,200…
  • ACCOUNTING QUESTIONS – I need plagiarize free answers
  • Prepare a Background Statement to Further Analyze the Problem
  • perfecto – Impact of Internal and External Assessment
  • New Product Launch Marketing Plan Final
  • History
  • JavaScript Help – Need in a few hours