Guide map

Every Tabulys guide, by topic.

Each command in the menus has its own step-by-step guide. Search for the one you need or browse the topics: every entry opens its guide at the right place.

guides
375
topics
22
menus
9

Cell formatting

Font, borders and fill colour, alignment and wrapped text, merged cells, number formats, and check boxes in cells.

Styles and themes

Conditional formatting, tables formatted in one click, cell styles, and the colours, fonts and effects of the workbook theme.

Editing cells

Cut, copy and paste, copy formatting, insert and delete cells, rows and columns, fill a series, clear contents and find what you need.

Formulas and functions

Insert a function from the library, name cells and ranges to use in formulas, and choose when the workbook recalculates.

Checking formulas

Trace precedents and dependents, find errors, evaluate a formula step by step, watch the cells that matter and check the workbook's performance.

External data

Bring data in from text, the web, tables and pictures, refresh queries and connections, and recognise stocks, currencies and places.

Sort and filter

Sort and filter a range, filter with slicers and timelines, group rows and columns into an outline and add subtotals.

Data analysis

Split text into columns, remove duplicates and validate entries, consolidate and model data, forecast, run what-if analysis and Solver.

Tables and PivotTables

Turn a range into a table and style it, summarise data with a PivotTable and enter records through a form.

Charts and sparklines

Insert a recommended chart or pick a type, add titles, labels and trendlines, change its colours and data, and draw sparklines in cells.

Pictures and illustrations

Insert pictures, shapes, icons, screenshots, 3D models and SmartArt, then edit, correct, style, describe and crop your pictures.

Shapes, icons and graphics

Shapes, icons, 3D models and SmartArt: fill, outline, effects, WordArt text, description and size.

Text and symbols

Text boxes and WordArt, equations and symbols, links, embedded objects, header and footer, and signature lines.

Arranging objects

Bring forward, send backward, align, group and rotate pictures, shapes and icons over the sheet, and find them in the selection pane.

Drawing and ink

Draw and highlight with pens, select ink with the lasso, erase it, turn it into shapes or equations, replay it and hide it.

Comments and notes

Comment on a cell and move between comments, add notes, and see who changed what in a shared workbook.

Proofing, language and accessibility

Spelling, synonyms, workbook statistics, translation and the accessibility check.

Protection

Protect a sheet or the workbook structure, encrypt with a password, allow editing of ranges and stop sharing the workbook.

Page and printing

Margins, orientation, paper size, print area and breaks, background, scaling to fit, print titles, and printed gridlines and headings.

Views and windows

Normal, page break and page layout views, what the screen shows, zoom, freeze panes, sheet views and working with several windows.

Python and macros

Write Python in a cell, set up the code every Python formula shares, and record macros that repeat your formatting.

Help

Where to find the guides, starting from this map.