How to Replace Line Breaks in OpenOffice
줄 깸(변경, 바꿈)을 바꾸는 방법
The "Find & Replace(찾기와 바꿈)" feature can save you a great deal of time.
With OpenOffice Writer you can create a great variety of text documents, whether you need to write a paper for school or produce a professional report for your place of business.
In some cases, you may want to automatically apply one type of edit to your entire document at once, like altering line breaks, rather than tediously working through the document to apply the changes yourself.
Using OpenOffice's "Find & Replace" feature, you can enter specific symbols to replace line breaks with new elements or to simply remove them altogether.
Since the process is automatic, it shouldn't take you more than a minute or two.
1
Open the file in OpenOffice Writer with the line breaks you want to remove.
2
Open the "Find & Replace" dialog box. You can do this by pressing and holding the "Control" key and then pressing the "F" key, or you can click the "Edit' menu near the top of the window and then click "Find & Replace."
3
Click the "More Options" button in the "Find & Replace" window, and then ensure that the "Regular expressions" option is checked. Otherwise OpenOffice won't understand the symbols you type for line breaks.
4
Type in the appropriate symbol for your search in the "Search for" box. If you want to search for basic hard returns, type a dollar sign like this (without quotation marks): "$". If you want to search for an empty paragraph, type a carrot symbol and a dollar sign like this (without quotation marks): "^$". Note that these two do not overlap; the former is for a hard return on a line that then contains text, and the latter is for a hard return on a line that contains no text.
5
Fill in the "Replace with" box with whatever you want OpenOffice to insert in place of the line breaks. If you simply want to remove the line breaks, leave the box empty.
6
Click the "Replace All" button. A window will appear telling you how many replacements OpenOffice applied.
How to Make a Break in Excel
By Alan Sembera
Microsoft Excel allows you to add text and graphics to your tables.
When preparing an Excel document for printing, it's important to ensure that your data and text display correctly on the pages. One of the more useful formatting elements is a manual page break. By inserting a page break, you can control exactly where one page ends and another begins, allowing you to keep related data together on the same page. You can also insert a manual line break when you have text that won't fit in the width of a cell. The line break forces your text to display on multiple lines within the cell.
Page Breaks
1
Click the "View" tab and select either "Normal" or "Page Break Preview" from the ribbon.
2
Click the row number below where you want to insert a page break, so that you select the entire row. To insert a vertical page break, click the column letter to the right of where you want the break.
3
Click the "Page Layout" tab, and then click "Breaks" on the Page Setup section of the ribbon. Select "Insert Page Break" from the options.
Line Breaks
1
Double-click the cell that contains your text.
2
Position your cursor at the point in the text where you want to force a new line.
3
Press "Alt-Enter" on the keyboard to create the manual line break.