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.
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.
Find and replace
Find and Replace (Ctrl+H) changes text across the sheet. Replace All changes every match at once.
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.
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.