Site Map - skip to main content

Hacker Public Radio

Your ideas, projects, opinions - podcasted.

New episodes every weekday Monday through Friday.
This page was generated by The HPR Robot at


hpr1505 :: 28 - LibreOffice Calc - Fills, an Introduction

This episode looks at the filling rows and columns using click-and-drag.

<< First, < Previous, , Latest >>

Thumbnail of Ahuka
Hosted by Ahuka on 2014-05-09 is flagged as Clean and is released under a CC-BY-SA license.
LibreOffice, Calc, Spreadsheet, fills. (Be the first).
The show is available on the Internet Archive at: https://archive.org/details/hpr1505

Listen in ogg, spx, or mp3 format. Play now:

Duration: 00:15:03

LibreOffice.

In this in-depth series on LibreOffice we examine Writer, Calc and Impress

One of the key techniques in using a spreadsheet is to master the art of fills, which lets you fill a column or a row with data without having to type in every cell individually. And this technique requires that there be a predictable pattern to the contents of each cell as you fill them. But you can do a lot with this technique, and we will want to use this when we do our first model, which will be a simple savings model.

But first we need to build the tools in our tool kit, and fills are a big one. To begin with, you can fill either rows or columns, though columns are more frequently filled using this technique. Still, it is good to know you can do either. The simplest fill begins with a cell that has some kind of contents. For example, lets say that cell B1 contains the word "Rain". If you click on the cell, you will see it highlighted with a thick black border

For the remainder of the show notes please see https://www.ahuka.com/?page_id=734


Comments

Subscribe to the comments RSS feed.

Leave Comment

Note to Verbose Commenters
If you can't fit everything you want to say in the comment below then you really should record a response show instead.

Note to Spammers
All comments are moderated. All links are checked by humans. We strip out all html. Feel free to record a show about yourself, or your industry, or any other topic we may find interesting. We also check shows for spam :).

Provide feedback
Your Name/Handle:
Title:
Comment:
Anti Spam Question: What does the letter P in HPR stand for?
Are you a spammer?
What is the HOST_ID for the host of this show?
What does HPR mean to you?