Tag Archives: OpenOffice Calc

Some worksheets contain cells that have been left blank, e.g., in order to make the headings and subheadings easier to read. However, if for example you want to sort or filter the list or you want to use the table for analyses, you need to fill in the blanks. You could manually copy the value from the first filled cell above the blanks. An easier and faster way to do this is described on this site. The technique they describe requires the Go To function, which unfortunately is not available in Openoffice’s Calc. However, there is an alternative way (which works also in Excel). Continue reading →