Paperly Sheets Open Sheets

Help

Everything you need to get going with Paperly Sheets. Can't find an answer? Tell us.

Getting started

  1. Open Paperly Sheets. There's nothing to install and no account to create.
  2. On the Home screen, choose Blank workbook or a template (GST invoice, attendance sheet, EMI calculator and more). Or use Open for an .xlsx, .xls, .csv, .tsv or .ods file from your computer or a link, or drag the file onto the window.
  3. Click a cell and type. Press Enter to move down or Tab to move right. Start with = for a formula, for example =SUM(A1:A10).
  4. Use the ribbon at the top to format cells, sort, filter, add charts and more. The + at the bottom adds a sheet; double-click a sheet tab to rename it.
  5. Click the workbook's name at the top to rename it, and the ⌂ button to go back to Home. Your work saves by itself as you type.

Keyboard shortcuts

On a Mac, use Cmd where it says Ctrl.

KeysWhat it does
Arrow keysMove between cells (hold Shift to select)
Ctrl + arrow keysJump to the edge of the data
Ctrl+Home / Ctrl+EndGo to A1 / the last used cell
Enter / TabConfirm and move down / right
F2 or double-clickEdit a cell
Alt+EnterNew line inside a cell
Ctrl+EnterFill every selected cell with what you typed
DeleteClear the selected cells
Ctrl+B / I / UBold / italic / underline
Alt+=AutoSum
Ctrl+ASelect the whole sheet
Ctrl+X / C / VCut / copy / paste
Ctrl+Z / Ctrl+YUndo / redo
Ctrl+F / H / GFind / Replace / Go To
Ctrl+D / Ctrl+RFill down / right
Ctrl+Shift+LFilter on or off
Ctrl+9 / Ctrl+0Hide rows / columns (add Shift to unhide)
Ctrl+Shift+4 / 5 / 1Currency / percent / number format
Ctrl+PPrint preview, then print or save as PDF
Ctrl + mouse wheelZoom in / out
Ctrl+Page Up / Page DownPrevious / next sheet

With Pro or Max you also get:

KeysWhat it does
F4While typing a formula: switch a reference between A1, $A$1, A$1 and $A1
Ctrl+1Format Cells
Ctrl+KInsert a link
Ctrl+; / Ctrl+Shift+;Today's date / the time
Ctrl+EFlash Fill
Shift+F3Insert Function
Ctrl+/Search every command
F7Spelling

Point at any button in the ribbon to see its shortcut.

How plans work

Free

The everyday spreadsheet: formulas, formatting, sorting and filtering, templates, printing, and Excel and CSV files. No sign-in needed.

Pro

Everything in Free, plus charts, lookups like VLOOKUP and XLOOKUP, conditional formatting, tables, comments, version history and more functions.

Max

Everything in Pro, plus PivotTables, sparklines, What-If tools, dynamic arrays, LAMBDA, sheet protection and financial functions.

Install as an app

Installed, Paperly Sheets opens in its own window from your desktop, Start menu or home screen, and works offline.

The app updates itself. When a new version is ready, a blue New update available button appears on Home; tap it to save your work and switch.

Where your files are saved

Questions

Is it free, does it work offline, can I open Excel files, how do refunds work? See the questions and answers on the home page.

Report a bug or send feedback

In the app, open Help > Report a bug (or Send feedback): on the Home screen it's under Help on the left, and in a workbook it's the Help tab of the ribbon. It writes an email for you with the app version, browser and plan filled in, so we can fix things faster.

Or write to iamgamer072@gmail.com any time. See also Contact Us.