Author: user

  • Word Processing – Formatting Text

    Change text formatting: font sizes, font types.

    To change the font size and the font type of the text in a document, right-click anywhere on the document text area and from the resulting menu, click on ‘Edit Paragraph Style’. This will open the ‘Paragraph Style’ dialog box.
    [the_ad id=”12355″]
    [show_slider name=wordprocessing-formatting-text]
    [the_ad id=”12356″]
    Font

    In this dialog box, under the ‘Font’ tab, we have the ‘Size’ and ‘Font’ drop-down lists. The appropriate font size and font type can be selected from these lists. After selecting the required values, click on ‘OK’. This will make the required changes to the document.

    Apply text formatting: bold, italic, underline.

    In the same ‘Paragraph Style’ dialog box, under the ‘Font’ tab, we have the ‘Style’ drop-down list. From this list we can choose the ‘Bold’ or ‘Italic’ options to make the text style as bold or italic.

    Font Styles

    In the same dialog, under the ‘Font Effects’ tab, we have the ‘Underlining’ drop-down list. The required underlining effect can be chosen from this list.

    Underline

    After making the changes, click on ‘OK’ to make these changes effective.

    We have another method to format a piece of text as bold, italic, or underline. First of all, select the text which needs to be formatted. After this, right-click on the selected text and from the resulting menu, click on ‘Format’. This displays a menu which contains three options for ‘Bold’, ‘Italic’, and ‘Underline’. The appropriate formatting option can be chosen from this menu.

    Format

    Apply text formatting: subscript, superscript.

    A subscript or superscript is a number, figure, symbol, or indicator that is smaller than the normal line of type and is set slightly below or above it. Subscripts appear at or below the baseline, while superscripts are above it.

    To make some text as superscript or subscript, first of all select the text which needs to be formatted. After this, right-click on the selected text and from the resulting menu, click on ‘Format’. This displays a menu which contains two options for ‘Superscript’ and ‘Subscript’. The appropriate formatting option can be chosen from this menu.

    Superscript

    Apply different colours to text.

    In the same ‘Paragraph Style’ dialog box which has been used in the previous sections, under the ‘Font Effects’ tab, we have the ‘Font color’ drop-down list. Select the required color from this list and then click on ‘OK’. This will change the text color.

    Font Colour

    Apply case changes to text.

    To apply case changes to text, first of all select the text which needs to be formatted. After this, right-click on the selected text and from the resulting menu, click on ‘Change Case’. This displays a menu which contains options like ‘lowercase’ and ‘UPPERCASE’. The appropriate formatting option can be chosen from this menu.

    Changr Case

    Apply automatic hyphenation.

    In the same ‘Paragraph Style’ dialog used in the previous sections, under the ‘Text Flow’ tab, we have an option for ‘Hyphenation’. Select the ‘Automatically’ check box here and then make the required changes to the three options which are provided. After making all the changes, click on ‘OK’. This will apply automatic hyphenation for the document.

    Hyphenation

    [the_ad id=”12397″]

  • Word Processing – Edit Content


    Edit content by entering, removing characters, words within existing text, by over-typing to replace existing text.

    To edit content by entering or removing characters or words within existing text, select the text which you want to remove and replace. After this type the new text values. The new text will automatically take place of the selected text.
    [the_ad id=”12355″]
    [show_slider name=edit-content]
    [the_ad id=”12356″]

    Use a simple search command for a specific word, phrase.

    To use the search command, click on ‘Edit’ from the main menu bar, and from the resulting drop-down menu, click on ‘Find’. This will open the ‘Find’ bar at the bottom of the document.

    Find

    In this bar, we can enter the search term which we need to find in the document. After entering the term, press enter from the keyboard. If the term exists in the document, it will get highlighted in the document. If the term is not present in the document, we’ll get a message ‘Search key not found’ in the bar.

    In case more than one instances of the term are found in the document, you can use the arrow shaped ‘Next Element’ and ‘Previous Element’ buttons to browse through all of these.

    Use a simple replace command for a specific word, phrase.

    To use the replace command, click on ‘Edit’ from the main menu bar, and from the resulting menu, click on ‘Find & Replace’. This will open the ‘Find & Replace’ dialog box.

    Find and Replace

    In this dialog, enter the term which needs to be replaced in ‘Search For’ and the term with which this term needs to be replaced in ‘Replace With’. After this, click on ‘Replace’ to change the text values one by one or click on ‘Replace All’ to change all the text values in one go.

    There are also some options provided in this dialog which can be selected as per the requirements. These options help in filtering down the content to be searched in the document. These options can be viewed by expanding ‘Other options’.

    Copy, move text within a document, between open documents.

    To copy text within a document, or between open documents, select the text which needs to be copied and then right click on the selected text and from the resulting menu, click on ‘Copy’. After this, place the text pointer where the text needs to be copied to, this location can be in the same document or even some other open document, and again right-click and from the resulting menu, click on ‘Paste’. The text will get copied to the new location.

    Cut and Copy

    To move text within a document, or between open documents, select the text which needs to be moved and then right click on the selected text and from the resulting menu, click on ‘Cut’. After this, place the text pointer where the text needs to be moved to, this location can be in the same document or even some other open document, and again right-click and from the resulting menu, click on ‘Paste’. The text will be moved to the new location.

    Paste

    Delete text.

    To delete text, simply select the text which needs to be deleted and press the delete button from the keyboard. This will delete the selected text.

    Another method is to place the text pointer to the right of the text which needs to be deleted and then press the ‘backspace’ button from the keyboard. This will delete the text backwards. Release the button after deleting as much text as is needed.

    Use the undo, redo command.

    The undo command undoes the effect of the recent changes which were made to the document in such a way so that the most recent change is undone first. The redo command performs the most recent change done to the document again.
    To use the undo or redo commands, click on ‘Edit’ from the main menu bar. From the resulting drop-down, click on ‘Undo’ or ‘Redo’ as per the requirement to perform undo or redo respectively.

    Undo

    [the_ad id=”12397″]

  • Word Processing – Document Creation

    Enter Text


    Switch between page-view modes.

    Writer has three ways to view a document: Print Layout, Web Layout, and Full Screen. To change the view, go to ‘View’ from the main menu bar and click on the required view from the resulting drop-down menu. Print Layout is the default view in Writer.
    [the_ad id=”12355″]
    [show_slider name=document-creation]
    [the_ad id=”12356″]

    Page View

    Enter text into a document.

    To enter text in a document, simply click once in the text area. This will give a blinking text pointer in the text area. Now use the keys on your keyboard to enter the text values. This is how we can enter text into a writer document.

    Enter Text

    Insert symbols or special characters like: ©, ®, ™.

    To insert symbols or special characters in a Writer document, click on ‘Insert’ from the main menu bar. From the resulting drop-down, click on ‘Special Character’. This will open the ‘Special Characters’ dialog box.

    Special Characters

    From this, you can select the required symbols or characters from the collection given and then click on ‘Insert’. This will insert the selected symbol or special character into the document.

    Display, hide non-printing formatting marks like: spaces, paragraph marks, manual line break marks, tab characters.

    To display the non-printing characters like spaces, paragraph marks, and tab characters, click on ‘View’ from the main menu bar and from the resulting drop-down menu, click on ‘Non-printing Characters’. This will display the non-printing characters in the page. How these characters look in a writer page has been shown in the below given illustration.

    Non Print Characters

    The ‘inverted P’ shows a paragraph mark, a ‘.’ shows a space and a forward arrow shows a tab character.

    To hide the non-printing characters, again click on the same ‘Non-printing Characters’ from the ‘View’ menu.

    Select character, word, line, sentence, paragraph, entire body text.

    To select a character, simply place the text pointer on either side of the character using the mouse. Then, press the ‘Shift’ key from the keyboard and without releasing this key, move the pointer towards the character using the ‘Arrow’ keys from the keyboard and reach the other side of the character. Release the keys after moving over the character. This will select the character.

    Another way is to place the text pointer on either side of the character using the mouse and then holding down the mouse button and hovering over the character without releasing the button. Release the button after reaching the other side of the character. This way the character will get selected. The character will be surrounded by a blue background upon selection.

    These same two methods can be used to select a word, a line, a sentence, and even an entire paragraph. Just start from one end of the text body, and reach the other end by using any one of these methods. This will select the text body.

    Select All

    To select the entire body text, simply press the ‘Ctrl’ and ‘A’ keys from the keyboard together. This will select the entire body text.

    [the_ad id=”12397″]

  • Word Processing Productivity


    Set basic options/preferences in the application: user name, default folder to open, save documents.

    To set the basic options in the Writer application, click on ‘Tools’ from the main menu bar. From the resulting drop-down, click on ‘Options’. This will open the ‘Options’ dialog box.
    [the_ad id=”12355″]
    [show_slider name=wordprocessing-productivity]
    [the_ad id=”12356″]
    User data

    In the ‘Options’ dialog box, under ‘LibreOffice’, in ‘User Data’ we have options to enter user info. The user name can be set here.

    In the same dialog box, under ‘LibreOffice’, we have ‘Paths’. Here, we can set the different default paths for the folders to open and save files.

    Paths

    Use available Help functions.

    All the components of LibreOffice offer extensive help system to the users. Writer is no different. To get the complete help system, click on ‘Help’ button from the main menu bar. Click on ‘LibreOffice Help’ from the drop down which gets displayed and this will open the full help system.

    Additionally, you can click on ‘Tools’ from the main menu bar and then click on ‘Options’ from the resulting drop down menu. Select the ‘LibreOffice > General’ tab from the dialog which gets opened and you can then choose to check or uncheck the available help options like ‘Tips’ and ‘Extended Tips’.

    Help Tips

    If ‘Tips’ are enabled you can place the mouse pointer over any icon to see a small tooltip box, which provides a small explanation for the functioning of that icon.

    If a more detailed explanation is desired, then click on ‘What’s This?’ from the ‘Help’ dropdown on the main menu bar. Holding the pointer above any icon after this will provide a detailed explanation.

    Whats This

    Use magnification/zoom tools.

    The view magnification can simply be changed by clicking on the + or – sign in the zoom slider on the status bar.

    Magnify

    In order to make more custom changes, click on the percentage figure on the status bar. This opens the ‘Zoom & View Layout’ dialog. The appropriate changes can be made by selecting the desired values from this dialog.

    Zoom

    Display, hide built-in toolbars. Restore, minimize the ribbon.

    Whether to display or hide the different toolbars in Writer can be controlled by using the ‘View’ button on the main menu bar. Click on ‘View’ and then click on ‘Toolbars’ from the drop down. You get a list of different toolbars which can be checked or unchecked in order to display or hide them respectively.

    Toolbars

    [the_ad id=”12397″]

  • Working with Documents

    Open, close a word processing application. Open, close documents.

    To start Writer, click on the ‘Start’ button on your Windows machine. Click on ‘All Programs’ and then go to the ‘LibreOffice’ folder in the list of all programs which gets displayed. Click on the ‘LibreOffice’ folder and then click on ‘LibreOffice Writer’. This will start the Writer application.
    [the_ad id=”12355″]
    [show_slider name=working-with-documents]
    [the_ad id=”12356″]
    open writer

    When Writer is started, the main window opens which has been shown below.
    Menu Bar

    The highlighted portion shown in the above illustration is the ‘Main Menu Bar’. This is the most important menu bar in the Writer application and most of the operations in Writer can be performed from here. In this tutorial, we are going to use the main menu bar for performing a variety of different operations.

    To close Writer, simply click on the ‘white cross icon with red background’ on the upper right corner of the Writer main window screen. This will close Writer.

    Cloes Writer

    Once the application has been started, then a new document can be opened. To open a new document, click on ‘File’ from the main menu bar. From the resulting drop-down, click on ‘New’ and from the sub-menu which is displayed, click on ‘Text Document’. This will open a new document.

    New Document

    To close a document, simply click on the same ‘white cross icon with a red background’ from the top right corner of the document screen.

    Create a new document based on default template, other available template like: memo, fax, and agenda.

    A default template is the one, which is used to create documents when any new document is created. This means that when we create a new document, it gets created based on the default template which has been set.

    We are going to learn how to set a default template in the subsequent chapters. But to create a new document based on the default template, simply follow the steps which have been given in the last section for opening a new document. This creates a new document based on the default template.

    To create documents based on the other available templates, click on ‘File’ from the main menu bar. From the resulting drop-down, click on ‘New’ and from the sub-menu which is displayed, click on ‘Templates’. This will open the ‘Template Manager’ dialog box.

    Template Manager

    This dialog box, under the ‘Documents’ tab, displays the different template categories available for creating new documents. You can select any of these by double clicking and this will display the different templates under that category. Double click on the required template and this will create a new document based on this template.

    Save a document to a location on a drive. Save a document under another name to a location on a drive.

    Once the changes to a Document have been made, we need to save this document to a location on our computer. To save a document, click on ‘File’ from the main menu bar. From the resulting drop-down, click on ‘Save As’. This opens the ‘Save As’ dialog box.

    In this dialog box, we can browse to the folder where we want to save the document file and thus select the appropriate location. To change the name by which the file will get saved, just enter the new name in the ‘File Name:’ field. After making these changes, click on ‘Save’. This will save the file to the location which has been specified and under the given file name.

    Save a document as another file type like: text file, Rich Text Format, template, software specific file extension, version number.

    To save a document as another file type, follow the same steps as given above. This will open the ‘Save As’ dialog box. In this dialog box, under the ‘Save as type:’ field, select the appropriate file type as per the requirement and then click on ‘Save’. This will save the document as the selected file type.

    Save as Type

    Switch between open documents.

    You can open multiple documents at a time in Writer. In such a case, to switch between these documents, just click on the ‘Writer’ icon on the task bar of your computer. This icon will always get displayed whenever you are running Writer on your machine.

    Switch Document

    When this icon is clicked, then the names of all the active documents get displayed as has been shown above. Simply click on the name of the document which you want to open and that document will get opened. You can switch between different documents using this method.

    [the_ad id=”12397″]

  • Preview a worksheet

    To preview a worksheet, click on ‘File’ from the main menu bar and from the resulting drop-down menu, click on ‘Print Preview’. This will open the preview display of the worksheet as has been shown below. To close the preview, click on ‘Close Preview’.
    [the_ad id=”12355″]
    [show_slider name=preview-a-worksheet]
    [the_ad id=”12356″]
    Print Preview

    Print a selected cell range from a worksheet, an entire worksheet, number of copies of a worksheet, the entire spreadsheet, a selected chart.

    To print a worksheet, click on ‘File’ from the main menu bar and from the resulting menu, click on ‘Print’. This will open the ‘Print’ dialog box. In this dialog, under the ‘General’ tab, we have certain options under ‘Range and Copies’.

    To print only a selected cell range from the worksheet, select the required cells before opening the ‘Print’ dialog box and then in the dialog box, select the ‘Selected cells’ radio button under ‘Range and Copies’. After this, click on ‘OK’. This will print only the selected cells.

    To print a worksheet, simply select the ‘Selected sheets’ radio button under ‘Range and Copies’ and click on ‘OK’. This will print only the current worksheet.

    To print multiple copies of a worksheet, select the value of copies to be required under ‘Number of copies’ and then click on ‘OK’. This will print the required number of copies.

    To print the entire spreadsheet, select ‘All sheets’ under ‘Range and Copies’ and then click on ‘OK’. This will print the entire spreadsheet.

    Print copies

    To enable the printing of charts, click on ‘Format’ from the main menu bar, and from the resulting drop-down click on ‘Page’. This will open the ‘Page Style’ dialog box. Here, under the ‘Sheet’ tab, we have a section called ‘Print’. Under this section we have a ‘Charts’ checkbox. Check this box to enable the printing of charts and uncheck to disable it. This is how we can control the printing of charts in Calc.

    Print Chart

    [the_ad id=”12397″]
    [the_ad id=”13529″]

  • Check and Print

    Check and correct spreadsheet calculations and text.

    In order to check the spreadsheet calculations, we need to check the sheet for the error codes. These error codes have already been discussed. If error codes are present, this means that some errors exist in some of the calculations and we must check these calculations again.
    [the_ad id=”12355″]
    [show_slider name=check-and-print]
    [the_ad id=”12356″]

    To check the text values in the sheet, click on ‘Tools’ from the main menu bar and from the resulting drop-down, click on ‘Automatic Spell Checking’. This will open the ‘Spelling’ dialog box. This dialog box lists all the incorrect spellings in the sheet. You can check the spellings and also correct them from here. After making all the changes, click on ‘Close’. This is how we can check the text values in Calc.

    Spell Checker

    Turn on, off display of gridlines, display of row and column headings for printing purposes.

    To turn on/off the display of gridlines or the display of row and column headings, click on ‘Format’ from the main menu bar and from the resulting drop-down, click on ‘Page’. This opens the ‘Page Style’ dialog box. In this dialog box, under ‘Print’, we have two check boxes named ‘Column and row headers’ and Grid’. The display of grid lines can be switched on or off by checking or unchecking the ‘Grid’ check box and the display of row and column headings can be switched on and off by checking or unchecking the ‘Column and row headers’ check box. After selecting the required values, click on ‘OK’. This will save your settings.

    Print

    Apply automatic title row(s) printing on every page of a printed worksheet.

    To apply automatic title rows printing on every page of a printed worksheet, click on ‘Format’ from the main menu bar. From the resulting drop-down menu, click on ‘Print Ranges’ and from the sub-menu which gets displayed, click on ‘Edit’. This will open the ‘Edit Print Ranges’ dialog box.

    Print Range

    In this dialog box, we have a section called ‘Rows to Repeat’. Click on the ‘Shrink’ button in front of this section and this will minimize the dialog box. Now select the row which you want to set as the title row for automatic printing on every page for the worksheet and again click on the ‘Shrink’ button.

    This will again bring up the full ‘Edit Print Ranges’ dialog box but now the rows selected will get displayed in the ‘Rows to Repeat’ section. Click on ‘OK’ and this will set up the selected rows as the automatic title rows for printing on each page of the worksheet.

    [the_ad id=”12397″]
    [the_ad id=”13529″]

  • Prepare Outputs

    Setup

    Change worksheet margins: top, bottom, left, right.

    In order to change the worksheet margins, click on the ‘Format’ button from the main menu bar. Click on ‘Page…’ button from the resulting drop-down. This gives the ‘Page Style’ dialog box. Under the ‘Page’ tab, you can make the appropriate changes to the ‘Margins’ in order to change the top, bottom, left, and right margins of a worksheet.
    [the_ad id=”12355″]
    [show_slider name=prepare-outputs]
    [the_ad id=”12356″]

    Margins

    Change worksheet orientation: portrait, landscape. Change paper size.

    In the same dialog box, under the ‘Page’ tab, the ‘Paper Format’ options can be selected to make changes to the paper size and worksheet orientation.

    Paper Format

    Adjust page setup to fit worksheet contents on a specified number of pages.

    In the same dialog box, under the ‘Sheet’ tab, the ‘Scale’ options can be altered to fit the worksheet contents on a specified number of pages. When ‘Scaling mode:’ is selected as ‘Fit print range(s) on number of pages’, then the worksheet contents will be printed on a specific number of pages as selected in the ‘Number of Pages:’ option.

    Page Scale

    Add, edit, and delete text in headers, footers in a worksheet.

    In the same dialog box, under the ‘Header’ or the ‘Footer’ tab, you will find the ‘Edit’ button. Click on this button and a new dialog box will appear. This dialog box provides the options for entering contents in the header or footer of a worksheet.

    Header

    Header Style

    Insert and delete fields: page numbering information, date, time, file name, worksheet name into headers, footers.

    In the same dialog box, which was displayed after clicking on the ‘Edit’ button, the different options for inserting fields like date, time, worksheet name and page numbers are present. In the ‘Custom Headers’ section, there are different icons for adding text, sheet name, date, time and page numbering information to the headers and the footers.

    Custom Head

    [the_ad id=”12397″]
    [the_ad id=”13529″]

  • Changing The Spreadsheet Chart

    Change the column, bar, line, pie slice colors in the chart.

    To change the column, bar, line, or pie slice color in a chart, simply double-click on the respective element for which you want to change the color. If it is a bar chart, double-click on the individual bar, and if it is a pie chart, double-click on the pie for which the color is required to be changed. Do likewise for the other chart types. This double-clicking will open the ‘Data Series’ dialog box.
    [the_ad id=”12355″]
    [show_slider name=changing-the-spreadsheet-chart]
    [the_ad id=”12356″]
    Chart Colour Area

    In this dialog box, under the ‘Area’ tab, we have a ‘Fill’ drop down list. From this list, select the appropriate color and click on ‘OK’. This will change the color of the selected element in the chart.

    Change font size and color of chart title, chart axes, and chart legend text.

    To change the font size of the chart title, first of all select the chart by double-clicking on it. A grey border should surround the chart upon selection. After this, right click on the chart title and from the resulting menu, click on ‘Format Title’. This will display the ‘Main Title’ dialog box.Chart Font

    In this dialog box, under the ‘Font’ tab, we have a ‘Size’ drop down list. From this list, select the appropriate font size and click on ‘OK’. This will change the font size of the chart title.

    In the same dialog box, under the ‘Font Effects’ tab, we have a ‘Font color’ drop down list. From this list, select the appropriate font color and click on ‘OK’. This will change the font color of the chart title.

    Chart Font Colour

    To change the font size and color of the chart axes, we need to follow similar steps. First of all select the chart by double-clicking on it. A grey border should surround the chart upon selection. After this, right click on the axes text and from the resulting menu, click on ‘Format Axis’. Doing this for the x-axis will open the ‘X Axis’ dialog box whereas doing these same steps for the y-axis will display the ‘Y Axis’ dialog box.

    In both these dialog boxes, we have the ‘Font’ and ‘Font Effects’ tabs. These tabs have the same functionality as we have seen above for some similar dialog boxes. We have the ‘Size’ and ‘Font color’ drop-down lists in these dialog boxes from where we can choose the appropriate font color and font size for the axes text.

    Chart X Axis Font

    Chart Y Axis Font

    To change the font size and font color for the legend text, we need to follow similar steps as we have seen above. First select the chart and then right-click on the legend text area and from the resulting menu, click on ‘Format Legend’. This will open the ‘Legend’ dialog box.

    In this dialog box, we have the same ‘Font’ and ‘Font Effects’ tabs under which we have the ‘Size’ and ‘Font color’ drop-down lists. The appropriate values can be selected from these lists. After this, click on ‘OK’. This will change the font size and font color for the legend text.

    Chart legend Font

    [the_ad id=”12397″]
    [the_ad id=”13529″]

  • Edit Spreadsheet Chart Title

    When a chart is created, then in the ‘Chart Wizard’, under the ‘Chart Elements’ tab, we have the option to add a ‘Title’ for the chart. Appropriate title can be added in this tab during the creation of the chart.
    [the_ad id=”12355″]
    [show_slider name=edit-spreadsheet-chart-title]
    [the_ad id=”12356″]
    Chart Elements

    Another way is to first create a chart, then select it by double clicking, and then right click on the chart area. This gives a menu from which ‘Insert Titles’ can be selected. This gives a ‘Title’ dialog box from where we can add a title, remove a title and also edit the title. If the title is already there, just delete the title and click on ‘OK’. This will remove the title.

    Similarly, by changing the title and clicking on ‘OK’, we can edit the title.

    Chart Title

    Enter Chart Title

    Add data labels to a chart: values/numbers, percentages.

    To add data labels to a chart, select the chart by double clicking on it. After selecting the chart, click on ‘Insert’ button from the main menu bar and then click on ‘Data Labels’ from the resulting drop down menu. This will open the ‘Data Labels for all Data Series’ wizard. Under ‘Text Attributes’, we can check or uncheck the number or percentage data labels as per the requirement.

    Chart data labels

    Chart Text Attributes

    If the ‘Show value as number’ checkbox is checked, then the output will be as follows.

    Show Value as numbers

    Change chart area background color, legend fill color.

    To change the chart area background color, first of all select the chart by double-clicking on it. A grey border should surround the chart upon selection. After this, right click on the chart area and from the resulting menu, click on ‘Format Chart Area’. This will display the ‘Chart Area’ dialog box.

    Chart Fill Area

    In this dialog box, under the ‘Area’ tab, we have a ‘Fill’ drop down list. From this list, select the appropriate color which is required for the background of the chart and click on ‘OK’. This will change the chart background color.

    To change the chart legend fill color, first of all select the chart by double-clicking on it. A grey border should surround the chart upon selection. After this, right click on the legend area, the area where the legends key is displayed, and from the resulting menu, click on ‘Format Legend’. This will display the ‘Legend’ dialog box.

    Chart Format Legend

    In this dialog box, under the ‘Area’ tab, we have a ‘Fill’ drop down list. From this list, select the appropriate legend fill color and click on ‘OK’. This will change the chart legend fill color.

    [the_ad id=”12397″]
    [the_ad id=”13529″]