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.
Format
- Number Format
- Accounting Number Format
- Percent Style
- Comma Style
- Increase Decimal
- Decrease Decimal
- Font
- Increase Font Size
- Decrease Font Size
- Font Size
- Bold
- Italic
- Underline
- Font Color
- Fill Color
- Borders
- Align Left
- Center
- Align Right
- Top Align
- Middle Align
- Bottom Align
- Orientation
- Wrap Text
- Decrease Indent
- Increase Indent
- Merge & Center
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.
Object
- Edit Shape
- Edit Text
- Merge Shapes
- Shape Styles
- Shape Fill
- Shape Outline
- Shape Effects
- WordArt Styles
- Text Fill
- Text Outline
- Text Effects
- Alt Text
- Crop Shape
- Height
- Width
- Edit Icon
- Edit Text
- Combine Icons
- Quick Styles
- Icon Fill
- Icon Outline
- Icon Effects
- Reset Icon
- WordArt Styles
- Text Fill (icon)
- Text Outline (icon)
- Text Effects (icon)
- Alt text
- Crop
- Height
- Width
- 3D Model Views
- Reset 3D Model
- Alt Text
- Text Pane
- Change Layout
- Change Colors
- Reset Graphic
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.
View
- Normal
- Page Break Preview
- Page Layout
- Custom Views
- Sheet view (Default)
- New sheet view
- Keep sheet view
- Exit sheet view
- Sheet view options
- Formula Bar
- Headings
- Gridlines
- Ruler
- Zero Values
- Data Type Icons
- Active cell
- Navigation
- Zoom
- Zoom to 100%
- Zoom to Selection
- Freeze Panes
- Split
- New Window
- Arrange All
- View Side by Side
- Synchronous scrolling
- Reset Window Position
- Hide
- Unhide
- Switch 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.
Try another word, or the name of the tab where the command sits.