Skip to content
Bitta Apps

Chapter 2 of 4Page 9 of 12

Workbooks

Organize workbooks and sheets

Organize Business Central workbooks in Bitta Sheets with folders, views, favorites and properties, and insert, rename, color, hide or delete sheets.

updated: applies-to: 1.0.0.0

As the workbook list grows, folders, views and favorites keep the ones you need close. Inside a workbook, sheets keep one report together.

Folders

Folders sort your own workbooks. They're personal, so nobody else sees yours, and they're the same in every company.

  1. On the Workbooks page, choose Show, then Folders. Workbook Folders lists your folders and how many workbooks each one holds.
  2. Select a folder, for example Finance Pack, and choose New Folder Inside. Name it, for example Budgets 2027, and choose OK. The path shows the nesting: Finance Pack / Budgets 2027.
New Folder dialog with the name Budgets 2027
Workbook Folders with the new folder Finance Pack / Budgets 2027 inside Finance Pack, and the folder actions
  • New Folder adds a folder at the top level, and Rename renames the selected folder.
  • Move and Move to Top Level are under More options, then Actions.
  • Delete asks first. The folder's workbooks and folders move up to the folder it was in.
  • Show Workbooks, or the folder's name, opens the folder.

Copy a workbook and file it

  1. In the folder, select a workbook, for example Larkspur Sales Plan, and on the Home tab choose Copy. Name the copy, for example Sales Plan 2027.
  2. The copy has the same sheets, data tables and filters, and it isn't shared with anyone.
  3. On the Manage tab, choose Move to Folder, pick the folder, and choose OK.
Copy Workbook dialog with the name Sales Plan 2027
Move to Folder lookup with the folder Finance Pack / Budgets 2027 selected

Workbook Folders now counts the workbook in its new folder.

Show views

The Show tab switches the list between views:

  • Workbooks I Can Open lists every workbook you can open.
  • My Workbooks lists the ones you own.
  • Shared with Me lists the ones others shared with you.
  • Favorites lists your favorites.
  • Recent lists the workbooks you opened before.
  • Templates lists the workbooks marked as templates. See Templates.
  • Folders opens Workbook Folders.

Choosing a view reopens the list on it, and every view covers all your folders.

Workbooks list on the Show tab with the views Workbooks I Can Open, My Workbooks, Shared with Me, Favorites, Recent, Templates and Folders

Favorites

Choose the star next to a workbook to make it a favorite, and choose it again to remove it. The Favorites view lists only your favorites.

Favorites view with the starred workbooks Sales Plan 2027 and Month-End Close

In the workbook, the star in the title bar shows it's a favorite, and the File menu has Add to favorites, or Remove from favorites when it already is one.

Workbook properties

On the Manage tab, Properties holds the details of the selected workbook:

  • Description says what the workbook is for, for example 2027 sales budget by product line.
  • Tags help you find it, separated by commas, for example budget, 2027.
  • Color gives the workbook a color, as #RRGGBB, for example #2563EB.
  • Company stays blank to use the company you work in. Point it at another company, and its live data is read-only.
Workbook Properties for Sales Plan 2027 with a description, the tags budget and 2027, and the color #2563EB

You can also open or share the workbook from the card, with Open and Share. Changes save when you choose Close.

Rename, delete and open another

  • Rename is on the Manage tab of the list, and on the File menu in the workbook.
  • Delete is on the Manage tab. It asks first, because it removes the workbook with its sheets, data tables and filters.
  • In the workbook, File, Copy this workbook makes a copy and opens it, and Open another workbook opens the list of workbooks you can open.

Sheets in a workbook

All of these are on the Home tab, in the Cells group.

  • Insert, then Insert Sheet adds a sheet. The shortcut is Shift+F11.
  • Format, then Rename Sheet edits the tab in place: type the name and press Enter.
  • Format, then Tab Color gives a tab its own color.
  • Format, then Hide Sheet hides the selected sheet. To bring it back, right-click a tab, choose Unhide, and pick the sheet.
  • Delete, then Delete Sheet asks first and names the sheet, because it removes the sheet and everything on it. A workbook always keeps at least one sheet.
Insert menu on the Home tab with Insert Sheet and its shortcut Shift+F11
Format menu with Rename Sheet, Tab Color and Hide Sheet under Organize sheets
Delete sheet dialog asking to delete the sheet Draft and everything on it
Sheet tabs Sales Plan, Assumptions and a green Sheet1

Sheet names can be up to 31 characters, and each name is used once per workbook.

When someone else saves

Every change saves on its own, and the title bar says Saved. If someone else saves the workbook while you're editing, your edits are kept in a copy named after the workbook with "(your changes)", and This workbook was changed offers Reload to see their changes or Open my copy.

When to use it

Use a folder for each team or year, favorites for the workbooks you open every day, and sheets to keep one report together.

Next step

Ready to try Bitta Sheets?