LibreOffice
Showing posts with label CALC. Show all posts
Showing posts with label CALC. Show all posts

REMOVING BACKGROUND ON SHEET LIBREOFFICE CALC

April 28, 2022  
Removing background images in LibreOffice Calc is different from MS. Excel. But it's so easy.

1. Select Menu View
View

2. Select Navigator or press the F5 key, it will open the Navigator window
Navigator

3. Click on the down arrow on Image or double-click Image
images

4. Double click on image 1, image 2, or image 3, to remove the background
Images 1

5. When the image is active, press the Delete / Backspace button, and the background image will be deleted
Delete/ Backspace

 Continue Reading

CHANGING BACKGROUND TO FOREGROUND ON SHEET LIBREOFFICE CALC

April 07, 2022  
Do you want to make an image that has been used as a background in LibreOffice Calc into a logo? then the background image can be changed back into the foreground so that it is easier to set up to be used as a logo. The method is as follows.

1. Select View Menu

2. Select Navigator

3. The navigator display will open then select Image

4. Then double click image 1, then the image will be active


when the image is active, then there are two ways to make the background image the foreground.


FIRST METHOD
1. Select Format Menu

2. Select Arrange

3. Select To Foreground


SECOND METHOD
1. Right-click on the picture you want to make a foreground
2. Select Arrange

3. Select To Foreground


After following these steps your background image is now foreground and covers the cells. Now it's time to adjust the image size and place the image where you want it.

























 Continue Reading

SETTING THE BACKGROUND POSITION ON THE SHEET LIBREOFFICE CALC

March 17, 2022  
If you want to adjust the position of the background image in LibreOffice, it's very easy.

1. Select View Menu 
View

2. Select Navigator or press F5, it will open a navigator box
Navigator

3. Double click Image, a selection of images will appear with the names image 1, image 2, image 3
4. Double click on image 1, image 2, or image 3 to activate it

5. If the image is already active, hover over the center of the image so that the cursor changes to a plus sign
6. Click and hold the image then place it in the position you want.
 Continue Reading

CHANGE THE BACKGROUND SIZE ON THE SHEET IN LIBREOFFICE CALC

February 10, 2022  
Resizing the background image on a sheet in LibreOffice Calc is easy, here's how.

1. Select View Menu
View
View

2. Select Navigator or press the F5 key it will open a navigator window
Navigator

3. Click the down arrow next to Image or double click Image
Image

4. Double-click on Image 1, Image 2, or Image 3, according to the image you want to resize.
Image 1
 
5. If the image is already active then place the cursor on the dot next to the image and wait until the cursor turns into an arrow
Kursor
 
6. Click on the arrow, then hold and drag to the desired size
ukuran yang disesuaikan
 Continue Reading

ADDING BACKGROUND TO THE SHEET IN LIBREOFFICE CALC

February 01, 2021  
To enhance the appearance of the sheet, you can add an image as display background. The method is as follows:

1. Make sure you are on the sheet you want to add a Background to
2. Then select the Insert Menu
Insert

3. Select Image
Image

 4. Select an image to be used as the background
5. Select Open
pilih gambar

6. In this way, you will find the image on the sheet, but not yet the Background. There are two ways to make the picture a Background.

FIRST METHOD
1. Make sure that the image you want to make as the Background is selected
2. Select the Format Menu
Format

 3. Select Arrange
Arrange

 4. Select To Background
To Background
THE SECOND METHOD
1. Right-click on the image that you want to make Background
klik kanan

 2. Select Arrange
Arrange

 3. Select To Background
To Background

 This way, you will get an image that is already placed as the Background. The result is as shown below.
Background

 Continue Reading

GIVING COLOR TAB SHEET ON LIBREOFFICE CALC

January 25, 2021  
Apart from giving a name to the Sheet Tab, you can also change the color on the Sheet Tab for easy identification of the sheet. There are two ways to change the color of the Sheet Tab, namely:

FIRST METHOD
1. Make sure you are on the tab you want to change color.
2. Select Menu Sheet
Menu Sheet

3. Select Sheet Tab Color
Sheet Tab Color

 4. Continue by selecting a color for the active sheet tab
Colour Pallete

5. Click Ok
THE SECOND METHOD
1. Right-click on the Sheet Tab for which you want to change the color
Tab sheet

2. Select Tab Colour
Tab Color

3. Continue by selecting a color for the active sheet tab
Colour Pallete

4. Click Ok
After that, you will find that the Sheet Tab display has changed its color. These colors will certainly make it easier for you to identify the sheet. The result is as shown below.
 Continue Reading

CHANGING THE NAME OF SHEET IN LIBREOFFICE CALC

January 18, 2021  
By default, sheets in a workbook are named Sheet1, Sheet2, Sheet3. And then, you can change the sheet name to be more specific and easily recognizable.
There are three ways to change the sheet name, which are as follows.

FIRST STEP
1. Select Menu Sheet


2. Select Rename Sheet


3. Type a new name for the sheet


4. Select OK


THE SECOND WAY
1. Right-click on the Sheet tab you want to rename


2. Select Rename Sheet


3. Type a new name for the sheet


4. Select OK


THE THIRD WAY
1. Double click on the Sheet tab you want to rename


2. Type a new name for the sheet


3. Select OK


Please try the three easiest ways for you to change the name of the sheet. Continue Reading
Subscribe to: Posts (Atom)
Designed By: Blogger Templates | Templatelib