Formatting is the difference between a spreadsheet you can read and one you can present. The Format Cells dialog in RixSheets gathers every cell appearance control in one place: number formats that turn 0.184 into 18.4% and 4500 into $4,500.00, fonts, borders, alignment, wrap text, text rotation, and a protection tab that decides which cells may be edited once the sheet is locked. One dialog, applied to a selection, and the sheet starts looking intentional.
Number formats: same value, better story
The number tab is where most of the value lives. Every format changes only the display — the underlying value stays exact for calculations:
| Category | Example input | Displays as | Use for |
|---|---|---|---|
| Currency | 4500 | $4,500.00 | Money, budgets, invoices |
| Percent | 0.184 | 18.4% | Rates, margins, growth |
| Date | 46234 | September 4, 2026 | Deadlines, aging reports |
| Fraction | 0.75 | 3/4 | Recipes, measurements |
| Scientific | 0.000042 | 4.20E-05 | Engineering, lab data |
| Custom | 4500 with your code | 4,500 units | Anything the list lacks |
The custom category is the escape hatch: define your own pattern when the built-ins are close but not right — trailing units, fixed decimals, thousands separators, special date layouts. Sales reports often want a custom currency without decimals; engineering sheets want three significant digits; both are two clicks in custom.
The one rule to internalize: a number format changes display, never value. 4,500 formatted as "4,500 units" is still the number 4,500 for every SUM, AVERAGE and VLOOKUP in the workbook. This is why formatting belongs in the Format Cells dialog rather than in the data itself — typing "units" into cells converts them to text, breaks every calculation downstream, and is the most common self-inflicted wound in shared spreadsheets.
Apply formats in four steps
- Select the range — a column of prices, a row of dates, the whole table.
- Open Format Cells from the Home tab or the right-click menu.
- On the number tab, choose the category and its options: decimal places, currency symbol, date style.
- Confirm and move on; repeat for the next column with a different type.
A useful habit: format a whole column once, before entering data, so every future value arrives dressed correctly.
Fonts, borders and alignment
The appearance tabs behave the way you expect:
- Font — typeface, size, style and color. Match the workbook to your document defaults so a pasted table does not look like a stranger.
- Border — draw edges around or between cells. Thin gray inner lines with heavier outer borders is the quiet professional look; heavy grid everywhere is not.
- Alignment — horizontal and vertical placement, indent, and the two features that rescue tight layouts: wrap text and text rotation.
Wrap text lets a long sentence live inside one cell across multiple lines, with the row growing to fit — essential for notes, descriptions and comments columns. Text rotation angles the label, so a narrow column headed "Percentage of annual budget consumed" can stay narrow while staying readable. Rotated headers over vertical columns are standard in dense schedules and Gantt-style sheets.
Borders reward a light touch. The readable default is thin lines between rows or columns where the reader needs to track across, and a heavier outline around the table or its totals — not a full grid on every cell, which adds noise without adding information. Fill colors follow the same principle: one accent for headers, one subtle shade for total rows, and let conditional formatting supply the rest of the color, where it changes with meaning rather than decoration.
Format once, benefit everywhere
A workbook is formatted faster by pattern than by cell-by-cell effort:
- Format the model cell — the first cell of each type: one price, one date, one quantity — with exactly the number format, font and border it deserves.
- Use format painter to copy that cell's look across its column or row in one stroke.
- Format whole columns for entry areas so future rows inherit the look automatically.
- Let conditional formatting handle anything value-driven, so the static layer stays simple.
The time savings are real but secondary; the consistency is the point. A sheet where every price shares one format, every date looks the same and totals are visually distinct reads as trustworthy before anyone checks a number.
The protection tab
Formatting and safety meet on the protection tab:
- Select the cells users should be able to edit — entry fields, quantities, dates.
- Open Format Cells, protection tab, and untick locked.
- Leave every other cell locked — that is the default, and it covers formulas and headers.
- Protect the sheet from the Review tools; from then on, locked cells refuse edits while input cells stay open.
This is how you hand a template to a team: they fill the yellow cells, and the engine under the sheet survives. Combined with data validation on the input cells, a sheet becomes genuinely hard to break.
Static versus conditional formatting
Format Cells sets appearance by position and type — this column is currency, this row is bold. Conditional formatting sets appearance by value and rule — flag anything over budget; see conditional formatting in RixSheets. They layer: static formatting gives the sheet identity, conditional formatting gives it judgment. Both print exactly as they look when you send the sheet through print and page layout.
What to explore next
- Conditional formatting — rules that repaint cells as values change.
- Print and page layout — make the formatted sheet survive paper.
- Name Manager and Go To — navigate large formatted workbooks fast.
- Data validation — pair locked sheets with guarded inputs.