In this post, let’s look at how we can move, copy and paste our data on the sheet, starting with the basics and then introducing some lesser-known methods that will save you time and effort. Moving cells (drag & drop, cut & paste) Copying and pasting cells Paste special (values, format, all except borders, formulas, transpose)… Continue reading Google Sheets – Moving, copying & pasting data
Category: Sheets
Google Sheets – The cell references: Relative & Absolute
Here we’re going to look at how references to cells will allow you to do multiple calculations really quickly. We’ll look at: How to reference cells with each other How to quickly copy formulas across other cells How cell references change when they are moved around the sheet (relative cell references) How you can fix… Continue reading Google Sheets – The cell references: Relative & Absolute
Google Sheets – Controlling rows & columns (Part 2)
Let’s look at some further ways you can control your rows and columns: Selecting multiple rows or columns There are two ways to select more than one row or column. First, if the rows or columns you want to select are all next to each other, then simply click on the first one and drag… Continue reading Google Sheets – Controlling rows & columns (Part 2)
Google Sheets (1) – The basics
[et_pb_section bb_built=”1″ admin_label=”section”][et_pb_row admin_label=”row” background_position=”top_left” background_repeat=”repeat” background_size=”initial”][et_pb_column type=”4_4″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left” border_style=”solid” background_position=”top_left” background_repeat=”repeat” background_size=”initial” _builder_version=”3.0.51″ custom_margin=”-100px|||”] Google Sheets is a wonderful spreadsheet program which can make your working life so much easier. So, what can it be used for? Calculations The number one use is manipulating data. Data is entered and the program can then be… Continue reading Google Sheets (1) – The basics