Excel and Calc

DUPLICATE DATA ENTRY

Want to enter the same data into more than one cell at once? Enter your first cell’s data, then click and drag the selection right (columns) or down (rows) to fill those cells with the same information. Once done, click and drag again if you want to duplicate the data across multiple cells or columns at once. To duplicate data across multiple sheets, select all the sheets (use Shift-Ctrl as you click each one), then type your data. It’ll be replicated in the equivalent cell across your selection.

FREEZE ROWS AND COLUMNS

When you work in large spreadsheets, it’s common to define the first row and/ or column as headings or titles to help you navigate your data. Of course, as your spreadsheet grows, those header fields disappear. Prevent that happened by ‘freezing’ these key rows or columns so they always remain visible.