Skip to content
Bitta Apps

Bitta Sheets · Part 18 · 3:03 · YouTube

Organize Business Central Workbooks: Sheets, Folders and Favorites

What this video covers

Organize Business Central workbooks in Bitta Sheets with folders, views, favorites and properties, and keep the sheets inside them tidy.

Create a folder inside another, copy a workbook and move it to a folder, switch the Show views, star a favorite, and add a description, tags and a color.

In the workbook, insert, hide, unhide, rename, delete and color sheets.

Transcript

Marcus can't find the 2027 budget. Folders and favorites fix that. Here's how to organize your workbooks, and the sheets inside them. On the Workbooks page, choose Show, then Folders.

Folders are personal, so nobody else sees yours. Select Finance Pack, choose New Folder Inside, and name it Budgets 2027. The new folder sits inside Finance Pack.

Rename and Delete work on the selected folder. Delete moves its workbooks up to the folder it was in. Under More options, then Actions, you'll find Move and Move to Top Level. In the Finance Pack folder, select Larkspur Sales Plan,

and choose Copy. Name it Sales Plan 2027. The copy has the same sheets, data tables and filters, and it isn't shared with anyone.

Now choose Move to Folder. Budgets 2027 is already selected, so choose OK. Workbook Folders now shows the workbook in Budgets 2027. The Show tab switches the list.

Recent shows the workbooks you opened before. My Workbooks shows the ones you own. Shared with Me and Templates work the same way, and every view covers all your folders.

Choose the star next to a workbook to make it a favorite. The Favorites view lists only your favorites. On the Manage tab, Properties holds the details. Add a description, tags like budget and 2027,

and give it a color. Leave Company blank to use the company you work in. Point it at another company, and its live data is read only. You can also open or share the workbook from here.

In the workbook, the star in the title bar shows it's a favorite. To add a sheet, choose Insert, then Insert Sheet, or press Shift F11. To hide Assumptions, select its tab, and choose Format,

then Hide Sheet. To bring it back, right-click a tab, choose Unhide, and pick Assumptions. To rename a sheet, choose Format, then Rename Sheet,

and type the name. Here, Draft. Delete Sheet asks first, and names the sheet. Choose Delete, and it's gone.

Tab Color gives a tab its own color. Here, green for Sheet1. Every change saves on its own. If someone else saves the workbook while you edit,

your edits are kept in a copy, and you choose Reload or Open my copy. Use folders for each team or year, favorites for the workbooks you open every day, and sheets to keep one report together. Next, the spreadsheet essentials.

More Bitta Sheets videos

All videos

Next step

See Bitta Sheets on your own data