TrueData TrueData Sheets
search
Searching...
functions Formulas
menu_book Pages
manage_search Content Match
search_off

No results for ""

Loading Content
palette

Customization Guide

text_fields Text Formatting

format_bold

Bold / Italic / Underline

Apply B, I, U to selected cells via toolbar or Ctrl+B/I/U. Helps in emphasizing headers or important data points.

format_size

Font Size

Choose from preset sizes (8–72 px) or type a custom value in the font-size field in the toolbar to scale your text up or down for readability.

font_download

Font Family

Switch between system fonts including Inter, Roboto Mono, and default sans-serif from the font picker to match your brand or data presentation style.

strikethrough_s

Strikethrough

Mark cells as voided or deprecated with strikethrough styling. Useful for cancelled orders, completed tasks, or expired contracts.

format_color_fill Color & Fill

format_color_text

Font Color

Pick any color for cell text from the color palette or enter a hex value. Great for P&L indicating red/green colors based on values.

format_color_fill

Cell Background

Fill any cell or range with a solid background color. Use light tints to create visual zones, highlight important rows, or alternate row colors.

border_all Borders & Alignment

border_style

Border Style & Color

Apply all, outer, inner, top, bottom, left, or right borders. Choose solid, dashed, or dotted line styles. Set the color of any border edge independently to match your sheet's palette or use neutral gray for subtle grids.

format_align_justify

Alignment (Horizontal & Vertical)

Horizontal: Align cell content Left, Center, or Right. Numbers default to right; labels default to left.
Vertical: Align content to Top, Middle, or Bottom of the cell. Especially useful in taller rows with wrapped text.

wrap_text

Text Wrap & Rotation

Wrap: Overflow, Wrap, or Clip long text within a cell. Wrap grows the row height automatically.
Rotation: Rotate cell text at any angle (0°–90°) or use stacked orientation. Ideal for compact column headers.

merge_type

Merge Cells & Padding

Merge: Merge a selection into one cell (horizontally, vertically, or fully). Use for section titles spanning multiple columns.
Padding: Increase or decrease the indent level inside a cell to create hierarchy in label columns.

numbers Number Formats

currency_rupee

Currency & Percentage

Format values as ? (INR), $ (USD), or any locale currency. Supports crore/lakh suffix formatting. Multiply values by 100 and append % for percentages.

1,24,500.00 +2.45%
event

Date - Time

Display timestamps in DD/MM/YYYY, HH:MM:SS, or combined formats. Auto-detects epoch ms from live feeds and parses standard string dates.

14/06/2025 09:32:11
pin

Precision & Scientific Notation

Increase or decrease decimal precision (0–6 places). Use scientific notation for large numbers like OI values or volume-weighted aggregations.

2450.25 → 2450.3 1.24E+07
tag

Custom Format

Write your own format pattern. Use #,##0.00 for thousands or [Red]-#,##0 for negative values in red text.

Most used
format_paint

Format Painter

Copy all formatting from one cell and paint it onto another. Click once to apply once; double-click to lock and apply to multiple ranges. Press Esc to release.

tab

Sheet Management

Double-click any sheet tab to rename it inline. Right-click to change tab color, duplicate the sheet, or protect specific ranges to prevent accidental edits.

view_module Grid & View Controls

straighten

Rows & Columns Sizing

Drag borders to resize, or right-click to set exact pixel values. Double-click borders to auto-fit to content. You can also insert or delete rows/columns via right-click without breaking script references.

ac_unit

Freeze Panes

Pin top rows or leftmost columns so headers or symbols stay visible when scrolling large datasets. Access via View → Freeze.

filter_list Sort & Filter

sort

Sorting Data

Single-column: Click any column header's sort arrow to sort A→Z or Z→A.
Multi-column: Data → Sort range → sort by up to 3 columns in sequence (e.g. sort by Sector first, then Change%).

filter_alt

Filtering & Filter Views

Enable filter dropdowns on headers to show matching rows by value or condition. Type in the filter search box to quickly narrow down lists. Save Filter Views to switch between configurations (like FO vs Cash) without disturbing other users.

pivot_table_chart

Slicer Control

Add a floating slicer control that filters a range by clicking buttons. Provides one-click segment switching without interacting with standard dropdowns.

lightbulb
Pro tip

Use Format Painter (double-click to lock) combined with Paste Special → Format only to rapidly propagate a polished cell style across your entire sheet after designing one reference cell.

Truedata Icon Sheets by Truedata

Empowering traders and analysts with high-performance real-time market data directly within their spreadsheets.

© 2026 TrueData Market Data Services LLP. All rights reserved.