Automate Your Workflow: 6 Powerful Google Sheets & Docs Hacks

📊ExcelQuickGuide

1.1 📌 Introduction to Google Sheets

Google Sheets is a free, web-based spreadsheet tool provided by Google. It allows users to create, edit, and share spreadsheets online while collaborating in real time. It is part of Google Workspace (formerly G Suite).

Key Features:

Cloud-based, accessible from any device with internet access.
Auto-save functionality — no need to manually save files.
Collaboration tools — multiple people can edit the same file simultaneously.

1.2 🔍 Getting started

To begin using Google Sheets:

Go to sheets.google.com.
Sign in with your Google account.
Click on the blank template or choose one from the Template Gallery.

You'll see a grid of cells arranged in rows and columns. This is your workspace.

1.3 🧪 Define Ranges

A range is a group of selected cells. You define a range when applying formulas, formatting, or data validation.

How to Select a Range:

Click and drag across the cells you want to include.
Note the notation: A1:A5 means column A, rows 1 through 5.

Named ranges: You can assign a name to a range for easy reference in formulas.

Go to Data > Named ranges and give your selection a name like "Sales2025".

1.4 🔍 Define Fill

Fill is used to quickly duplicate content or apply a pattern in cells.

Using Fill:

Type a value in a cell.
Click the small square at the bottom-right corner of the cell (fill handle).
Drag it across the range you want to fill.

Tip: Use Fill Series (under Edit > Fill) to auto-fill dates, numbers, or patterns.

1.5 🧪 Move Cells

You can move cells to reorganize your data.

Steps:

Select the cell or range.
Hover until the cursor becomes a hand.
Click and drag to the new location.

Alternative: Use cut (Ctrl + X) and paste (Ctrl + V).

1.6 🔍 Add Cells

Adding cells means inserting new rows, columns, or individual cells.

Add a New Row:

Right-click the row number.
Select "Insert 1 above" or "Insert 1 below".

Add a New Column:

Right-click the column letter.
Select "Insert 1 left" or "Insert 1 right".

Insert a Cell:

Right-click on a cell and choose "Insert cell".
Select "Shift right" or "Shift down".

Keyboard Shortcut: Ctrl + Shift + = (Windows) or ⌘ + Shift + = (Mac)

Warning: Inserting cells can affect formulas. Use Undo (Ctrl + Z) if needed.

1.7 📌 Delete Cells

Deleting cells removes data and optionally shifts other cells to fill the space.

Right-click the cell or selected range you want to delete.
Select "Delete cells" from the menu.
Choose whether to shift cells left or up.

Tip: Deleting entire rows or columns can be done by right-clicking the row number or column letter and selecting "Delete".

1.8 🔍 Undo Redo

The Undo and Redo functions help you correct or revisit actions.

Undo: Ctrl + Z (Windows) / ⌘ + Z (Mac)
Redo: Ctrl + Y (Windows) / ⌘ + Y (Mac)

These buttons also appear in the top toolbar as curved arrows. Use them to move back or forward through your last edits.

1.9 🧪 Formulas in Google Sheets

Formulas perform calculations using cell data. All formulas start with =.

Examples:

=A1+B1 adds two cells
=SUM(A1:A5) adds a range of numbers
=AVERAGE(B2:B10) calculates the mean

Google Sheets will automatically suggest formulas as you type.

1.10 🔍 Relative Reference

Relative references change when copied across cells.

Example: If =A1+B1 is in C1 and you copy it to C2, it becomes =A2+B2.

This is helpful when applying the same logic to multiple rows or columns.

1.11 🧪 Absolute Reference

Absolute references stay fixed when copied. Use $ to lock rows/columns.

$A$1 locks both column and row
A$1 locks only the row
$A1 locks only the column

Useful for constants like tax rates or conversion factors.

1.12 📌 Arithmetic Operators

Operators let you perform basic calculations:

+ for addition
- for subtraction
* for multiplication
/ for division
^ for exponentiation

1.13 🧪 Parentheses

Parentheses control the order of operations in formulas.

Example: =(A1+B1)*C1 ensures addition happens before multiplication.

1.14 🔍 Functions

Functions are built-in operations that simplify tasks.

SUM() — totals values
AVERAGE() — finds the mean
IF() — conditional logic
COUNT() — counts numeric entries

Start with = and type the function name.

1.15 🧪 Location settings

Google Sheets formats numbers, dates, and currencies based on your locale.

Click File > Settings.
Go to the General tab.
Set your Locale and Time Zone.

1.16 🔍 Google Sheets Formatting

Formatting makes your data readable and professional.

Bold/Italic/Underline
Font size and style
Text alignment
Cell background color

Use the toolbar or Format menu for quick styling.

1.17 📌 Google Sheets Format Painter

Format Painter copies formatting from one cell to another.

Select a formatted cell.
Click the Paint Format button (paint roller icon).
Click on the destination cell to apply the format.

1.18 🔍 GS Format Colors

Use colors to highlight data.

Select a cell or range.
Click the Fill color or Text color buttons on the toolbar.

1.19 🧪 GS Format Fonts

Fonts help structure and beautify data.

Change font style: Arial, Roboto, etc.
Adjust font size and emphasis (bold, italic).

1.20 🔍 GS Format Borders

Add borders to separate or emphasize cells.

Select cells.
Click the Border icon in the toolbar.
Choose border styles (inside, outside, thick, dotted).

1.21 🧪 GS Format Numbers

Change how numbers display.

Currency
Percent
Decimal places
Date formats

Use the Format > Number menu or toolbar buttons.

1.22 🔍 GS Format Grids

Gridlines improve data visibility but can be hidden for design.

Click View > Show.
Toggle Gridlines on or off.

1.23 🧪 GS Format Clear

To reset formatting or remove content:

Select the cells.
Click Edit > Clear or use the right-click menu.
Choose to clear Format, Contents, or All.