Skip to content
Bitta Apps

Bitta Sheets · Part 19 · 3:43 · YouTube

Business Central Spreadsheet Basics: Formatting, Sort and Find

What this video covers

Turn live Business Central data into a clean, formatted sheet, without leaving Business Central.

In this tutorial you copy a live chair price table as plain values, format it with fonts, fills, borders and number formats (including your Business Central format settings), total it, sort it from a filter button, find and replace text, hide a column, and present it with frozen headers, zoom and full screen.

Transcript

Monday's meeting needs the chair prices: one clean page, sorted and totaled. Here's how to turn live Business Central data into a clean, formatted sheet.

Copy the live data as values. Format it. Arrange the rows. Then present it.

The chairs come in live from Business Central. Select the table and copy it. Add a sheet with Shift F11. The Paste menu has five options: values, formulas,

formatting, column widths, and all except borders. Choose Paste Values, so the numbers stay put. Type a title. Merge and Center it across the table, make it bold,

and a size bigger. Give the header row a fill color and a thick bottom border. The Font group holds the rest of the look: font and size, italic, underline, strikethrough and colors.

Alignment adds alignment, wrap text, shrink to fit, orientation and more merge options. And Cut sits beside Copy. The prices get the Accounting format.

Right-click the profit column: BC formats uses your Business Central number settings. And Format Cells, or Control 1, has every number format when you need more. Percent, Comma and the decimal buttons sit next to Accounting,

and the format box lists the rest. From Format, AutoFit Column Width sizes each column to its content. Below the prices, AutoSum adds a total, and Format Painter copies the header's look to it.

Filter adds a button to each header, to sort or show only the rows you need. From the Unit Price button, choose Descending: whole rows move together, largest price first. Sort opens a custom sort, and Clear and Reapply reset the filter or run it again.

Find and Replace changes text across the sheet. Replace All turns all five swivel chairs into task chairs. The cost is internal, so hide its column from Format. Unhide Columns brings it back.

Insert Sheet Columns adds a column. Delete Sheet Columns takes it out again. And Delete Sheet Rows removes the empty row above the total. Clear, in the Editing group, empties contents or formats.

On the View tab, Freeze Panes keeps the top rows in place as you scroll. Turn the gridlines off for a clean page. The Zoom menu zooms in, here to 125%. And 100% puts it back.

The Keyboard Shortcuts panel lists every shortcut. The Formula Bar box and Normal view sit on the View tab too. Last, Full Screen gives the sheet the whole screen. Escape leaves it.

Use it whenever live data has to become a clean page: a meeting sheet, a price list, or a summary to send. Next, drop-downs, checkboxes and protected cells. The steps are in the Bitta Sheets guide.

More Bitta Sheets videos

All videos

Next step

See Bitta Sheets on your own data