answersLogoWhite

0


Best Answer

If they are in the middle of a cell there are a few things you can do. You can turn off wrap text. Press Ctrl-1 and go to the Alignment settings and if it is on, you can turn it off by removing the tick. If the hard return has been put in by the user, find the point in the text where it is, press F2 to edit the cell and use the Delete or Backspace key to remove it.

User Avatar

Wiki User

10y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you remove hard returns in an Excel spreadsheet?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the disadvantage of using electronic spread sheets compared to other spreadsheet?

Electronic spread sheets can easily be modified and/or deleted. A hard copy spreadsheet not so. But if you regularly save your work as you are using the spreadsheet you should not have any problems. There is a way to setup Excel to auto save every few minutes.


Why is MS Excel is called Excel?

MS-Excel is a powerful worksheet & you calculate , syncronize many hard calculation, so MS-Excel is called Excel.


Is Excel an accounting software?

Excel formulas are complex and prone to error. Accounting software handles all the calculations for you, and does it properly. • Excel spreadsheets are susceptible to fraud because it’s easy to change information and hard to keep track of who’s making the changes, whereas accounting software maintains an audit trail.


What can you say about the number of hard an soft returns if the margins are increased by 0.5 on each side?

The number of hard returns is the same, but the number and/or position of the soft returns increases.


How do you Excel at work?

By working hard and knowing your job well and becoming really proficient at doing it, then you will excel at work.


When left and right margins are widened in a document that contains three paragraphs the number of hard returns is?

The number of hard returns in the document with three paragraphs will stay the same regardless of widening the left and right margins. Hard returns are not affected by margin width adjustments and will remain to separate each paragraph.


When you remove a hard drive does it remove the programs as well?

No. They will stay on the hard drive.


What main function of ms-Excel are not available in ms-word?

They are very different applications, designed to do different jobs. Although many people don't know it, using tables in Word, it is possible to do some simple spreadsheet functions, like SUM. It would be hard to say what is the main function that it cannot do as there are so many things that it cannot do compared to Excel. Hundreds of more complex functions and formulas are not available and things like creating charts from the data.They are very different applications, designed to do different jobs. Although many people don't know it, using tables in Word, it is possible to do some simple spreadsheet functions, like SUM. It would be hard to say what is the main function that it cannot do as there are so many things that it cannot do compared to Excel. Hundreds of more complex functions and formulas are not available and things like creating charts from the data.They are very different applications, designed to do different jobs. Although many people don't know it, using tables in Word, it is possible to do some simple spreadsheet functions, like SUM. It would be hard to say what is the main function that it cannot do as there are so many things that it cannot do compared to Excel. Hundreds of more complex functions and formulas are not available and things like creating charts from the data.They are very different applications, designed to do different jobs. Although many people don't know it, using tables in Word, it is possible to do some simple spreadsheet functions, like SUM. It would be hard to say what is the main function that it cannot do as there are so many things that it cannot do compared to Excel. Hundreds of more complex functions and formulas are not available and things like creating charts from the data.They are very different applications, designed to do different jobs. Although many people don't know it, using tables in Word, it is possible to do some simple spreadsheet functions, like SUM. It would be hard to say what is the main function that it cannot do as there are so many things that it cannot do compared to Excel. Hundreds of more complex functions and formulas are not available and things like creating charts from the data.They are very different applications, designed to do different jobs. Although many people don't know it, using tables in Word, it is possible to do some simple spreadsheet functions, like SUM. It would be hard to say what is the main function that it cannot do as there are so many things that it cannot do compared to Excel. Hundreds of more complex functions and formulas are not available and things like creating charts from the data.They are very different applications, designed to do different jobs. Although many people don't know it, using tables in Word, it is possible to do some simple spreadsheet functions, like SUM. It would be hard to say what is the main function that it cannot do as there are so many things that it cannot do compared to Excel. Hundreds of more complex functions and formulas are not available and things like creating charts from the data.They are very different applications, designed to do different jobs. Although many people don't know it, using tables in Word, it is possible to do some simple spreadsheet functions, like SUM. It would be hard to say what is the main function that it cannot do as there are so many things that it cannot do compared to Excel. Hundreds of more complex functions and formulas are not available and things like creating charts from the data.They are very different applications, designed to do different jobs. Although many people don't know it, using tables in Word, it is possible to do some simple spreadsheet functions, like SUM. It would be hard to say what is the main function that it cannot do as there are so many things that it cannot do compared to Excel. Hundreds of more complex functions and formulas are not available and things like creating charts from the data.They are very different applications, designed to do different jobs. Although many people don't know it, using tables in Word, it is possible to do some simple spreadsheet functions, like SUM. It would be hard to say what is the main function that it cannot do as there are so many things that it cannot do compared to Excel. Hundreds of more complex functions and formulas are not available and things like creating charts from the data.They are very different applications, designed to do different jobs. Although many people don't know it, using tables in Word, it is possible to do some simple spreadsheet functions, like SUM. It would be hard to say what is the main function that it cannot do as there are so many things that it cannot do compared to Excel. Hundreds of more complex functions and formulas are not available and things like creating charts from the data.


What bar enables you to see the hard returns on your screen?

show/hidebutton


Is highschool hard?

No, if you keep up in class and do your homework! Hee hee from a highschoolee


The enables you to see the hard returns on your screen?

The answer is D. Show/Hide button.


How can you use the chart in excel?

There are many youtube videos that answer your question in many ways. Just search for Excel Chart. It's hard to answer your question without showing you.