#LIBREOFFICE SPREADSHEET FULL#

Another way to change your zoom is the slider in the bottom right hand corner. To zoom to a particular percentage View ‣ Zoom and select the percentage you want. To view the whole width of your page on the menu View ‣ Zoom ‣ Page Width.

#LIBREOFFICE SPREADSHEET FULL#

To zoom to view a full page on your spreadsheet in the menu View ‣ Zoom ‣ Entire Page.

To redo an operation press Control +y or the number looping to the right and exiting to the left. To undo a selection press control +z or press the button with the arrow looping around and pointing to the left. If you want the reverse order to this you can have Data ‣ Sort Descending. To sort your data like a bunch of names first select all the cells with the mouse Data ‣ Sort Ascending. To change the size of a row or column of cells click in between the border of that particular row or column and drag with the mouse to give yourself room. To delete a row or column right click the number and select Delete rows or Delete Column. To insert a row below the current row right click on the number and Insert Row Below. To insert a row above the current row right click on the number and Insert Row Above. If you want the new column to the right is right click on the letter and Insert Column After. If you want to insert a new column to the left of a column right click on the letter for the column Insert Column Before. To remove an image from your spreadsheet press the Delete key. To save an image in a spreadsheet right click on the image and select Save. To change what image shows on the spreadsheet right click on the image and select Replace. To stretch on shrink your image vertically click on the box on the top or bottom and drag to your desired position. To stretch or shrink an image horizontally left click on the boxes on the left or right hand side and then release when in the giant position. To resizing your image while keeping the same aspect ratio click on the box on a corner of your image. To select an image to change how it appears in your spreadsheet left click on it. To switch back to your original style Styles ‣ Default. To have a slightly smaller heading Styles ‣ Heading 2.

To style a cell like a heading Styles ‣ Heading 1. To bring even less attention to a cell Styles ‣ Accent 3. To bring slightly less attention to a cell Styles ‣ Accent 2. To style part of your spreadsheet to bring lots of attention to a cell Styles ‣ Accent 1. To move an image in from the gallery to your spreadsheet left click on the image and drag the image to where you want. To get a list of different categories of images beneath Galleries and left click to select your image. To see a gallery of stock images for your spreadsheet View ‣ Gallery.

To close this function sidebar press the x button. To sort by different categories of functions use the drop down menu to the right of the fx button. To insert a function press the fx button. To select different functions left click on the function name in the column. To view a long list of functions to use View ‣ Function List. To view values highlighted in another color to see them easier press Control+F8 or View ‣ Value Highlighting. To switch back to a normal number press Control+Shift+1 or Format ‣ Number Format ‣ Number. To change to percentage press Control+Shift+5 or Format ‣ Number Format ‣ Percentage. To change to showing currency for the number press Control+Shift+4 or Format ‣ Number Format ‣ Currency. If you want to paste your text unformatted press Control+Shift + Alt+V or Edit ‣ Paste Unformatted Text. To cut text press control+x, right click Cut, or press the scissors button to cut text. To paste data press control control +v, Edit ‣ Paste, right click Paste, or press the button that is a clipboard with a piece of paper on it.

To copy data you can right click Copy, press the button with two pieces of paper or press control + c. To open a recent document File ‣ Recent Documents. To open a file press the button that looks like a brown folder and add select the file you want from the dialog or File ‣ Open. To save with a different file name File ‣ Save as. To save your spreadsheet you need to press the button that looks like a floppy disk, press the keyboard shortcut or go to File ‣ Save. To sort in ascending order press the button with bullet points and an arrow pointing upwards. To sort your cells in descending order press the button with bullet points and an arrow going down. To sum data from cells in the cell where you want the sum is to press the button that looks like Σ character and then drag the mouse over the cells you want to add. To select cells left click and drag to select the cells you want. To enter data into cells type in the keyboard. To move between cells press the arrow keys in the direction you want to move.

Libreoffice spreadsheet