Skip to content
Bitta Apps

Chapter 2 of 4Page 4 of 12

Workbooks

Spreadsheet essentials

Format, sort, filter, find and replace in a Bitta Sheets workbook, with Business Central number formats, frozen headers, zoom, full screen and shortcuts.

updated: applies-to: 1.0.0.0

A workbook has the spreadsheet tools you already know. This page turns live Business Central data into a clean, formatted sheet: copy it as values, format it, arrange the rows, then present it.

Copy live data as values

Select a live data table and copy it. Add a sheet with Shift+F11, then choose Paste Values from the Paste menu so the numbers stay put. The Paste menu also has Paste Formulas, Paste Formatting, Paste Column Widths and Paste All Except Borders.

Format the sheet

  • Font group: font and size, bold, italic, underline, strikethrough, fill and font colors, and borders. Increase Font Size and Decrease Font Size step the size up or down.
  • Alignment: wrap text, shrink to fit, orientation, and Merge & Center with more merge options.
  • Number formats: Accounting, Percent and Comma, the decimal buttons, and the format box with the rest. Format Cells (Ctrl+1) has every number format.
  • BC formats: right-click a column and choose BC formats to use your Business Central number settings.
Right-click menu on the profit column with the BC formats submenu listing Business Central number formats

From Format in the Cells group, AutoFit Column Width sizes each column to its content, and Hide and Unhide hide columns or rows. AutoSum adds a total, and Format Painter copies a look from one cell to another. Clear empties contents or formats.

Sort and filter

Filter adds a button to each header, to sort or to show only the rows you need. Sorting moves whole rows together. Sort opens a custom sort, and Clear and Reapply reset the filter or run it again. The same commands are in the Sort & Filter menu on the Home tab.

Filter button menu on the chair price list with Ascending, Descending and the values to show

Find and replace

Find and Replace (Ctrl+H) changes text across the sheet. Replace All changes every match at once.

Find and Replace panel replacing Swivel Chair with Task Chair across the sheet

Rows and columns

Insert Sheet Rows and Insert Sheet Columns add rows and columns, and Delete Sheet Rows and Delete Sheet Columns remove them. Insert Cells and Delete Cells shift only the selected cells.

Present the sheet

On the View tab:

  • Freeze Panes, Freeze Top Row and Freeze First Column keep headers in place as you scroll. Unfreeze Panes releases them.
  • Turn Gridlines off for a clean page, and use Zoom, or 100% to reset it.
  • Keyboard Shortcuts (Ctrl+) lists every shortcut.
  • Full Screen gives the sheet the whole screen. Escape leaves it.
Freeze Panes menu on the View tab with Freeze Panes, Freeze Top Row, Freeze First Column and Unfreeze Panes
Keyboard Shortcuts panel next to the chair price list in full screen

When to use it

Use it whenever live data has to become a clean page: a meeting sheet, a price list, or a summary to send. To print it, see Print and PDF.

Next step

Ready to try Bitta Sheets?