Proceed as for deleting a single column or row above.Multiple columns or rows can be deleted at once rather than deleting them one at a time. Select Delete Columns or Delete Rows from the pop-up menu.To add a row to the spreadsheet, select any cell. This section will describe how to do this. Right-click on the column or row header. Sometimes we need to ad new rows or columns into our spreadsheet.Select the column or row to be deleted.Proceed as for inserting a single column or row above.Ĭolumns and rows can be deleted individually or in groups.Ī single column or row can only be deleted by using the mouse:.Highlight the required number of columns or rows by holding down the left mouse button on the first one and then dragging across the required number of identifiers.Multiple columns or rows can be inserted at once rather than inserting them one at a time. Select the column or rows where you want the new column or row inserted.Select either Insert > Columns or Insert > Rows.Ī single column or row can also be added using the right-click (context) menu:.Select the column or row where you want the new column or row inserted.Cells in the new columns or rows are formated like the corresponding cells in the column or row before (or to the left of) which the new column or row is inserted.Ī single column or row can be added using the Insert menu:.
New rows are inserted above the first highlighted row.New columns are inserted to the left of the first highlighted column.But if you do it like this, it will adjust each formula to match the current cell as you require.Columns and rows can be inserted individually or in groups. I found the only thing that worked for me was to drag top-left to bottom-right across the cells, and then enter the value of the bottom right cell in the formula (in this case 'F13'). 'F13') is also not particularly logical, the cell you have to put in here depends on how you dragged out the selection on the cells before selecting 'conditional formatting'. So to match the word 'yes' anywhere in a cell's text content, you could use: The open office help says that COUNTIF uses regular expressions for matching the text - hence the '.*' before and after the 'P' (when looking for cells that only contain an exact phrase match i've had mixed success with a straight "P" test - it seems to work in conditional formatting formulas, but not in cells). This tests for the character 'P' anywhere in the text of each cell in turn. I'm sure there must be an easier way, but here's what I came up with to test a cell to see if it contains a text string value in conditional formatting:
0 kommentar(er)
