Tabulys guide

View

The step-by-step guide to every command in the View menu of Tabulys.

Normal

Where to find it
  • View › Views

Puts the sheet back into the ordinary editing view. Use it to leave Page Break Preview or Page Layout once you have finished checking how the sheet prints.

  1. Open the sheet you want to work on.
  2. Click Normal.
  3. Carry on editing the grid as usual.

Tip Normal is the view a sheet opens in, so you only need this button after switching to one of the others.

Page Break Preview

Where to find it
  • View › Views

Shows the sheet with the page divisions drawn on it, so you can see which rows and columns land on which printed page. Reach for it before printing a wide table.

  1. Click Page Break Preview.
  2. Read where the sheet breaks from one page to the next.
  3. Adjust the data or the layout if a break falls badly.
  4. Click Normal to go back.

Tip The breaks you see follow the current page setup, so changing margins or scaling moves them.

Page Layout

Where to find it
  • View › Views

Shows the sheet laid out on printed pages, margins included, so what you see matches what comes off the printer. Use it when the fit on the page matters as much as the figures.

  1. Click Page Layout.
  2. Check how the sheet sits inside the margins of each page.
  3. Edit the cells here just as you would in Normal view.
  4. Click Normal when you have finished.

Tip Page Break Preview, beside it, shows the same divisions without drawing the margins.

Custom Views

Where to find it
  • View › Views

Keeps how the workbook is displayed under a name you can call back later. Handy when the same workbook has to be shown one way for you and another way for a report.

  1. Set the workbook up the way you want it remembered: the zoom, gridlines and frozen panes of each sheet, and the active sheet.
  2. Click Custom Views and choose Add Custom View: the view gets a name such as Custom View 1.
  3. Later, choose Show…, select the view in the list and click Show to bring the workbook back as it was.
  4. Choose Delete… to remove from the file a view you no longer need.

Tip Views are saved in the file: those of an Excel workbook appear in Show…, and those you create here stay after saving. A view changes what you see, not the figures; hidden rows and columns, filters and print settings of an Excel view stay in the file but are not applied.

Sheet view (Default)

Where to find it
  • View › Views › Sheet View

A sheet view is a named filter for one sheet. This box lists them and puts the one you pick in force: Default is the shared filter that the workbook itself declares, and the saved views are yours to switch between. While a temporary view is in force it appears in the list too. Inside a sheet view, SUBTOTAL and AGGREGATE keep counting the rows the view hides: those results are saved in the file, so they follow the shared filter and not what you are looking at.

  1. Open the views box.
  2. Pick Default to see the sheet as the workbook declares it.
  3. Pick a saved view to put its filter in force.
  4. Filter with the usual arrows: inside a view the filter does not touch the shared one.

Tip Which view is in force is yours alone: it is not saved in the file and other people do not see it.

New sheet view

Where to find it
  • View › Views › Sheet View

Creates a temporary view starting from the filter the sheet already has. From there you filter with the usual arrows, and what you hide does not reach the workbook: the shared filter stays exactly as it was.

  1. Make sure the sheet has a filter range (Filter).
  2. Click New.
  3. Filter with the usual arrows on the header row.
  4. Click Keep to give the view a name, or Exit to go back to the shared one.

Tip A view holds the filter, not the sort: sorting reorders the rows for everyone, so it stays a shared change.

Keep sheet view

Where to find it
  • View › Views › Sheet View

Gives the view in force a name and saves it in the workbook, so you can switch back to it later. From that moment the view travels with the file: whoever opens it finds it in the list.

  1. With a view in force, click Keep.
  2. Type a name, or accept the one proposed.
  3. Confirm: the view moves into the box and is now a saved one.
  4. Use Ctrl+Z to undo saving it.

Tip Names are unique within the sheet: two views that differ only in capitals would be one view with two rows.

Exit sheet view

Where to find it
  • View › Views › Sheet View

Goes back to the shared view, the one the workbook declares. Nothing is restored, because nothing was changed: leaving a view simply stops overlaying it.

  1. Click Exit.
  2. From a saved view you leave straight away.
  3. From a temporary view with a filter, a message says how many columns you are about to discard.
  4. Choose Keep and leave to save it in the same gesture, or Leave without saving.

Tip Exit is off when Default is already in force: the box beside it says which view you are in.

Sheet view options

Where to find it
  • View › Views › Sheet View

Manages the views saved on this sheet. Every row carries the measure that justifies it — how many filtered columns, how many rows it would show out of how many — measured on the data as it is now, so a view whose column has gone says so instead of quietly showing the wrong thing.

  1. Click Options.
  2. Read each row: the second line says what the view does to the sheet right now.
  3. Pick a row and use Switch to, Rename or Duplicate.
  4. Use Delete to remove it: Ctrl+Z brings it back.

Tip A view marked Outside the data or Column is gone cannot be put in force: the sheet changed underneath it.

Formula Bar

Where to find it
  • View › Show

Turns the bar that shows and edits the contents of the selected cell on and off. Hide it when you want a little more of the grid on screen.

  1. Tick Formula Bar to show it.
  2. Clear the tick to hide the bar and gain some room.
  3. Tick it again when you need to work on a long entry.
  4. Drag across the text in the bar to select it, or hold Shift and press the arrow keys; a double-click takes a whole word.
  5. Press Alt+Enter to start a new line inside the cell; when you confirm, the cell switches to wrapped text so both lines show.

Tip Click in the bar to write in it: it grows to three lines, a longer formula scrolls with the mouse wheel, and Alt+Enter starts a new line inside the cell. Next to fx sits a button, Open the Design Window, which opens the Formula Builder.

Headings

Where to find it
  • View › Show
  • Pane › Sheet

Turns the row numbers down the side and the column letters across the top on and off. Switch them off for a tidier picture of the sheet.

  1. Tick Headings to show the numbers and letters.
  2. Clear the tick to hide them.
  3. Tick it again when you need to see which row or column you are in.

Tip With the headings hidden, cell references are harder to read off the screen, so leave them on while you build formulas.

Headings: View

Where to find it
  • View › Show
  • Pane › Sheet

Shows or hides the column letters and row numbers around the grid. Hide them for a presentation-style view of the sheet.

  1. Tick View to show the row and column headings on screen.
  2. Clear View to hide them.
  3. Tick it again when you need to read cell addresses off the grid.

Tip Hiding the headings moves nothing: the cells keep the same addresses.

Gridlines

Where to find it
  • View › Show
  • Pane › Sheet

Turns the faint lines that separate the cells on and off. Switching them off gives a cleaner picture of a sheet meant to be read rather than edited.

  1. Tick Gridlines to show the lines.
  2. Clear the tick to hide them.
  3. Tick the box again whenever you need to see where the cells begin and end.

Tip The setting only affects how the sheet is shown; nothing in the cells changes.

Gridlines: View

Where to find it
  • View › Show
  • Pane › Sheet

Turns the faint lines between cells on and off on screen. Switching them off gives a cleaner view while you lay a sheet out.

  1. Tick View to show the gridlines on screen.
  2. Clear View to hide them.
  3. Tick it again whenever you want the cell edges back.

Tip Printing has its own switch: tick Print beside it if the lines should come out on paper as well.

Ruler

Where to find it
  • View › Show

The rulers run along the top and the left of the sheet in Page Layout view. They measure the page in centimetres, starting from its edge, and they carry the four margin handles: drag one and that margin moves. In the other two views there is no page to measure, so the box is off and its tooltip says why.

  1. Choose Page Layout.
  2. Tick Ruler: the two rulers appear around the sheet.
  3. Drag a handle on a ruler to set that margin, or clear the tick to hide the rulers again.

Tip The setting belongs to the sheet, not to the window: the file remembers it, and every sheet keeps its own.

Zero Values

Where to find it
  • View › Show

Shows or hides the zeros of the sheet. With the box cleared, a cell whose value is exactly zero — typed or the result of a formula — looks empty on screen and on the printed page, so a table of totals reads at a glance. The cell keeps its value: the formula bar, formulas and copying still see 0.

  1. Clear Zero Values: the zeros of the sheet disappear.
  2. Click a cell that now looks empty to read its 0 in the formula bar.
  3. Tick the box again to show the zeros.

Tip The setting belongs to the sheet and is saved in the file, as in Excel. A number format with its own section for zero, such as 0;-0;"-", keeps showing what that section says.

Data Type Icons

Where to find it
  • View › Show

Stocks, Currencies and Geography recognise what a cell says — a company, a pair of currencies, a place — and write the data beside it. This box shows a small icon in the cell that was recognised, and pointing at the icon says what it was taken to be: «Italy (ITA)» answers months later the question the window answered once. The box belongs to the sheet, and the icons take a little room from the text: turn it off and the room comes back, on screen and in print alike.

  1. Select a column of names and use Geography (or Stocks, or Currencies).
  2. The Data Type Icons box is already ticked: an icon appears in every cell that was recognised.
  3. Point at an icon to read what it was recognised as.
  4. Clear the tick to hide the icons on this sheet.

Tip The mark records what you accepted, not what a catalogue guesses: change a cell's text and its icon goes quiet, undo and it comes back.

Active cell

Where to find it
  • View › Show

With Active cell on, the row and the column of the cell you are on take a light tint, so on a wide table the eye keeps its place. The tint follows the active cell, not the whole selection, and it stops where the selection begins: a selected cell looks the same wherever it is. Where a fill of your own would swallow the tint, Tabulys strengthens it just enough to stay visible.

  1. Tick Active cell.
  2. Move around the sheet: the tint follows the cell you are on.
  3. Clear the tick to switch it off, or change it from Settings, View.

Tip The setting belongs to you, not to the file: it stays on across workbooks and sessions, and it is never printed.

Navigation

Where to find it
  • View › Show

Opens a side pane that lists the parts of the workbook — sheets, tables, PivotTables, defined names, charts and objects — and tells you where each one leads. Clicking a row takes you there.

  1. Press Navigation.
  2. The pane opens on the right with the current sheet already expanded: press another sheet's arrow to see its parts.
  3. Click a row to go there: that sheet becomes active and the destination is brought into view.
  4. Above six parts a search box appears: type a few letters of the name or of the reference.
  5. Press Navigation again, or the pane's ×, to close it.

Tip Every row carries on its right the reference it leads to, so you know where a part is without having to jump to it. A hidden sheet is listed but is not a destination: unhide it first.

Zoom

Where to find it
  • View › Zoom

Sets how large the sheet appears on screen without changing anything in it. Zoom out to take in a wide table, zoom in to read small figures. The zoom belongs to the sheet you are on: each sheet keeps its own, together with its scroll position and selection, and you find them again when you come back; each view has its own zoom, and Page Break Preview starts at 60%.

  1. Click Zoom.
  2. A dialog opens where you choose how big the sheet is shown.
  3. Confirm to apply the new level.

Tip To jump straight back to the real size, click 100% beside it. Zooming, scrolling and switching sheets do not mark the workbook as modified — closing without saving asks nothing — but every save keeps them: the workbook reopens on the sheet, with the zoom, scroll position and selection you had.

Zoom to 100%

Where to find it
  • View › Zoom

Puts the sheet you are on back to its real size in one click, whatever level you had zoomed to; the other sheets keep their own zoom. Use it to get a reliable picture after a spell of zooming in and out.

  1. Click 100%.
  2. Read the sheet at its real size.
  3. Use Zoom when you want a different level again.

Tip It is the quickest way back from any level, without going through the Zoom dialog.

Zoom to Selection

Where to find it
  • View › Zoom

Sets the sheet to the level at which the cells you selected fill the window, and moves the view onto them. Handy for looking closely at one table in the middle of a large sheet without hunting for the right level by trial and error.

  1. Select the cells you want to look at closely.
  2. Click Zoom to Selection.
  3. The sheet grows (or shrinks) until the selection fills the window.

Tip It is also in the Zoom window next door, as «Fit selection». If you pick several areas while holding Ctrl, it fits the rectangle that contains them all.

Freeze Panes

Where to find it
  • View › Window
  • Pane › Sheet

Pins the rows above and the columns to the left of the selected cell, so they stay on screen as you scroll. Use it to keep headers in view over a long table.

  1. Select the cell below and to the right of what you want to keep in view.
  2. Click Freeze Panes.
  3. Scroll the sheet: the frozen rows and columns stay put.
  4. Click the arrow next to Freeze Panes for the other freezing choices.

Tip The freeze follows the selected cell, so choose that cell before you click rather than after.

Split

Where to find it
  • View › Window

Divides the window so you can look at two distant parts of the same sheet at once. Useful when a figure at the top has to be checked against one far below.

  1. Select the cell where the window should be divided.
  2. Click Split.
  3. Scroll each part on its own to bring the two areas together.
  4. Click Split again to remove the division.

Tip A split shows one sheet twice, so an edit made in either part is the same edit.

New Window

Where to find it
  • View › Window

Opens a second window on the same workbook, so you can watch two sheets at once. It is not a copy: what you type in one window appears in the other, and there is a single save. The new window opens on the sheet you were looking at.

  1. Open the workbook from Aerarys.
  2. Click New Window.
  3. In the new window, pick another sheet from the tabs at the bottom.
  4. Arrange the two windows as you like: they are system windows.
  5. Type a value in a cell — it appears in the other window as well.

Tip The command is off on a workbook that is not yet saved in Aerarys: without an Aerarys entry the two windows would be two separate copies. The desktop app does not have it — it opens one window per document.

Arrange All

Where to find it
  • View › Window

Arrange All shows the same workbook in two to four views at once, each on its own sheet and each scrolling on its own, so you can compare two sheets — or two distant parts of one — without losing either.

  1. Click Arrange All.
  2. Choose how many views you want: 2, 3 or 4.
  3. Choose an arrangement: Side by side, Stacked or Grid.
  4. Click the sheet name at the top of a view to show another sheet there.
  5. Scroll a view on its own with the wheel over it, or with the arrow keys on the view with the thicker border.
  6. Click Close when you have finished.

Tip The views are for looking: nothing done in them changes the workbook. Each one shows its sheet at natural size and scrolls both ways, so a wide sheet is reached sideways instead of being shrunk.

View Side by Side

Where to find it
  • View › Window

View Side by Side puts two sheets of your workbook one above the other and scrolls them together, so the rows that match stay level while you compare them.

  1. Click View Side by Side.
  2. Click the sheet name at the top of a pane to choose which sheet it shows.
  3. Scroll either pane — with the wheel, the arrow keys or its scrollbar: the other one follows.
  4. Use Side by side or Stacked to change how the two panes share the window.
  5. To compare sheets that are out of step, turn Synchronous scrolling off, line the two panes up by hand, then turn it back on: the offset you made is kept.
  6. Click Realign to bring both panes back to the same cell.
  7. Click Close when you are done.

Tip The footer always says where the two panes are — A12 ↔ A15 — and tells you when they are offset. Nothing you do in this window changes the workbook.

Synchronous scrolling

Where to find it
  • View › Window

Ties together the windows open on the same workbook: scroll one and the other follows, both down the rows and across the columns. The two windows need not show the same cell — they keep the distance they had when you tied them, so you can hold the summary at the top and the detail at the bottom and move them together.

  1. Open a second window with New Window.
  2. In each window choose what to look at: two different sheets, or two places in the same sheet.
  3. Click Synchronous Scrolling in both windows: the button stays pressed.
  4. Scroll either window: the other follows, keeping the distance that was there.
  5. To move one on its own, switch its button off; switching it back on ties it again from where it is.

Tip Turn the link on in every window that should follow: it is a choice of the single window, not of a pair. If you turn it on when no other window is open yet, a window says so and offers to open a second one. The desktop app does not have this command: it opens one window per document.

Reset Window Position

Where to find it
  • View › Window

Puts the windows opened from here with New Window back to their starting position: the size of this window, stepped down and to the right of it. Use it when you have dragged the extra windows around and want them tidy again. Inside Palatys it instead puts all the Tabulys windows in view side by side, each in a zone of the screen: Palatys arranges them.

  1. Click New Window to open a second window on the same workbook.
  2. Move or resize that window while you work.
  3. Back in this window, click Reset Window Position.
  4. Every window opened from here returns to where it first opened.

Tip Outside Palatys it moves only the windows opened from here, and the window you are in does not move: it is the point the others are measured from. Inside Palatys all the Tabulys windows in view are arranged, including the one you are in; with only one window, or with the others minimized, the command is greyed and clicking it explains how to make it available. Nothing in the workbook changes.

Hide

Where to find it
  • View › Window

Marks the workbook as hidden. The mark travels with the file: reopened in Excel, the workbook opens without showing its window, and Excel looks empty. Merydion keeps showing it and says so.

  1. Click Hide.
  2. Read what the mark means, then confirm.
  3. Save the file: the mark travels with it.
  4. Click Unhide to remove the mark.

Tip A file marked hidden looks empty when opened elsewhere: it is not damaged, it is only asking not to show its window.

Unhide

Where to find it
  • View › Window

Removes the hidden mark, so the workbook opens showing its window again. Available only while the workbook carries the mark.

  1. Click Unhide.
  2. Save the file: the mark is gone.

Tip Unhide also clears the deeper very-hidden mark, which Excel's own dialog cannot remove.

Switch Windows

Where to find it
  • View › Window

Switch Windows lists the Tabulys windows you have open and takes you to the one you pick, without reloading the workbook inside it: unsaved work stays where it is. Each row names the sheet that window is looking at, so two windows on the same workbook do not say the same thing.

  1. Open a second window with New Window, or open another workbook from Aerarys.
  2. In the menu, open the Switch Windows submenu.
  3. Pick the window from the list: the ticked row is the one you are already in.
  4. With more than nine windows, choose More Windows to see them all in a scrolling list.

Tip Two windows on the same sheet of the same workbook are told apart by the number after the name: Budget.xlsx — Q3:1 and Budget.xlsx — Q3:2.

Back to the guide

Productivity, made in Italy.

Bring the whole suite to your team — simple, secure and entirely yours.