The following shows the protect sheet dialogue. You can protect the current sheet of the whole document, by clicking on Menu -> Tools -> Protect Document -> Sheet (or Document). Once you’ve created the list of value, click on any cell in this column, which will show the drop-down list with the values you just created as shown below. In the Entries text box, enter the list of values that you want to be created as part of the list of values. From “Criteria” tab, select “List” in the drop-down for “Allow”.
To create list of values based on the data from the columns, select the column, click on Menu -> Data -> Validity. To use this, click on Menu -> Format -> Conditional Formatting. You can also combine multiple conditions using OR/AND conditions. For example, if the cell value is “Technology”, you can set a custom background, and font to the cell or row. Using conditional formatting, you can format a specific cell or row only based on a certain condition. Select the table in the spreadsheet, and click on Menu -> Format -> Autoformat. Instead of manually formatting your tables with different font colors and background, you can use one of the builtin table autoformat as shown below. The following is the list of some Openoffice calc spreadsheet tips and tricks. OpenOffice Calc offers pretty much most of the functionalities that are in Microsoft Excel.
#Openoffice calculate sheet download#
On Windows, instead of spending money on Microsoft Office, download and use Openoffice.
On Ubuntu, OpenOffice is the default office suite. Optimizes the column width or row height based on the current cell.OpenOffice works on both Linux and Windows. Increases the width of the current column.ĭecreases the width of the current column. Opens the Styles and Formatting window where you can apply a formatting style to the contents of the cell or to the current sheet. Recalculates all of the formulas in the sheet. Highlights cells containing numeric values (not text). Turns additional selection mode on or off. Opens the Thesaurus if the current cell contains text. Rearranges the relative or absolute references (for example Shows or hides the Database Sources menu. Moves the cursor to the input line where you can enter a formula for the current cell. If the cursor is in an input box in a dialog that has a minimize button Switches to Edit mode and places the cursor at the end of the contents of the current cell. When the help browser is already open F1 jumps to the main help page.ĭisplays the note that is attached to the current cell. The / key is the division sign on the numeric key pad.ĭisplays the OOo help browser. Selects the matrix formula range that contains the cursor. The * key is the multiplication sign on the numeric key pad. A range is a contiguous cell range that contains data and is bounded by empty row and columns. Selects the data range that contains the cursor. If all the sheets in a spreadsheet are selected If all the sheets in a spreadsheet are selectedĪdds the next sheet to the current selection of sheets. Moves the viewable columns one screen to the right.Īdds the previous sheet to the current selection of sheets. Moves the viewable columns one screen to the left. In the page preview it moves to the next print page. In the page preview it moves to the previous print page. Selects all cells containing data from the current cell to the end of the continuous range of data cells If the row below the cell that contains the cursor is empty Moves the cursor to the bottom edge of the current data range. If the row above the cell that contains the cursor is empty
Moves the cursor to the top edge of the current data range. If the column to the right of the cell that contains the cursor is empty Moves the cursor to the right edge of the current data range. If the column to the left of the cell that contains the cursor is empty Moves the cursor to the left edge of the current data range. Moves the cursor to the last cell of the current row in a column containing data. Moves the cursor to the first cell of the current row. Moves the cursor to the last cell on the sheet that contains data. Moves the cursor to the first cell in the sheet (A1).
0 kommentar(er)
