What are you trying to do?
Type it in plain words — like "make a budget" or "print on one page."
Hello, and welcome. Maybe you keep the Christmas card list on index cards. Maybe the household budget lives in a spiral notebook, or your list of medications is on a sheet of paper folded in your wallet. All of those work. But a spreadsheet can keep them neater, add up the numbers for you, put the names in order with one click, and print a tidy copy whenever you need one.
I'm Bill. For more than 30 years I've helped people make sense of their technology, and spreadsheets are one of the things people tell me they "never quite figured out." The good news is that you only need a small part of Excel or Google Sheets to get real use out of them. This guide teaches that part, slowly, in plain English, one step at a time.
It's for anyone who has opened Excel or Google Sheets, seen a sea of little boxes, and closed it again. You don't need to know any math beyond adding and subtracting, and you don't need to buy anything: Google Sheets is free, and so is Excel in a web browser.
You can't break a computer by typing in a spreadsheet. Every program in this guide has an Undo button, and both Excel and Google Sheets keep earlier versions of your files you can go back to (Undo and Version History: Going Back in Time). Click around, try things, make a practice sheet called "Test." The two moments that deserve a pause are sorting only part of a list (Sort and Filter Your List shows the safe way) and enabling content or macros in a file someone sent you (Spreadsheet Scams: Fake Invoices and Macro Tricks: don't, unless you made it).
And you're never stuck alone. If you'd like a hand, call me at (330) 200-8042 and we'll sort it out together. There's no such thing as a silly spreadsheet question.
— Bill
Call Bill and he'll walk you through it — or come do it for you.
A spreadsheet isn't just a fancier sheet of paper. These three everyday features do real work for you, and they're free in Google Sheets and in Excel.
Checked against Microsoft Support (Use AutoSum to sum numbers in Excel; Create a simple formula in Excel) on November 15, 2026.
Checked against Google Drive Help (Share files from Google Drive; Stop, limit, or change sharing) via the Google Drive manual's research, and Microsoft Support (Share your Excel workbook with others) on November 15, 2026.
Checked against Google Docs Editors Help (Find what's changed in a file) and Microsoft Support (View previous versions of Office files) on November 15, 2026.
Want a hand setting any of this up? I can walk you through it — $49 remote · $99 in your home. Call (330) 200-8042.
Call Bill and he'll walk you through it — or come do it for you.
A spreadsheet is a page of graph paper on your screen. Each little box can hold a word, a number, a date or a small calculation. Line the boxes up and you have a list; add a total at the bottom and you have a budget. That's really all it is.
Microsoft Excel and Google Sheets are the two spreadsheet programs most people use. They look almost the same and work almost the same, so everything you learn in one carries over to the other. This guide shows both, side by side.
| Word | What it means |
|---|---|
| Cell | One little box. You click a cell to type in it. The selected cell has a thick border around it. |
| Column | A line of cells running up and down. Columns are named with letters: A, B, C across the top. |
| Row | A line of cells running side to side. Rows are numbered 1, 2, 3 down the left edge. |
| Cell address | A cell's name: its column letter, then its row number. B3 is column B, row 3, just like a seat in a theater. |
| Range | A block of cells, written with a colon: B2:B10 means B2 down to B10. |
| Tab (sheet) | One page of the file. The tabs sit along the bottom edge, like dividers in a binder. A file can hold several: "January," "February," and so on. |
| Workbook | Excel's word for the whole file, with all its tabs. Google calls it a spreadsheet. |
| Formula | A little calculation you type into a cell, always starting with an equals sign, such as =B2+B3. Your First Formula: Adding and Subtracting explains. |
| Formula bar | The long white strip above the grid. It shows what's really inside the selected cell, including any formula. |
| Header row | The first row, where you type the headings for each column, like Name, Address, Phone. |
Call Bill and he'll walk you through it — or come do it for you.
You don't have to choose forever, and plenty of people use both. Here's the honest comparison in plain terms.
| Microsoft Excel | Google Sheets | |
|---|---|---|
| Cost | Full program comes with a Microsoft 365 subscription or Office Home 2024. A simpler version is free in a web browser. | Free with any Google (Gmail) account. |
| Where it runs | Installed on a Windows PC or Mac, plus the web and phone apps. | In a web browser, plus phone and tablet apps. |
| Where files live | On your computer or in OneDrive, Microsoft's online storage. | In Google Drive, Google's online storage. |
| Saving | AutoSave when the file is in OneDrive; otherwise you save it yourself. | Saves itself as you type, always. |
| Sharing | Good, through OneDrive. | Excellent, and very easy. |
| Best for | People who already have it, or who get Excel files from family, clubs or work. | Free, simple lists you share with family on any device. |
If you've used my Word and Google Docs manual, this will feel familiar: same companies, same idea, same buttons in many of the same places.
Call Bill and he'll walk you through it — or come do it for you.
Before you pay for anything, know that there are free ways to use both programs. Here are your choices.
If you have a Gmail address, you already have Google Sheets. Open your web browser and go to sheets.google.com, and sign in with your Google account. Your spreadsheets are stored in Google Drive and count toward the free 15 GB of storage your Google account comes with, which is far more than a lifetime of lists and budgets will ever need.
Checked against Google One Help (How your Google storage works) (sibling check) on November 15, 2026.
| Option | What it costs | What you get |
|---|---|---|
| Excel for the web | Free with a Microsoft account | A simpler Excel in your browser, at microsoft365.com. Files save to OneDrive (5 GB free). Fine for lists and budgets. |
| Microsoft 365 Personal | $9.99 a month or $99.99 a year | Full Excel, Word, PowerPoint and more on your computers, phones and tablets, plus 1 TB of OneDrive, for one person. |
| Microsoft 365 Family | $12.99 a month or $129.99 a year | The same, shared with up to five other people. |
| Office Home 2024 | $179.99, paid once | Excel, Word, PowerPoint and OneNote for one PC or Mac, yours to keep. No new features later and no large OneDrive storage. |
Checked against the Microsoft Store plan comparison page and Microsoft Support (What's the difference between a Microsoft 365 subscription and free web apps) (sibling check) on November 15, 2026.
Checked against Microsoft Support (End of support for Office 2021) (sibling check) on November 15, 2026.
Call Bill and he'll walk you through it — or come do it for you.
Starting a spreadsheet is just like taking a fresh sheet of paper out of the drawer. Here's how in each program.
Checked against Microsoft Support (The Microsoft 365 app transition to the Microsoft Copilot app) (sibling check) on November 15, 2026.
Call Bill and he'll walk you through it — or come do it for you.
This is the chapter that saves the most heartache. A spreadsheet you can't find is no use at all, so let's give each one a clear name and know where it lives.
Google Sheets saves every change the moment you make it. There's no Save button to forget. You only need to give the file a name:
In Excel, how saving works depends on where the file is kept. When the file is saved in OneDrive, the AutoSave switch at the top left is on, and Excel saves your changes every few seconds, just like Google Sheets. When the file is saved only on your computer, you save it yourself.
Checked against Microsoft Support (What is AutoSave?; View previous versions of Office files) on November 15, 2026.
| Where you work | Where to look |
|---|---|
| Google Sheets | Go to sheets.google.com. Your spreadsheets are listed, newest first. Use the search box at the top to type part of the name. They're also in drive.google.com. |
| Excel (desktop) | Open Excel. The opening screen lists Recent files. Or click File > Open and look in OneDrive or Documents. |
| Excel for the web | Go to onedrive.com or microsoft365.com, sign in, and look under Recent or My files. |
| Windows File Explorer | Click the OneDrive folder on the left, or Documents, and type the name in the search box at the top right. |
My Google Drive manual and my Microsoft 365 manual go further into folders, storage and finding lost files.
Call Bill and he'll walk you through it — or come do it for you.
Typing in a spreadsheet is a little different from typing a letter, because each cell is its own small box. Once you know three keys, it feels natural.
| Key | What it does |
|---|---|
| Enter | Finishes the cell and moves down one. Perfect for typing a column of names. |
| Tab | Finishes the cell and moves right one. Perfect for typing across a row: name, then street, then city. |
| Esc | Cancels what you're typing in this cell and puts back what was there before. |
Call Bill and he'll walk you through it — or come do it for you.
A few small touches turn a crowded grid into something pleasant to read: columns wide enough for the words, long notes that wrap onto a second line, and bold headings.
Checked against Microsoft Support (Change the column width and row height) on November 15, 2026.
A long note, such as "Takes with food, not with grapefruit," spills into the next cell or gets cut off. Wrapping keeps it inside its own cell on two or three lines.
Checked against Microsoft Support (Wrap text in a cell in Excel) on November 15, 2026.
Call Bill and he'll walk you through it — or come do it for you.
A format changes how a number looks without changing the number itself. Type 1250 and format it as currency, and it shows as $1,250.00. The spreadsheet still knows it's 1250, so it can add it up.
Checked against Google Docs Editors Help (Format numbers in a spreadsheet) on November 15, 2026.
Type a date the ordinary way, such as 12/25/2026, and both programs recognize it as a date. That matters: real dates sort in calendar order, while dates typed as words ("Christmas") don't.
Checked against Google Docs Editors Help (Format numbers in a spreadsheet) on November 15, 2026.
| Format | What it does |
|---|---|
| Number | Adds a comma for thousands and a fixed number of decimal places. |
| Percent | Shows 0.05 as 5%. Handy for a tax rate or a raise. |
| Plain text | Treats whatever you type as words. Useful for ZIP codes and account numbers you never add up. |
| Decrease / increase decimal | Two toolbar buttons (.0 and .00) that show fewer or more digits after the decimal point. |
Call Bill and he'll walk you through it — or come do it for you.
Here are three lists people find genuinely useful. Each one is just a header row and a few columns. Type the headings in row 1, make them bold, and start filling in.
| A | B | C | D | E | F |
|---|---|---|---|---|---|
| Name | Street | City, State ZIP | Sent 2026 | Got one 2026 | Notes |
| Mary and Tom Smith | 12 Elm St. | Kent, OH 44240 | Yes | Yes | New grandson |
Next year, add a column for 2027 instead of starting over. Sort by name (Sort and Filter Your List) and you have an alphabetical list to work from. Filter the "Sent" column to see who you haven't done yet.
| A | B | C | D | E | F |
|---|---|---|---|---|---|
| Medicine | Strength | How much and when | What it's for | Doctor | Pharmacy / refill |
| Lisinopril | 10 mg | 1 tablet each morning | Blood pressure | Dr. Patel | CVS, 30 days |
Add rows for vitamins and over-the-counter medicines too, plus a line at the top with your name, date of birth and allergies. Print it on one page (Printing a Spreadsheet That Looks Right) and take it to every appointment. Turn on Wrap Text (Making It Readable: Wider Columns, Wrap Text, Bold) for the longer instructions.
| A | B | C | D | E | F |
|---|---|---|---|---|---|
| Room | Item | Make / model | Serial number | Bought / price | Photo or receipt |
| Living room | Television | Samsung 55" | (from the back label) | 2024, $499.99 | In Drive folder |
A home inventory is a big help with an insurance claim after a fire, flood or burglary. Walk room by room. For the valuable things, take a photo of the item and its serial number label, and note where the photos are kept. Format the price column as currency (Money, Dates and Number Formats) and add a total (Totals and Averages: SUM, AutoSum and AVERAGE).
Call Bill and he'll walk you through it — or come do it for you.
Sorting puts your list in order: names A to Z, dates oldest to newest, prices highest to lowest. Filtering hides the rows you don't want to see right now, without deleting anything.
To sort only part of the sheet, select those cells and choose Data > Sort range > Advanced range sorting options, tick Data has header row, pick the column, and click Sort.
Checked against Google Docs Editors Help (Sort & filter your data, Computer) on November 15, 2026.
For more control, click Sort (the larger button) instead. Make sure My data has headers is ticked, choose the column, and click Add Level if you want a second sort, such as by city and then by name.
Checked against Microsoft Support (Sort data in a range or table in Excel; Quick start: Sort data in an Excel worksheet) on November 15, 2026.
Checked against Google Docs Editors Help (Sort & filter your data, Computer) for the Google Sheets steps on November 15, 2026.
Call Bill and he'll walk you through it — or come do it for you.
Once a list is longer than your screen, you scroll down and lose sight of the headings. Which column was the phone number? Freezing the top row keeps it pinned in place while the rest scrolls underneath.
Checked against Microsoft Support (Freeze panes to lock the first row or column in Excel for Mac and Excel for iOS) on November 15, 2026.
On a phone, the Google Sheets app can freeze rows too. On Android, touch and hold the row number and choose Freeze. On an iPhone or iPad, tap the row number, tap the right arrow in the little menu that appears, and tap Freeze.
Checked against Google Docs Editors Help (Freeze, group, hide, or merge rows & columns, Computer, Android and iPhone & iPad) on November 15, 2026.
Call Bill and he'll walk you through it — or come do it for you.
A formula is a small calculation you type into a cell. The cell then shows the answer, and the best part is that if you change one of the numbers, the answer updates by itself. No calculator, no eraser.
Every formula begins with =. Without it, the spreadsheet thinks you're typing words. After the equals sign, you can use plain numbers or, better, cell addresses.
| To do this | Type this | Means |
|---|---|---|
| Add | =B2+B3 | What's in B2 plus what's in B3 |
| Subtract | =B2-B3 | B2 minus B3 |
| Multiply | =B2*12 | B2 times 12 (the * key, Shift+8) |
| Divide | =B2/4 | B2 divided by 4 (the / key) |
Checked against Microsoft Support (Create a simple formula in Excel; Use Excel as your calculator) on November 15, 2026.
Call Bill and he'll walk you through it — or come do it for you.
Adding up a long column with plus signs would get tiresome. That's what SUM is for. It adds up a whole range of cells at once.
Click the empty cell under your column of numbers and type =SUM(B2:B20), then press Enter. That means "add up everything from B2 down to B20." The parentheses hold the range.
On a Windows PC there's a shortcut: click the cell under the numbers and press Alt and = together, then Enter.
Checked against Microsoft Support (Use AutoSum to sum numbers in Excel) on November 15, 2026.
Type =SUM( and then drag across the cells you want to add; Sheets fills in the range. Type ) and press Enter. The toolbar also has a Functions button (the sideways-M symbol) with SUM and AVERAGE on it.
| Type this | What you get |
|---|---|
| =AVERAGE(B2:B13) | The average of the range. Twelve months of electric bills, and you know your typical month. |
| =MAX(B2:B13) | The largest number in the range: the most expensive month. |
| =MIN(B2:B13) | The smallest number in the range. |
Call Bill and he'll walk you through it — or come do it for you.
Say you have twelve rows, one per month, and you want "left over" worked out for each. You don't type the formula twelve times. You type it once and fill it down.
Checked against Microsoft Support (Use AutoSum to sum numbers in Excel, copying a formula) on November 15, 2026.
Type January in a cell and drag its fill handle down: February, March, April appear on their own. The same works for days of the week, and for numbers if you type the first two (1 and 2) and select both before dragging.
Call Bill and he'll walk you through it — or come do it for you.
Now let's put it all together. This simple budget shows, for one month, what you planned to spend, what you really spent, and the difference. It takes about twenty minutes to set up, and next month you copy the tab and start again.
Call Bill and he'll walk you through it — or come do it for you.
A template is a spreadsheet someone else has already laid out for you: a monthly budget, a to-do list, a calendar, a travel planner. You open a copy, type your own figures over the samples, and the formulas are already in place.
Checked against Google Docs Editors Help (Create a file from a template, Computer) on November 15, 2026.
Checked against Google Workspace Learning Center (Use templates) on November 15, 2026.
Call Bill and he'll walk you through it — or come do it for you.
Printing a spreadsheet surprises people. One column spills onto a second page, the sheet prints with no lines between the cells, or you get twelve pages of empty boxes. A few settings fix all of that. Always check the preview before you click Print.
| Setting | Where to find it |
|---|---|
| Print area (just these cells) | Select the cells you want, then Page Layout > Print Area > Set Print Area. Only that part prints. To undo it, choose Clear Print Area. |
| Landscape (sideways) | Page Layout > Orientation > Landscape. Good for wide lists such as the Christmas card list. You can also choose it in File > Print. |
| Fit to one page | In File > Print, under Settings, change No Scaling to Fit Sheet on One Page (or Fit All Columns on One Page). Or use Page Layout > Page Setup > Page tab > Fit to 1 page wide by 1 tall. |
| Gridlines (the cell lines) | They don't print unless you ask. Page Layout > in Sheet Options, under Gridlines, tick Print. |
Checked against Microsoft Support (Set or clear a print area on a worksheet; Print an Excel worksheet in landscape or portrait orientation; Scale a worksheet; Fit to one page in Excel; Print gridlines in a worksheet) on November 15, 2026.
Checked against Microsoft Support (Print a sheet or workbook) on November 15, 2026.
Checked against Google Docs Editors Help (Print from Google Sheets, Computer) for printing and orientation on November 15, 2026.
My printer manuals cover jams, ink and connection problems; this chapter is just about getting the spreadsheet itself to look right.
Call Bill and he'll walk you through it — or come do it for you.
When a list runs to three pages, pages 2 and 3 are just columns of names and numbers with no headings. Print titles repeat your header row at the top of every printed page.
Checked against Microsoft Support (Repeat specific rows or columns on every printed page; Print rows with column headers on top of every page) on November 15, 2026.
Checked against Microsoft Support (Repeat specific rows or columns on every printed page; Print the top row on every page) on November 15, 2026.
Checked against Google Docs Editors Help (Print from Google Sheets, Computer) on November 15, 2026.
Call Bill and he'll walk you through it — or come do it for you.
Sharing means letting someone else open your file, rather than emailing them a copy. Everyone sees the same, up-to-date list. It's perfect for a family gift list, a shared medication list with an adult child, or a reunion address list that several cousins add to.
| Access | What they can do |
|---|---|
| Viewer / Can view | They can look and print, but not change anything. The safe choice for a medication list or an inventory. |
| Commenter (Sheets) | They can leave notes but not change the cells. |
| Editor / Can edit | They can change, add and delete. Use it for lists you build together. |
Checked against Google Drive Help (Share files from Google Drive; Share and manage access) (sibling check) on November 15, 2026.
Checked against Microsoft Support (Share your Excel workbook with others; Share a workbook in Excel for the web) on November 15, 2026.
Open the Share box again. Next to the person's name, open the access choice and choose Remove access (Google), or use Manage access to remove them (Excel). Click Save if asked. My Google Drive manual and my Microsoft 365 manual go into sharing in more depth.
Checked against Google Drive Help (Stop, limit, or change sharing) (sibling check) on November 15, 2026.
Call Bill and he'll walk you through it — or come do it for you.
Someone emails you an Excel file (it ends in .xlsx) but you use Google Sheets. Or the other way round. No problem: the two trade files back and forth easily.
Checked against Google Docs Editors Help (Use both Excel & Sheets: Best practices) and Google Drive Help (Work with Microsoft Office files) (sibling check) on November 15, 2026.
| Program | How |
|---|---|
| Google Sheets | File > Download > PDF. You get the same layout choices as printing: orientation, scale and gridlines. |
| Excel | File > Save As (or Save a Copy), and choose PDF in the file type list. Or print to PDF (Printing a Spreadsheet That Looks Right). |
Checked against Google Docs Editors Help (Export spreadsheets; Create, view, or download a file) on November 15, 2026.
Download it as Microsoft Excel (.xlsx) as above, then double-click the downloaded file. It opens in Excel. Remember that it's now a separate copy: changes you make in Excel don't flow back to the Google Sheet.
Call Bill and he'll walk you through it — or come do it for you.
Everyone deletes the wrong row now and then. Spreadsheets have two safety nets: Undo for a mistake you just made, and version history for a mistake you notice days later.
| To | Do this |
|---|---|
| Undo | Ctrl+Z (Windows) or Command+Z (Mac), or the curved left arrow on the toolbar. Press again to step further back. |
| Redo | Ctrl+Y (Windows) or Command+Shift+Z (Mac), or the curved right arrow. Puts back what you just undid. |
Checked against Google Docs Editors Help (Find what's changed in a file, Computer) on November 15, 2026.
Using free Excel for the web? Go to onedrive.com, find the file, right-click its name and choose Version history. On a Windows PC you can also right-click the file in the OneDrive folder of File Explorer and choose Version history.
Checked against Microsoft Support (View previous versions of Office files; Restore a previous version of an Excel file; What is AutoSave?) on November 15, 2026.
Call Bill and he'll walk you through it — or come do it for you.
A phone is wonderful for looking up a list (the Christmas card addresses at the post office, the medication list at the doctor's) and for small changes. For building a budget or printing, a computer is much easier.
| App | How to get it |
|---|---|
| Google Sheets | Free from the App Store (iPhone, iPad) or Google Play (Android). Sign in with your Google account and all your spreadsheets are there. |
| Microsoft Excel | Free from the App Store or Google Play, or use the free Microsoft Copilot app, which holds Word, Excel and PowerPoint together. Sign in with your Microsoft account to reach your OneDrive files. |
Checked against Google Docs Editors Help (How to use Google Sheets, Android and iPhone & iPad) and Microsoft Support (The Microsoft 365 app transition to the Microsoft Copilot app) (sibling check) on November 15, 2026.
Checked against Microsoft Support (Microsoft 365 mobile apps) and the Microsoft Store page for Excel Mobile on November 15, 2026.
Checked against Google Docs Editors Help (Sort & filter your data, iPhone & iPad and Android; How to use Google Sheets, iPhone & iPad) on November 15, 2026.
Call Bill and he'll walk you through it — or come do it for you.
Both companies have added an AI helper you can ask in plain English: "add up each month," "sort this by date," "which month did I spend the most on groceries?" They can save time, but you don't need either one for anything in this guide, and they aren't free.
| Copilot in Excel | |
|---|---|
| Who gets it | The owner of a Microsoft 365 Personal, Family or Premium subscription. On a Family plan, the other members don't get it. |
| How much | Personal and Family come with a monthly allowance of AI credits (60 a month in November 2026) that resets each month. Premium has higher limits. |
| What it needs | The workbook saved in OneDrive as a normal Excel file (.xlsx). |
| Where to find it | Look for the Copilot button on the Home tab or beside your cells. A panel opens where you type your request. |
| Turning it off | In Excel on Windows, File > Options > Copilot, and clear Enable Copilot. |
Checked against Microsoft Support (Frequently asked questions about Copilot in Excel; Frequently asked questions about Copilot in Microsoft 365 subscriptions) and, for credits and the off switch, AI credits and limits for Microsoft 365 subscriptions (sibling check) on November 15, 2026.
| Gemini in Sheets | |
|---|---|
| Who gets it | Personal Google accounts with a paid Google AI plan (Google AI Plus, Pro or Ultra). Some Sheets features, such as analyzing data, are only in AI Pro and Ultra. |
| How much | Google AI Pro is $19.99 a month; AI Plus is about $4.99 a month. Check the current price at one.google.com before you sign up. |
| Where to find it | On a computer, open a spreadsheet and click Ask Gemini at the top right. A side panel opens; pick a suggestion or type your own. |
| On iPhone and iPad | Gemini can answer questions about the tab you're looking at, but it can't edit or format the sheet there. |
Checked against Google Docs Editors Help (Collaborate with Gemini in Google Sheets) and the Gemini subscriptions page (sibling check) on November 15, 2026.
My Microsoft Copilot manual and my Google Gemini manual cover these helpers, their plans and their privacy settings in full.
Call Bill and he'll walk you through it — or come do it for you.
Spreadsheets are harmless on their own. But scammers have long used Excel files sent by email as a way to get harmful programs onto a computer, and fake "invoices" to frighten people into calling them. Here's what to watch for.
Checked against Microsoft Learn (Macros from the internet are blocked by default in Office) and Microsoft Support (Enable or disable macros in Microsoft 365 files) on November 15, 2026.
Checked against FTC consumer alerts on fake renewal scams (sibling check) on November 15, 2026.
Checked against Google Drive Help (Mark or unmark spam in Drive; Block & unblock people) (sibling check) on November 15, 2026.
My guide to spotting and avoiding scams covers email and phone scams of every kind.
Call Bill and he'll walk you through it — or come do it for you.
These are the puzzles that catch nearly everybody. None of them means you did anything seriously wrong.
| What happened | What to do |
|---|---|
| The cell shows ##### | The column is too narrow. Double-click the line to the right of the column letter (Making It Readable: Wider Columns, Wrap Text, Bold). |
| My formula shows as text | It's missing the equals sign at the start, or the cell is formatted as Plain text. Retype it starting with =. |
| The total is wrong | One of the numbers is really text (it sits on the left of the cell), or a new row was added below the total (A Monthly Household Budget, Step by Step). |
| #VALUE! or #REF! | #VALUE! means a formula is trying to do math with words. #REF! means a cell it used was deleted. Press Undo, or click the cell and fix the formula. |
| My date turned into a number | A date like 46381 is a date with a number format. Format the cell as a Date (Money, Dates and Number Formats). |
| The ZIP code lost its zero | Type an apostrophe first, like '04401, or format the column as Plain text (Typing in Cells, and Fixing Mistakes). |
| Half my list is missing | A filter is on, or rows are hidden. Turn the filter off (Sort and Filter Your List). Hidden rows show as a jump in the row numbers; right-click and choose Unhide (Excel) or click the small arrows (Sheets). |
| Everything prints on 10 pages | Set a print area or use Fit All Columns on One Page, and check the preview (Printing a Spreadsheet That Looks Right). |
| I can't type in the file | In Excel, look for a yellow Enable Editing bar (only click it for files you trust) or a "Read-Only" note. In Sheets, you may have Viewer access; ask the owner for Editor. |
| I can't find my file | Check Recent in Excel, or search at sheets.google.com or drive.google.com (Saving, Naming and Finding Your Files). |
| I deleted something by mistake | Press Ctrl+Z (Command+Z) right away. Later, use version history (Undo and Version History: Going Back in Time). |
Call Bill and he'll walk you through it — or come do it for you.
I've written this guide so you can make your own lists and budgets with confidence. But part of being helpful is being honest about when a hand saves you time and worry, so here's my straight advice, with no pressure.
I work at your pace: no rushing, no talking down, and no jargon. I explain what I'm doing in plain words, and I'll tell you honestly when you don't need to buy anything, which for spreadsheets is often. I serve Portage County, Ohio, and I bring more than 30 years of professional experience to every visit.
Thank you for letting me help you with spreadsheets. Those little boxes are working for you now.
— Bill
Call Bill and he'll walk you through it — or come do it for you.
Print just this page and keep it by your computer. The whole guide, boiled down.
| I want | Go here |
|---|---|
| Google Sheets | sheets.google.com (free) |
| Free Excel for the web | microsoft365.com or onedrive.com |
| Make columns fit | Double-click the line between column letters |
| Freeze the top row | Excel: View > Freeze Panes > Freeze Top Row. Sheets: View > Freeze > 1 row |
| Sort | Excel: Data > A to Z. Sheets: right-click column letter > Sort sheet A to Z |
| Filter | Excel: Data > Filter. Sheets: Data > Create a filter |
| Version history | Excel: File > Info > Version History. Sheets: File > Version history |
| To do this | Do this |
|---|---|
| Add a column of numbers | =SUM(B2:B20), or Excel's AutoSum on the Home tab |
| Subtract | =B2-C2 |
| Average | =AVERAGE(B2:B13) |
| Copy a formula down | Drag the small square at the cell's bottom right corner |
| Show dollars | Excel: Home > Currency. Sheets: Format > Number > Currency |
| Print neatly | Landscape, Fit All Columns on One Page, print titles, check the preview |
| Undo | Ctrl+Z (Command+Z on a Mac) |
| Item | |
|---|---|
| My Google account email | ____________________ |
| My Microsoft account email | ____________________ |
| Where my budget file lives | ____________________ |
| Who I share lists with | ____________________ |
Call Bill and he'll walk you through it — or come do it for you.
We use cookies only to see which pages help people most. Learn more