Meet QuantShell

QuantShell is QuantOffice’s desktop spreadsheet app. Build a list, calculate totals, format a report and share a PDF. This guide follows the controls in QuantShell 1.0.0, the first company release.

WHERE TO FIND ITStart here

Step by step

1. Install the package for your computer.
2. Open QuantShell and click A1 to start.
3. Enter a few values, then use the ribbon tabs to find tools.
4. Save your editable workbook as .qsheet before making an XLSX, CSV or PDF copy.

Try it

Start with Team-sales.qsheet. Change C2 from 12 to 15 and watch E2 change from 3,000 to 3,750.

Keep learning

Install on your Mac

The Mac package is for Apple Silicon Macs. Opening a disk image mounts an installation disk; it does not install the app by itself.

WHERE TO FIND ITQuantShell-1.0.0-arm64.dmg

Step by step

1. Double-click QuantShell-1.0.0-arm64.dmg.
2. Drag QuantShell from the disk window into Applications.
3. Open Applications, then double-click QuantShell.
4. Eject the mounted QuantShell disk after installation.

Keep learning

Install on Windows

Use the Windows x64 setup program to install QuantShell on a compatible 64-bit Windows computer.

WHERE TO FIND ITQuantShell-1.0.0-Windows-x64-Setup.exe

Step by step

1. Download the EXE from the company release.
2. Double-click it and follow the installation wizard.
3. Choose an installation folder if asked and finish installation.
4. Open QuantShell, enter a test value and save a .qsheet workbook.

Keep learning

Find your way around

Think of the window as six areas: quick tools, command search, ribbon, formula bar, grid and sheet/status bars.

WHERE TO FIND ITThe main window

Step by step

1. Use the top-left Save, Undo and Redo icons for frequent actions.
2. Click a tab such as Home, Insert or Data to change tools.
3. Look at the name box to see the active cell address.
4. Read or edit the active value in the formula bar.
5. Use worksheet tabs at the bottom to switch sheets and the status bar to inspect a selection.

Keep learning

Make your first sales worksheet

Learn the basics with a small, safe example. The sample has teams, products, quantities, prices and calculated totals.

WHERE TO FIND ITThe supplied Team-sales.qsheet practice workbook

Step by step

1. Open Team-sales.qsheet through File → Open.
2. Click C2, type 15 and press Enter. E2 should show 3,750.
3. Select E2:E6 using the name box. Choose Home → Number → Currency.
4. Select A1:F6. Open Insert → Table, then choose Create or format as table.
5. Save a copy as My first report.qsheet.

Try it

A1:F1: Team, Product, Units, Unit price, Total, Date
E2: =C2*D2
E3: =C3*D3
Use Undo to compare before and after changing C2.

Keep learning

Keyboard shortcuts at a glance

Use Ctrl on Windows and Cmd on Mac for the shared shortcuts below. Some function keys require Fn on a Mac keyboard.

WHERE TO FIND ITKeyboard and native Edit menu

Step by step

1. Click the grid before using a worksheet shortcut.
2. Use Ctrl/Cmd+S to save, Z to undo and Y to redo. The Mac Edit menu also uses Cmd+Shift+Z for redo.
3. Use arrows to move, Shift+arrows to extend, Enter/Shift+Enter to move down/up and F2 to edit.
4. Use Ctrl/Cmd+1 for Format Cells, F4 while editing to cycle reference locks and Alt+Enter for a line break.
5. Use Ctrl/Cmd+D/R to fill down/right, K for a link, F for Find, H for Replace, G or F5 for Go to and Shift+F11 for a new sheet.

Keep learning

Find a command quickly

You do not need to remember every ribbon location. Command search lists matching actions.

WHERE TO FIND ITSearch at the top of the app

Step by step

1. Press Alt+Q or click Search.
2. Type a short term such as column, formats, notes or freeze.
3. Click the matching result to run it.
4. If no result appears, shorten the word or use the relevant tab.

Keep learning

Start a new workbook

Create a blank workbook with one worksheet.

WHERE TO FIND ITFile → New

Step by step

1. Save your current work first if needed.
2. Choose File → New.
3. Respond to any confirmation about unsaved work.
4. Click A1 and enter your first value.

Keyboard Ctrl/Cmd+N

Try it

Use File → Save As to keep two versions instead of starting over.

Keep learning

Open a workbook or CSV

Open an editable QuantShell workbook, a supported XLSX workbook or a UTF-8 CSV file.

WHERE TO FIND ITFile → Open; Data → From XLSX / CSV

Step by step

1. Choose File → Open.
2. Select a .qsheet, .xlsx or .csv file.
3. Read any import message before changing the file.
4. Save a .qsheet copy for continued work.

Keyboard Ctrl/Cmd+O

Try it

Use a copy of a company workbook for your first import.

Keep learning

Save your editable workbook

A .qsheet file retains QuantShell’s own workbook state, including app-specific charts, scripts and summaries.

WHERE TO FIND ITFile → Save; top-left Save icon

Step by step

1. Click Save.
2. Choose a location and filename on the first save.
3. Wait for Saved locally in the status bar.
4. Save again after important changes.

Keyboard Ctrl/Cmd+S

Try it

Team sales.qsheet

Keep learning

Save a separate copy

Keep the original while making another editable version.

WHERE TO FIND ITFile → Save as; click the workbook name

Step by step

1. Choose File → Save as or click the workbook name.
2. Choose a new folder or filename.
3. Save the .qsheet copy.
4. Check the displayed filename before continuing to edit.

Keyboard Ctrl/Cmd+Shift+S; F12

Try it

Sales November review.qsheet

Keep learning

Keep a QuantShell original

Save the app’s native format before exporting to another application.

WHERE TO FIND ITFile → QuantShell workbook

Step by step

1. Choose File → QuantShell workbook.
2. Give the file a .qsheet name.
3. Keep this file alongside any exported copy.
4. Reopen the .qsheet when you need to edit QuantShell objects or scripts.

Keep learning

Share an XLSX copy

Export worksheet values, supported formulas, formatting and selected workbook metadata for spreadsheet exchange.

WHERE TO FIND ITFile → XLSX

Step by step

1. Save a .qsheet original first.
2. Choose File → XLSX.
3. Read and confirm the export note if charts or pivot summaries are present.
4. Save the .xlsx copy and inspect it in the receiving application.

Keep learning

Export the active sheet as CSV

CSV is useful for passing plain rows and columns to another tool.

WHERE TO FIND ITFile → CSV

Step by step

1. Switch to the worksheet you want to share.
2. Choose File → CSV.
3. Save the UTF-8 CSV file.
4. Open the result to confirm values and column order.

Keep learning

Recover an interrupted session

If a local recovery copy exists, QuantShell offers to restore it when it opens.

WHERE TO FIND ITRecovery prompt on startup

Step by step

1. Reopen the application after an interruption.
2. Read the Recover unsaved work prompt.
3. Choose Restore to inspect the recovered workbook.
4. Save it with a new .qsheet filename before continuing.

Keep learning

Select the cells you want

Most commands work on the active cell or selected rectangle. Check the selection before applying a change.

WHERE TO FIND ITGrid; name box at the left of the formula bar

Step by step

1. Click one cell to make it active.
2. Drag across cells for a rectangle, or hold Shift and click the far corner.
3. For an exact range, type A1:F6 in the name box and press Enter.
4. Use Ctrl/Cmd+click for individual extra cells when formatting or clearing.

Keyboard Shift+arrows extends; Ctrl/Cmd+A selects the supported grid

Try it

A1:F6; E2:E6; C2

Keep learning

Enter, edit or cancel a value

A click selects a cell. Typing replaces its value; F2 or a double-click lets you edit the existing value.

WHERE TO FIND ITGrid; formula bar

Step by step

1. Click a cell and type a value.
2. Press Enter to finish and move down, or Tab to finish and move right.
3. To edit existing text, press F2 or double-click the cell.
4. Use Escape to cancel an unfinished edit.
5. Use Alt+Enter inside the editor for a line break.

Keyboard F2 edits; Enter/Shift+Enter moves down/up

Try it

250
15%
2026-11-01
=SUM(E2:E6)

Keep learning

Use the formula bar

The formula bar shows the selected cell’s stored value or formula, rather than only its formatted result.

WHERE TO FIND ITFormula bar above the grid

Step by step

1. Select a cell.
2. Click the long formula field to edit its contents.
3. Click the tick or press Enter to accept.
4. Click the cross or press Escape to cancel.
5. Use the chevron at the right to expand or collapse the field.

Keep learning

Jump to a cell or named range

Use an address when the destination is far away.

WHERE TO FIND ITName box; Search → Go to cell or named range

Step by step

1. Type D100 in the name box and press Enter to select that cell.
2. Type A1:F6 to select a rectangle.
3. Alternatively search for Go to and enter the reference in its dialog.
4. Use an existing defined name to jump to its range.

Keyboard Ctrl/Cmd+G or F5

Try it

D100; A1:F6; SalesTotals

Options in this control

Keep learning

Undo an action safely

Undo restores the prior workbook state, including supported values, formatting and structural changes.

WHERE TO FIND ITTop-left Undo; native Edit → Undo

Step by step

1. Make a small change, such as changing C2.
2. Click Undo or use the shortcut.
3. Check that the original value and dependent results return.
4. Select another cell and use Redo if you want the change back.

Keyboard Ctrl/Cmd+Z

Try it

Change C2 from 12 to 15, Undo, then Redo.

Keep learning

Restore an undone change

Redo puts back the last undone workbook change.

WHERE TO FIND ITTop-left Redo; native Edit → Redo

Step by step

1. Use Undo at least once.
2. Click Redo.
3. Check the result.
4. If Redo is unavailable, check whether you made a new edit after Undo.

Keyboard Ctrl/Cmd+Y; Mac Edit menu: Cmd+Shift+Z

Keep learning

Copy cells with formulas and formatting

Copy a rectangle, then paste it at the top-left of its new location.

WHERE TO FIND ITHome → Clipboard → Copy

Step by step

1. Select the source cells.
2. Choose Copy.
3. Click the first destination cell.
4. Choose Paste.

Keyboard Ctrl/Cmd+C

Try it

Copy E2 to E3: =C2*D2 becomes =C3*D3.

Keep learning

Move cells with Cut and Paste

Cut marks a pending move. The source stays in place until you paste.

WHERE TO FIND ITHome → Clipboard → Cut

Step by step

1. Select a rectangle and choose Cut.
2. Click an empty destination in the same worksheet.
3. Choose Paste and confirm replacement if the destination contains values.
4. Use Undo to reverse the entire move, or press Escape before Paste to cancel Cut.

Keyboard Ctrl/Cmd+X; Escape cancels pending Cut

Try it

Move A1:B3 to H1 without deleting the source before Paste.

Keep learning

Paste into the right place

The selected cell is the upper-left corner of the pasted block.

WHERE TO FIND ITHome → Clipboard → Paste

Step by step

1. Copy or cut a source range.
2. Click one destination cell.
3. Choose Paste.
4. Inspect formulas and any existing destination data.

Keyboard Ctrl/Cmd+V

Keep learning

Paste values, formulas, formats or transposed values

Choose which part of copied cells you want to reuse.

WHERE TO FIND ITHome → Clipboard → Paste special

Step by step

1. Copy a contiguous range.
2. Click the destination cell.
3. Choose Paste special.
4. Choose Formulas only, All, Values only, Formats only or Transpose values, then Apply.
5. Check the pasted result before deleting the source.

Try it

Copy A1:C2 → Transpose values produces a 3-row × 2-column result.

Options in this control

Keep learning

Delete contents without losing formatting

Use Clear contents to empty values while keeping the cell’s appearance.

WHERE TO FIND ITHome → Editing → Clear contents; Delete key

Step by step

1. Select only the cells to empty.
2. Press Delete or choose Clear contents.
3. Check that the values are empty and formatting remains.
4. Use Undo if you selected too much.

Keyboard Delete or Backspace

Keep learning

Clear values, formats and notes together

Clear All removes the selected cell records rather than just their displayed contents.

WHERE TO FIND ITHome → Cells → Clear all cell data and formatting

Step by step

1. Select the range.
2. Open Home → Cells.
3. Choose Clear all cell data and formatting.
4. Apply, then check the result; use Undo to restore it.

Keep learning

Remove manual cell formatting

Return selected cells to the default appearance while keeping their contents.

WHERE TO FIND ITHome → Cells → Clear formats

Step by step

1. Select the formatted cells.
2. Choose Home → Cells → Clear formats.
3. Apply the action.
4. Check values and formulas remain.

Keep learning

Fill a formula down a selection

Put the source in the top row of the selection. Fill Down copies it into the rows below with relative references adjusted.

WHERE TO FIND ITHome → Editing → Fill down

Step by step

1. Enter =C2*D2 in E2.
2. Select E2:E6, including the source cell.
3. Choose Fill down or press the shortcut.
4. Inspect E3: its formula should be =C3*D3.

Keyboard Ctrl/Cmd+D

Try it

E2: =C2*D2
Select E2:E6 → Fill down.

Keep learning

Fill across columns

Fill Right uses the leftmost selected column as the source.

WHERE TO FIND ITHome → Cells → Fill right

Step by step

1. Enter the source value or formula.
2. Select a rectangle including the source column and destination columns.
3. Choose Home → Cells → Fill right.
4. Check that relative references moved horizontally.

Keyboard Ctrl/Cmd+R

Try it

B2: =A2*2
Select B2:D2 → Fill right.

Keep learning

Drag the fill handle or extend a series

The fill handle copies a value, extends relative formulas, or continues a simple numeric series.

WHERE TO FIND ITSmall square at the bottom-right of the selection

Step by step

1. Select one source cell, or two numeric cells that establish a step.
2. Drag the small square down or right and release.
3. For adjacent continuous data, double-click the handle to fill down alongside it.
4. Use Undo if the result extends too far.

Try it

Type 1 in H2 and 3 in H3. Select H2:H3 and drag down.

Keep learning

Move a selected block with the mouse

Drag the selection border when you want to move the block, rather than extend its selection.

WHERE TO FIND ITSelection border

Step by step

1. Select a rectangle.
2. Place the pointer on its move border, away from the fill handle.
3. Drag to the new upper-left location and release.
4. Confirm replacement if asked; Undo restores the move.

Try it

Select H2:H6 and drag its border to J2.

Keep learning

Insert a row between existing rows

Insert a blank row above the active row.

WHERE TO FIND ITHome → Insert row; row-header context menu

Step by step

1. Click a cell in the row that should move down.
2. Choose Home → Insert row.
3. Enter data in the new blank row.
4. Inspect nearby formulas after structural changes.

Try it

To add a row between 3 and 4, select row 4 and insert above.

Keep learning

Insert a column between existing columns

Insert a blank column before the active column.

WHERE TO FIND ITHome → Insert column; column-header context menu

Step by step

1. Click a cell in the column that should move right.
2. Choose Home → Insert column.
3. Add your header and data.
4. Check formulas and table/chart ranges.

Try it

To insert between D and E, select E and choose Insert column.

Keep learning

Delete an entire row

Remove a worksheet row and shift the following data into its place.

WHERE TO FIND ITHome → Cells → Delete row

Step by step

1. Click a cell in the row to remove.
2. Open Home → Cells and select Delete row.
3. Apply and inspect adjacent data.
4. Use Undo immediately if the wrong row was removed.

Keep learning

Delete an entire column

Remove a worksheet column and shift the following data into its place.

WHERE TO FIND ITHome → Cells → Delete column

Step by step

1. Click a cell in the column to remove.
2. Open Home → Cells and select Delete column.
3. Apply and inspect adjacent data.
4. Use Undo immediately if the wrong column was removed.

Keep learning

Move column D next to J

Move a full column to a chosen final column position.

WHERE TO FIND ITRight-click the D column heading → Move column

Step by step

1. Right-click the D heading.
2. Choose Move column.
3. Enter 10 for final position J, or 11 for final position K, then Apply.
4. Check the resulting headers and values.

Try it

A=1, D=4, J=10, K=11. Use Undo to reverse the move.

Keep learning

Move an entire row

Reorder a row while moving its supported contents and references together.

WHERE TO FIND ITRight-click row number → Move row

Step by step

1. Right-click the row number.
2. Choose Move row.
3. Enter the final row number.
4. Apply and check the result.

Keep learning

Set row height and column width

Use explicit pixel sizes for a predictable worksheet layout.

WHERE TO FIND ITHome → Cells → Row height / column width

Step by step

1. Select cells spanning the rows and columns to size.
2. Open Home → Cells → Row height / column width.
3. Enter width 20–1000 and height 20–500 pixels.
4. Apply and inspect the selection.

Try it

Column width: 120; Row height: 28

Options in this control

Keep learning

Fit columns to their content

AutoFit estimates column width from contents and removes explicit row heights.

WHERE TO FIND ITHome → Cells → Auto-fit rows and columns

Step by step

1. Select the relevant columns or cells.
2. Choose Home → Cells → Auto-fit rows and columns.
3. Inspect long text and wrapped cells.
4. Adjust manually if the estimate is not enough.

Keep learning

Hide selected rows

Temporarily remove rows from view without deleting their data.

WHERE TO FIND ITHome → Cells → Hide selected rows

Step by step

1. Select cells spanning the rows to hide.
2. Open Home → Cells and choose Hide selected rows.
3. Apply.
4. Use Unhide all to bring them back.

Keep learning

Hide selected columns

Temporarily remove columns from view without deleting their data.

WHERE TO FIND ITHome → Cells → Hide selected columns

Step by step

1. Select cells spanning the columns to hide.
2. Open Home → Cells and choose Hide selected columns.
3. Apply.
4. Use Unhide all to bring them back.

Keep learning

Bring hidden rows and columns back

Restore manually hidden worksheet lanes.

WHERE TO FIND ITHome → Cells → Unhide all

Step by step

1. Choose Home → Cells.
2. Choose Unhide all.
3. Apply and inspect the sheet.
4. If rows are still filtered out, clear the active filter separately.

Keep learning

Add and switch worksheets

Keep separate lists or summaries in one workbook.

WHERE TO FIND ITInsert → New sheet; + beside worksheet tabs

Step by step

1. Click the + at the bottom, or choose Insert → New sheet.
2. Click a worksheet tab to switch back.
3. Use the bottom navigation arrows to move between sheets.
4. Save the workbook to keep all worksheets.

Keyboard Shift+F11; Ctrl/Cmd+PageUp/PageDown switches sheets

Keep learning

Rename a worksheet

Choose a short name that explains the contents.

WHERE TO FIND ITDouble-click worksheet tab; Home → Cells → Rename sheet

Step by step

1. Double-click the worksheet tab, or use Cells → Rename sheet.
2. Type a unique name.
3. Apply.
4. Check formulas referencing that worksheet.

Try it

Team sales; November totals

Options in this control

Keep learning

Delete a worksheet

Remove a worksheet from the current workbook.

WHERE TO FIND ITHome → Cells → Delete sheet

Step by step

1. Switch to the worksheet to remove.
2. Choose Cells → Delete sheet.
3. Read the confirmation and choose Delete sheet.
4. Use Undo if needed before making further changes.

Keep learning

Choose a font family

Type a font family or choose from fonts detected on this computer.

WHERE TO FIND ITHome → Font → Font name

Step by step

1. Select cells.
2. Click the Font name field.
3. Type or choose a family, then finish the change.
4. Inspect the text before sharing the workbook.

Try it

Arial; Georgia; Times New Roman

Keep learning

Set an exact font size

Choose a suggested size or type a value from 1 to 409 points in half-point steps.

WHERE TO FIND ITHome → Font → Font size

Step by step

1. Select cells.
2. Click Font size.
3. Enter 13.5, for example, and finish the change.
4. Increase row height if the text is clipped.

Keyboard Ctrl/Cmd+Shift+P focuses Size

Try it

13.5

Keep learning

Increase font size

Step through common font sizes without typing a number.

WHERE TO FIND ITHome → Font → Grow font

Step by step

1. Select the cells.
2. Click Grow font.
3. Repeat until the text is the size you want.
4. Check the row height and column width.

Keyboard Ctrl/Cmd+Shift+>

Try it

Common sizes: 8, 9, 10, 11, 12, 14, 16, 18, 20, 22, 24, 26, 28, 36, 48, 72.

Keep learning

Decrease font size

Step through common font sizes without typing a number.

WHERE TO FIND ITHome → Font → Shrink font

Step by step

1. Select the cells.
2. Click Shrink font.
3. Repeat until the text is the size you want.
4. Check the row height and column width.

Keyboard Ctrl/Cmd+Shift+<

Try it

Common sizes: 8, 9, 10, 11, 12, 14, 16, 18, 20, 22, 24, 26, 28, 36, 48, 72.

Keep learning

Make text bold

Apply or remove bold on the selected cells.

WHERE TO FIND ITHome → Font → Bold

Step by step

1. Select the cells.
2. Click Bold.
3. Click again to remove it.
4. Use Undo if you want the previous style back.

Keyboard Ctrl/Cmd+B

Keep learning

Make text italic

Apply or remove italic on the selected cells.

WHERE TO FIND ITHome → Font → Italic

Step by step

1. Select the cells.
2. Click Italic.
3. Click again to remove it.
4. Use Undo if you want the previous style back.

Keyboard Ctrl/Cmd+I

Keep learning

Toggle a single underline

Apply or remove underline on the selected cells.

WHERE TO FIND ITHome → Font → Underline

Step by step

1. Select the cells.
2. Click Underline.
3. Click again to remove it.
4. Use Undo if you want the previous style back.

Keyboard Ctrl/Cmd+U

Keep learning

Choose an underline style

Use the dropdown when you need more than a single underline.

WHERE TO FIND ITHome → Font → Underline options

Step by step

1. Select cells.
2. Open Underline options.
3. Choose None, Single, Double, Single Accounting or Double Accounting.
4. Apply and inspect the result.

Options in this control

Keep learning

Format font effects in one dialog

Preview several font changes together, then apply them as one workbook edit.

WHERE TO FIND ITHome → Font → Format Cells Font

Step by step

1. Select cells and open Format Cells Font.
2. Choose a family, style, size, underline and color.
3. Choose strikethrough, superscript or subscript if needed.
4. Inspect the sample. Click Apply to commit, or Cancel to leave cells unchanged.

Try it

Font: Georgia; Style: Bold Italic; Size: 13.5; Underline: Double

Options in this control

Keep learning

Use the Format Cells tabs

One dialog holds Number, Font, Alignment, Border and Fill settings.

WHERE TO FIND ITHome → Cells → Number formats; right-click a cell → Format Cells

Step by step

1. Select the range.
2. Press Ctrl/Cmd+1 or choose Format Cells from cell options.
3. Click a tab and change only the settings you need.
4. Apply, then use Undo once to restore the previous formatting.

Keyboard Ctrl/Cmd+1

Options in this control

Keep learning

Add borders around a range

Use a border to separate a heading, table or total.

WHERE TO FIND ITHome → Font → Borders

Step by step

1. Select a rectangle.
2. Open Borders.
3. Choose an edge, All Borders, Outside Borders or a top/bottom preset.
4. Choose the line style and hex color, then Apply.

Try it

Select A1:F6 → Outside Borders → thin → #246547.

Options in this control

Keep learning

Fill cells with color

Highlight important input cells or headings.

WHERE TO FIND ITHome → Font → Fill color; Fill color options

Step by step

1. Select cells.
2. Use the paint-bucket color control for a color, or open Fill color options.
3. In Fill, choose a palette color or enter a six-digit hex value.
4. Apply.

Try it

A soft yellow input fill: #fff2a8

Keep learning

Change the text color

Set a readable foreground color for selected cells.

WHERE TO FIND ITHome → Font → Font color; Font color options

Step by step

1. Select cells.
2. Use the font-color control or open Font color options.
3. Choose or enter a hex color in the Font tab.
4. Apply and check the contrast with the background.

Try it

Dark text #25282d on white #ffffff

Keep learning

Align left within cells

Control where the content sits horizontally.

WHERE TO FIND ITHome → Alignment → Align left

Step by step

1. Select cells.
2. Choose Align left.
3. Check that the content fits the column.
4. Use Format Cells → Alignment → general to restore automatic alignment.

Keep learning

Center within cells

Control where the content sits horizontally.

WHERE TO FIND ITHome → Alignment → Center

Step by step

1. Select cells.
2. Choose Center.
3. Check that the content fits the column.
4. Use Format Cells → Alignment → general to restore automatic alignment.

Keep learning

Align right within cells

Control where the content sits horizontally.

WHERE TO FIND ITHome → Alignment → Align right

Step by step

1. Select cells.
2. Choose Align right.
3. Check that the content fits the column.
4. Use Format Cells → Alignment → general to restore automatic alignment.

Keep learning

Top align

Position content vertically inside taller rows.

WHERE TO FIND ITHome → Alignment → Top align

Step by step

1. Select cells in a row with enough height.
2. Choose Top align.
3. Resize the row to inspect the result.
4. Use Undo to restore the prior alignment.

Keep learning

Middle align

Position content vertically inside taller rows.

WHERE TO FIND ITHome → Alignment → Middle align

Step by step

1. Select cells in a row with enough height.
2. Choose Middle align.
3. Resize the row to inspect the result.
4. Use Undo to restore the prior alignment.

Keep learning

Bottom align

Position content vertically inside taller rows.

WHERE TO FIND ITHome → Alignment → Bottom align

Step by step

1. Select cells in a row with enough height.
2. Choose Bottom align.
3. Resize the row to inspect the result.
4. Use Undo to restore the prior alignment.

Keep learning

Wrap a long label onto multiple lines

Keep a long cell value within the column rather than running on one line.

WHERE TO FIND ITHome → Alignment → Wrap text

Step by step

1. Select cells containing long text.
2. Choose Wrap text.
3. Check the row height.
4. Click Wrap text again to turn it off.

Try it

A long description in B2 can use two or three lines without widening column B.

Keep learning

Rotate cell text

Rotate short headers when you have narrow columns.

WHERE TO FIND ITHome → Alignment → Orientation

Step by step

1. Select the header cells.
2. Open Orientation.
3. Choose 0, 45, -45, 90 or -90 degrees.
4. Apply and adjust row height.

Options in this control

Keep learning

Increase indent

Adjust the left inset within selected cells.

WHERE TO FIND ITHome → Alignment → Increase indent

Step by step

1. Select cells.
2. Click Increase indent.
3. Repeat if needed.
4. Check the remaining space for text.

Keep learning

Decrease indent

Adjust the left inset within selected cells.

WHERE TO FIND ITHome → Alignment → Decrease indent

Step by step

1. Select cells.
2. Click Decrease indent.
3. Repeat if needed.
4. Check the remaining space for text.

Keep learning

Merge and center a heading

Create one visual cell across a selected rectangle.

WHERE TO FIND ITHome → Alignment → Merge & center

Step by step

1. Save or move any values you need from the selected range.
2. Select the rectangle.
3. Choose Merge & center.
4. Enter or inspect the top-left value.

Keep learning

Unmerge cells

Return a merged area to individual cells.

WHERE TO FIND ITHome → Cells → Unmerge selection

Step by step

1. Select the merged area or overlapping cells.
2. Choose Cells → Unmerge selection.
3. Apply.
4. Fill any empty cells deliberately.

Keep learning

Merge each selected row separately

Keep multiple rows while merging across the selected columns in each row.

WHERE TO FIND ITHome → Cells → Merge across each row

Step by step

1. Check that only the first cell of each row contains content you need.
2. Select a multi-row rectangle.
3. Choose Merge across each row.
4. Apply and inspect each row.

Keep learning

Choose a number-format category

A number format changes presentation while keeping a usable numeric value.

WHERE TO FIND ITHome → Number → format dropdown

Step by step

1. Select cells.
2. Open the Number dropdown.
3. Choose General, Number, Currency, Accounting, Short Date, Long Date, Time, Percentage, Fraction, Scientific or Text.
4. Use More number formats for a custom code.

Try it

1250.5 → Number: 1,250.50
0.15 → Percentage: 15.00%
0.5 → Fraction: 1/2

Options in this control

Keep learning

Show money with a currency symbol

Apply the quick dollar currency format, or choose a different symbol through a custom format code.

WHERE TO FIND ITHome → Number → Currency

Step by step

1. Select numeric cells.
2. Click Currency for the quick dollar format.
3. For another symbol, open Format Cells → Number.
4. Enter a code such as ₹#,##0.00 and Apply.

Try it

₹#,##0.00; €#,##0.00; £#,##0.00

Keep learning

Show a value as a percentage

Display a fraction of one as a percent.

WHERE TO FIND ITHome → Number → Percent style

Step by step

1. Enter 0.15 in a cell.
2. Select it and click Percent style.
3. Check that it displays 15.00%.
4. Use decimal buttons if needed.

Try it

0.15 × 100 = 15%

Keep learning

Show thousands separators

Make larger numbers easier to scan.

WHERE TO FIND ITHome → Number → Comma style

Step by step

1. Select numeric cells.
2. Choose Comma style.
3. Check the two decimal places and group separators.
4. Use decimal controls to adjust common formats.

Try it

1234567.8 → 1,234,567.80

Keep learning

Increase decimal places

Change visible precision for common number formats.

WHERE TO FIND ITHome → Number → Increase decimal

Step by step

1. Select numeric cells.
2. Click Increase decimal.
3. Inspect the display.
4. Use Format Cells for a more specific custom code.

Keep learning

Decrease decimal places

Change visible precision for common number formats.

WHERE TO FIND ITHome → Number → Decrease decimal

Step by step

1. Select numeric cells.
2. Click Decrease decimal.
3. Inspect the display.
4. Use Format Cells for a more specific custom code.

Keep learning

Write a custom number or date format

Use a short code when a standard category is not enough.

WHERE TO FIND ITFormat Cells → Number → Format code

Step by step

1. Select cells and open Format Cells.
2. On Number, enter the format code.
3. Apply.
4. Check positive, negative, zero and text values before using the format widely.

Try it

#,##0.00
0.0%
dd-mmm-yyyy
h:mm AM/PM
0.00E+00
@

Keep learning

Apply a ready-made cell style

Use a small set of consistent styles for headings and results.

WHERE TO FIND ITHome → Styles → Cell styles

Step by step

1. Select cells.
2. Open Cell styles.
3. Choose Normal, Heading, Good, Bad, Neutral or Total.
4. Apply and inspect the selection.

Options in this control

Keep learning

Create a table or return it to a range

Use the table menu for the two table actions.

WHERE TO FIND ITHome → Format as table; Insert → Table

Step by step

1. Select the data with a header row.
2. Open the table menu.
3. Choose Create or format as table to define a table, or Convert current table to range to remove its definition.
4. Complete the next dialog or action.

Options in this control

Keep learning

Format a range as a table

A table adds a recognized data range with headers and striped styling.

WHERE TO FIND ITTable menu → Create or format as table

Step by step

1. Select A1:F6 in the practice workbook.
2. Open Insert → Table → Create or format as table.
3. Check the range and give the table a unique name such as TeamSales.
4. Apply.

Try it

Range: A1:F6; Name: TeamSales

Options in this control

Keep learning

Convert a table to ordinary cells

Remove the table definition while keeping its cell data.

WHERE TO FIND ITTable menu → Convert current table to range

Step by step

1. Click inside the table.
2. Open the Table menu.
3. Choose Convert current table to range.
4. Inspect the retained cells and styling.

Keep learning

Highlight values with conditional formatting

Create a simple rule whose fill changes when a cell’s value matches.

WHERE TO FIND ITHome → Styles → Conditional formatting

Step by step

1. Select the target range.
2. Open Conditional formatting → New highlight rule.
3. Choose Greater than, Less than, Equal to or Text contains.
4. Enter the comparison value and a hex fill color, then Apply.

Try it

Range E2:E6; Greater than 2000; color #c6efce

Options in this control

Keep learning

Remove conditional highlight rules

Clear rules that overlap your selected range.

WHERE TO FIND ITConditional formatting → Clear rules in selection

Step by step

1. Select the affected cells.
2. Open Conditional formatting.
3. Choose Clear rules in selection.
4. Apply and inspect the remaining manual/table styling.

Keep learning

Restrict what can be entered

Validation helps prevent unexpected entries within a selected range.

WHERE TO FIND ITData → Data validation → Set validation rules

Step by step

1. Select cells.
2. Open Data validation → Set validation rules.
3. Choose List, Whole number, Decimal or Text length.
4. Enter the choices or numeric bounds and Apply.
5. Try one allowed and one disallowed entry.

Try it

Whole number: Minimum 0, Maximum 100

Options in this control

Keep learning

Remove validation rules

Allow unrestricted input again by removing overlapping validation rules.

WHERE TO FIND ITData validation → Clear validation in selection

Step by step

1. Select the relevant cells.
2. Open Data validation.
3. Choose Clear validation in selection.
4. Apply, then test a new entry.

Keep learning

Write your first formula

A formula starts with = and calculates a result from values or cell references.

WHERE TO FIND ITA cell or the formula bar

Step by step

1. Click an empty cell.
2. Type =C2*D2 and press Enter.
3. Select the cell again to inspect its formula in the formula bar.
4. Change C2 and check that the result updates.

Try it

=C2*D2
=SUM(E2:E6)
=IF(C2>10,"Large","Small")

Keep learning

Keep references relative or locked

A reference can follow a copied formula or stay pinned to a row, column or both.

WHERE TO FIND ITInside the cell editor; F4

Step by step

1. Edit a formula with F2.
2. Select or place the caret in its A1-style reference.
3. Press F4 to cycle reference locks.
4. Commit, fill the formula to another cell and check its reference.

Keyboard F4 while editing

Try it

=C2*$H$1
='Team sales'!E2

Keep learning

Add a total with AutoSum

AutoSum inserts a SUM formula using selected rows, or contiguous numeric cells above an empty active cell.

WHERE TO FIND ITHome → Editing → AutoSum; Formulas → AutoSum

Step by step

1. Select E7 beneath the practice values E2:E6.
2. Click AutoSum.
3. Inspect the inserted formula.
4. Use Undo if the range is not the one you intended.

Try it

=SUM(E2:E6)

Keep learning

Choose a function and edit its arguments

The function dialog lists the categories available in the bundled calculation engine.

WHERE TO FIND ITFormulas → Insert function; fx beside the formula bar

Step by step

1. Select an empty destination.
2. Open Insert function.
3. Choose a category and function.
4. Edit the Formula field to use your own range and arguments.
5. Click Insert and inspect the result.

Try it

AVERAGE: =AVERAGE(C2:C6)
IF: =IF(C2>10,"Large","Small")

Options in this control

Keep learning

Financial function shortcut

Open the function picker near a category, then edit the expression before inserting it.

WHERE TO FIND ITFormulas → Financial

Step by step

1. Select an empty cell.
2. Click the category shortcut.
3. Check the category actually displayed and select a listed function.
4. Edit the formula arguments and insert.

Try it

No Financial functions are exposed by this build’s catalogue.

Keep learning

Logical function shortcut

Open the function picker near a category, then edit the expression before inserting it.

WHERE TO FIND ITFormulas → Logical

Step by step

1. Select an empty cell.
2. Click the category shortcut.
3. Check the category actually displayed and select a listed function.
4. Edit the formula arguments and insert.

Try it

=IF(C2>10,"Large","Small")

Keep learning

Text function shortcut

Open the function picker near a category, then edit the expression before inserting it.

WHERE TO FIND ITFormulas → Text

Step by step

1. Select an empty cell.
2. Click the category shortcut.
3. Check the category actually displayed and select a listed function.
4. Edit the formula arguments and insert.

Try it

=UPPER(B2)

Keep learning

Date & Time function shortcut

Open the function picker near a category, then edit the expression before inserting it.

WHERE TO FIND ITFormulas → Date & Time

Step by step

1. Select an empty cell.
2. Click the category shortcut.
3. Check the category actually displayed and select a listed function.
4. Edit the formula arguments and insert.

Try it

=DATE(2026,11,1)

Keep learning

Lookup & Reference function shortcut

Open the function picker near a category, then edit the expression before inserting it.

WHERE TO FIND ITFormulas → Lookup & Reference

Step by step

1. Select an empty cell.
2. Click the category shortcut.
3. Check the category actually displayed and select a listed function.
4. Edit the formula arguments and insert.

Try it

=INDEX(B2:B6,2)

Keep learning

Math & Trig function shortcut

Open the function picker near a category, then edit the expression before inserting it.

WHERE TO FIND ITFormulas → Math & Trig

Step by step

1. Select an empty cell.
2. Click the category shortcut.
3. Check the category actually displayed and select a listed function.
4. Edit the formula arguments and insert.

Try it

=ROUND(D2/3,2)

Keep learning

Statistical function shortcut

Open the function picker near a category, then edit the expression before inserting it.

WHERE TO FIND ITFormulas → Statistical

Step by step

1. Select an empty cell.
2. Click the category shortcut.
3. Check the category actually displayed and select a listed function.
4. Edit the formula arguments and insert.

Try it

=AVERAGE(C2:C6)

Keep learning

Browse the function-name catalogue

See the complete set of names exposed in this release’s function picker, grouped by category.

WHERE TO FIND ITGuide → Function catalogue

Step by step

1. Open the Function catalogue link in this guide’s index.
2. Use browser Find or guide search for a name.
3. Return to QuantShell → Formulas → Insert function.
4. Enter the full formula with your arguments and verify a small example first.

Financial

No entries in this release.

Logical

AND, FALSE, IF, IFERROR, IFNA, IFS, NOT, OR, TRUE, XOR, SWITCH

Text

ASC, BAHTTEXT, CHAR, CLEAN, CODE, CONCAT, CONCATENATE, DBCS, DOLLAR, EXACT, FIND, FINDB, FIXED, LEFT, LEFTB, LOWER, MID, MIDB, NUMBERVALUE, PROPER, REPLACE, REPLACEB, REPT, RIGHT, RIGHTB, SEARCH, SEARCHB, T, TEXT, TRIM, UNICHAR, UNICODE, TEXTJOIN

Date & Time

DATE, DATEDIF, DATEVALUE, DAY, DAYS, DAYS360, EDATE, EOMONTH, HOUR, ISOWEEKNUM, MINUTE, MONTH, NETWORKDAYS, NETWORKDAYS.INTL, NOW, SECOND, TIME, TIMEVALUE, TODAY, WEEKDAY, WEEKNUM, WORKDAY, WORKDAY.INTL, YEAR, YEARFRAC

Lookup & Reference

ADDRESS, AREAS, COLUMN, COLUMNS, HLOOKUP, INDEX, ROW, ROWS, TRANSPOSE, VLOOKUP, XLOOKUP, XMATCH, MATCH, CHOOSE

Math & Trig

ABS, ACOS, ACOSH, ACOT, ACOTH, ARABIC, ASIN, ASINH, ATAN, ATAN2, ATANH, BASE, CEILING, CEILING.MATH, CEILING.PRECISE, COMBIN, COMBINA, COS, COSH, COT, COTH, CSC, CSCH, DECIMAL, DEGREES, EVEN, EXP, FACT, FACTDOUBLE, FLOOR, FLOOR.MATH, FLOOR.PRECISE, GCD, INT, ISO.CEILING, LCM, LN, LOG, LOG10, MDETERM, MMULT, MOD, MROUND, MULTINOMIAL, MUNIT, ODD, PI, POWER, PRODUCT, QUOTIENT, RADIANS, RAND, RANDBETWEEN, ROMAN, ROUND, ROUNDDOWN, ROUNDUP, SEC, SECH, SERIESSUM, SIGN, SIN, SINH, SQRT, SQRTPI, SUM, SUMIF, SUMPRODUCT, SUMSQ, SUMX2MY2, SUMX2PY2, SUMXMY2, TAN, TANH, TRUNC

Statistical

AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF, BETA.DIST, BETA.INV, BINOM.DIST, BINOM.DIST.RANGE, BINOM.INV, CHISQ.DIST, CHISQ.DIST.RT, CHISQ.INV, CHISQ.INV.RT, CHISQ.TEST, CONFIDENCE.NORM, CONFIDENCE.T, CORREL, COUNT, COUNTIF, COVARIANCE.P, COVARIANCE.S, DEVSQ, EXPON.DIST, F.DIST, F.DIST.RT, F.INV, F.INV.RT, F.TEST, FISHER, FISHERINV, FORECAST, FORECAST.LINEAR, FREQUENCY, GAMMA, GAMMA.DIST, GAMMA.INV, GAMMALN, GAMMALN.PRECISE, GAUSS, GEOMEAN, GROWTH, HARMEAN, HYPGEOM.DIST, INTERCEPT, KURT, LOGNORM.DIST, LOGNORM.INV, NEGBINOM.DIST, NORM.DIST, NORM.INV, NORM.S.DIST, NORM.S.INV, PHI, POISSON.DIST, STANDARDIZE, T.DIST, T.DIST.2T, T.DIST.RT, T.INV, T.INV.2T, WEIBULL.DIST

Engineering

BESSELI, BESSELJ, BESSELK, BESSELY, BIN2DEC, BIN2HEX, BIN2OCT, BITAND, BITLSHIFT, BITOR, BITRSHIFT, BITXOR, COMPLEX, DEC2BIN, DEC2HEX, DEC2OCT, DELTA, ERF, ERFC, GESTEP, HEX2BIN, HEX2DEC, HEX2OCT, IMABS, IMAGINARY, IMARGUMENT, IMCONJUGATE, IMCOS, IMCOSH, IMCOT, IMCSC, IMCSCH, IMDIV, IMEXP, IMLN, IMLOG10, IMLOG2, IMPOWER, IMPRODUCT, IMREAL, IMSEC, IMSECH, IMSIN, IMSINH, IMSQRT, IMSUB, IMSUM, IMTAN, OCT2BIN, OCT2DEC, OCT2HEX

Information

ERROR.TYPE, ISBLANK, ISERR, ISERROR, ISEVEN, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, ISTEXT, N, NA, TYPE

More

ENCODEURL

Keep learning

Give a range a useful name

Use a short name to find a range and simplify supported formulas.

WHERE TO FIND ITFormulas → Define name; name box

Step by step

1. Select E2:E6.
2. Choose Define name.
3. Enter SalesTotals and check the range.
4. Apply. Type SalesTotals in the name box and press Enter to return to it.

Try it

SalesTotals → Team sales!E2:E6

Options in this control

Keep learning

Inspect or delete defined names

Review names and the worksheet ranges they refer to.

WHERE TO FIND ITFormulas → Name manager

Step by step

1. Open Name manager.
2. Read the listed name/range pairs.
3. Leave the deletion field blank to keep them, or enter a name to remove.
4. Apply.

Options in this control

Keep learning

Inspect direct formula references

Read the direct A1-style references used by the selected formula.

WHERE TO FIND ITFormulas → Trace precedents

Step by step

1. Select a formula cell such as E2.
2. Choose Trace precedents.
3. Read the references listed in the dialog.
4. Close it and inspect those source cells.

Keep learning

Find formulas directly using a cell

Locate direct A1-style formulas that depend on the selected cell.

WHERE TO FIND ITFormulas → Trace dependents

Step by step

1. Select C2 in the practice sheet.
2. Choose Trace dependents.
3. Read the worksheet, cell and formula entries.
4. Close the dialog and inspect an entry’s destination.

Keep learning

Show formulas in the grid

Switch from calculated results to formula text for inspection.

WHERE TO FIND ITFormulas → Show formulas

Step by step

1. Click Show formulas.
2. Read the expressions in formula cells.
3. Widen a column if needed.
4. Click Show formulas again to return to results.

Keep learning

Recalculate the workbook

Recreate the calculation evaluator and refresh displayed results.

WHERE TO FIND ITFormulas → Calculate now

Step by step

1. Finish any active cell edit.
2. Choose Calculate now.
3. Inspect dependent totals and errors.
4. Check the formula itself if a result remains unexpected.

Keyboard F9

Keep learning

Understand a formula error

Start with a small expression and check its inputs before adding complexity.

WHERE TO FIND ITThe formula result; formula bar

Step by step

1. Select the error cell and read its formula.
2. Check spelling of function and sheet names.
3. Verify the source cells contain the expected numeric/text values.
4. Test the expression on a small range and correct it.

Try it

=IFERROR(E2/C2,0)

Keep learning

Find a value or formula

Find searches stored cell contents in the active worksheet.

WHERE TO FIND ITHome → Editing → Find; Search → Find cell

Step by step

1. Open Find.
2. Enter a search term.
3. Apply.
4. The first matching cell is selected.

Keyboard Ctrl/Cmd+F

Options in this control

Keep learning

Replace text throughout the active sheet

Replace All changes matching text in every stored string in the current worksheet.

WHERE TO FIND ITSearch → Replace text in active sheet

Step by step

1. Save a copy if the change is broad.
2. Open Replace.
3. Enter the exact Find text and replacement.
4. Apply and inspect several changed cells.
5. Use Undo to reverse the operation.

Keyboard Ctrl/Cmd+H

Options in this control

Keep learning

Sort ascending

Reorder selected rows by the first column of the selection.

WHERE TO FIND ITData → Sort ascending; Home → Editing for ascending

Step by step

1. Select the complete values-only block that must stay together, excluding its header.
2. Choose Sort ascending.
3. Check the first column is in ascending order.
4. Use Undo if the selection did not include all related columns.

Try it

Select A2:F6 only after replacing formulas with values in a copy, or try a separate values-only list.

Keep learning

Sort descending

Reorder selected rows by the first column of the selection.

WHERE TO FIND ITData → Sort descending; Home → Editing for ascending

Step by step

1. Select the complete values-only block that must stay together, excluding its header.
2. Choose Sort descending.
3. Check the first column is in descending order.
4. Use Undo if the selection did not include all related columns.

Try it

Select A2:F6 only after replacing formulas with values in a copy, or try a separate values-only list.

Keep learning

Filter rows using header checkboxes

Keep matching rows visible without deleting the others.

WHERE TO FIND ITData → Filter; Home → Editing → Filter

Step by step

1. Make sure row 1 of the used range contains headers.
2. Choose Filter.
3. Click a filter arrow in the header row.
4. Search values and tick the ones to keep, then Apply.
5. Click Filter again to remove these header filters.

Keyboard Ctrl/Cmd+Shift+L

Keep learning

Select blanks, formulas or other cell types

Find matching cell types within a selected range.

WHERE TO FIND ITHome → Cells → Go to special

Step by step

1. Select a range of at most 10,000 cells.
2. Open Cells → Go to special.
3. Choose Blanks, Formulas, Constants, Errors or Visible cells.
4. Apply and inspect the resulting multi-selection.

Options in this control

Keep learning

Split text into separate columns

Split literal text at a chosen delimiter.

WHERE TO FIND ITData → Text to columns

Step by step

1. Select a single source column.
2. Keep enough cells to the right empty.
3. Open Text to columns and enter the delimiter.
4. Apply and inspect the new columns.

Try it

A2: North,Notebook,12
Delimiter: ,

Options in this control

Keep learning

Remove duplicate rows

Keep one copy of each distinct row inside the chosen range.

WHERE TO FIND ITData → Remove duplicates

Step by step

1. Select the data rows, excluding the header.
2. Open Remove duplicates and check the range.
3. Apply.
4. Read the count and inspect the compacted results.

Options in this control

Keep learning

Group and collapse rows or columns

Hide a selected section as a simple outline group.

WHERE TO FIND ITData → Group

Step by step

1. Select the rows or columns to group.
2. Choose Group.
3. Choose Rows or Columns and Collapsed or Expanded.
4. Apply.

Options in this control

Keep learning

Ungroup and expand a section

Remove simple groups overlapping the selection.

WHERE TO FIND ITData → Ungroup

Step by step

1. Select cells spanning the grouped area.
2. Choose Ungroup.
3. Inspect the expanded rows or columns.
4. Use Undo if needed.

Keep learning

Import a public CSV or JSON URL

Fetch a public data snapshot into empty worksheet cells.

WHERE TO FIND ITData → From web

Step by step

1. Select an empty destination.
2. Open From web.
3. Enter a direct public HTTPS CSV/JSON URL and choose its format.
4. Check the destination cell.
5. Choose Fetch and import, then inspect the results.

Try it

Use a company-approved public CSV URL, not a webpage containing a download button.

Options in this control

Keep learning

Refresh or remove a web connection

Reuse a source URL imported with From web.

WHERE TO FIND ITData → Connections

Step by step

1. Create a connection with From web first.
2. Select an empty destination area.
3. Open Connections and choose the source.
4. Choose Refresh into empty selection or Remove.
5. Apply and compare the snapshot.

Keep learning

Create a pivot summary

Summarize one value column by one grouping column on a new worksheet.

WHERE TO FIND ITInsert → Pivot summary

Step by step

1. Select the complete source range including headers.
2. Open Pivot summary.
3. Check the range, choose the grouping column and value column.
4. Choose Sum, Count, Average, Minimum or Maximum.
5. Apply and inspect the new Pivot worksheet.

Try it

Group Team; Values Total; Summarize by Sum.

Options in this control

Keep learning

Refresh a generated summary

Rebuild a QuantShell pivot summary after editing its source.

WHERE TO FIND ITData → Refresh summary

Step by step

1. Change source data and finish the edit.
2. Switch to the generated Pivot sheet.
3. Choose Refresh summary.
4. Compare the updated totals.

Keep learning

Find an input with Goal Seek

Change one numeric input to seek a target formula result.

WHERE TO FIND ITData → What-if analysis

Step by step

1. Set up an input and a formula depending on it.
2. Select the formula cell and open What-if analysis.
3. Enter the formula cell, desired result and changing cell.
4. Apply, then check whether the resulting value makes sense.
5. Use Undo to restore the input.

Try it

H2: 10
I2: =H2*2
Formula cell I2; target 100; changing cell H2 → about 50.

Options in this control

Keep learning

Make a simple linear forecast

Project a numeric series forward using a linear trend.

WHERE TO FIND ITData → Forecast sheet

Step by step

1. Select one numeric column without its header.
2. Open Forecast sheet and check the range.
3. Enter 1–1000 future periods.
4. Apply to create a new Forecast sheet.

Try it

H2:H4: 10, 20, 30
Forecast periods: 2 → 40, 50.

Options in this control

Keep learning

Insert a picture

Place a local image over the worksheet.

WHERE TO FIND ITInsert → Pictures

Step by step

1. Select an anchor cell.
2. Choose Pictures.
3. Select a supported image in the file picker.
4. Drag the inserted picture to move it.
5. Double-click it to resize or delete through the object dialog.

Keep learning

Insert a basic shape

Add a rectangle, ellipse, triangle, arrow or line.

WHERE TO FIND ITInsert → Shapes

Step by step

1. Select an anchor cell.
2. Open Shapes.
3. Choose the shape and a six-digit hex color.
4. Apply, then drag the shape to position it.

Try it

Arrow; #21764c

Options in this control

Keep learning

Insert a simple icon

Choose a small symbol rendered as a floating picture.

WHERE TO FIND ITInsert → Icons

Step by step

1. Select an anchor cell.
2. Open Icons.
3. Choose the symbol and Apply.
4. Drag or double-click the icon to arrange it.

Options in this control

Keep learning

Move, resize or delete an object

Object selection is different from cell selection. Click the object before using Delete.

WHERE TO FIND ITClick the picture, shape, icon or chart itself

Step by step

1. Click the object so its selection outline appears.
2. Drag it to a new location.
3. For a picture/shape/icon, double-click for Resize or Delete and an anchor cell.
4. To remove the selected object, press Delete or Backspace.
5. Use Undo to restore it.

Keyboard Delete removes selected object; Ctrl/Cmd+Z restores it

Keep learning

Create a column chart

Visualize a rectangular source range with a first-row header and first-column labels.

WHERE TO FIND ITInsert → Charts → Column

Step by step

1. Prepare a label column and numeric value columns with headers.
2. Select the source rectangle.
3. Choose Column and check the source range.
4. Enter a chart title and Apply.
5. Drag the chart to position it; select it and press Delete to remove it.

Try it

Use A1:B4 with Product / Sales headers and three numeric sales rows.

Options in this control

Keep learning

Create a line chart

Visualize a rectangular source range with a first-row header and first-column labels.

WHERE TO FIND ITInsert → Charts → Line

Step by step

1. Prepare a label column and numeric value columns with headers.
2. Select the source rectangle.
3. Choose Line and check the source range.
4. Enter a chart title and Apply.
5. Drag the chart to position it; select it and press Delete to remove it.

Try it

Use A1:B4 with Product / Sales headers and three numeric sales rows.

Options in this control

Keep learning

Create a pie chart

Visualize a rectangular source range with a first-row header and first-column labels.

WHERE TO FIND ITInsert → Charts → Pie

Step by step

1. Prepare a label column and numeric value columns with headers.
2. Select the source rectangle.
3. Choose Pie and check the source range.
4. Enter a chart title and Apply.
5. Drag the chart to position it; select it and press Delete to remove it.

Try it

Use A1:B4 with Product / Sales headers and three numeric sales rows.

Options in this control

Keep learning

Show a trend inside a cell

A line sparkline draws a compact trend from numeric source cells.

WHERE TO FIND ITInsert → Sparklines → Line

Step by step

1. Open Line sparkline.
2. Enter a numeric source range.
3. Enter a destination cell and Apply.
4. Widen the destination column if needed.

Try it

Source C2:C6; Destination H2

Options in this control

Keep learning

Remove every chart on the current sheet

Use this when you want to remove all chart previews from one worksheet.

WHERE TO FIND ITSearch → Remove charts from current sheet

Step by step

1. Switch to the intended worksheet.
2. Search for Remove charts.
3. Run Remove charts from current sheet.
4. Use Undo if any chart should be kept.

Keep learning

Filter one category with Slicer

Use a compact category picker for the first selected column.

WHERE TO FIND ITInsert → Slicer

Step by step

1. Select the source data including its header.
2. Make the leftmost selected column the category you want.
3. Choose Slicer and pick the category.
4. Apply. Reopen and choose All to clear it.

Try it

Select A1:F6 → Slicer → North.

Options in this control

Keep learning

Filter a date interval

Choose a start and end date for one date column within a source range.

WHERE TO FIND ITInsert → Timeline

Step by step

1. Open Timeline.
2. Enter the full source range including its header and the date column letter.
3. Enter From and To as YYYY-MM-DD.
4. Choose Apply, then confirm.
5. Reopen with Action Clear to remove it.

Try it

Range A1:F6; Date column F; From 2026-11-02; To 2026-11-04.

Options in this control

Keep learning

Insert a calculating expression

Equation inserts a spreadsheet formula into the active cell.

WHERE TO FIND ITInsert → Equation

Step by step

1. Select the destination cell.
2. Open Equation.
3. Enter the expression.
4. Apply and inspect its calculated result.

Try it

=SUM(E2:E6)

Options in this control

Keep learning

Add a symbol to a cell

Append a symbol to the current cell’s stored text.

WHERE TO FIND ITInsert → Symbol

Step by step

1. Select a text cell.
2. Open Symbol.
3. Choose a symbol.
4. Apply and inspect the cell.

Try it

₹, €, £, ©, ®, ™, °, ±, ×, ÷, π, Ω, ∞, ≤, ≥, ✓

Options in this control

Keep learning

Draw with the pen

Use the worksheet drawing layer for simple freehand marks.

WHERE TO FIND ITDraw → Pen

Step by step

1. Open Draw.
2. Choose Pen.
3. Click and drag over the worksheet, then release.
4. Use Undo for an unwanted mark.

Keyboard Escape returns to Select

Keep learning

Highlight with ink

Use the worksheet drawing layer for simple freehand marks.

WHERE TO FIND ITDraw → Highlighter

Step by step

1. Open Draw.
2. Choose Highlighter.
3. Click and drag over the worksheet, then release.
4. Use Undo for an unwanted mark.

Keyboard Escape returns to Select

Keep learning

Erase a stroke

Use the worksheet drawing layer for simple freehand marks.

WHERE TO FIND ITDraw → Eraser

Step by step

1. Open Draw.
2. Choose Eraser.
3. Click near a stroke to remove that whole stroke.
4. Use Undo for an unwanted mark.

Keyboard Escape returns to Select

Keep learning

Return to cell selection

Leave drawing mode before selecting or editing cells.

WHERE TO FIND ITDraw → Select

Step by step

1. Open Draw.
2. Choose Select.
3. Click a cell to continue editing.
4. Use Home or another tab for cell commands.

Keyboard Escape returns to Select

Keep learning

Choose page orientation, size and range

These three ribbon buttons open the same Page setup dialog.

WHERE TO FIND ITPage Layout → Page setup / Orientation / Size

Step by step

1. Choose Page setup.
2. Select portrait or landscape.
3. Choose A4, Letter or Legal.
4. Check the print range and Apply.
5. Use View → Page layout to inspect the printable table.

Try it

Landscape; A4; Print range A1:F6

Options in this control

Keep learning

Print only a selected area

Store the current selection as the worksheet’s print area.

WHERE TO FIND ITPage Layout → Print area

Step by step

1. Select the rectangle to include.
2. Choose Print area.
3. Open Page setup to check the range.
4. Preview or export a PDF.

Keep learning

Repeat title rows when printing

Repeat initial worksheet rows as table headers in printed output.

WHERE TO FIND ITPage Layout → Print titles

Step by step

1. Open Print titles.
2. Enter 1:1 for the first row or 1:2 for the first two.
3. Apply and preview.
4. Use a blank field to clear repeated titles.

Options in this control

Keep learning

Set the print scale

Adjust the printed table’s scale without changing screen zoom.

WHERE TO FIND ITPage Layout → Scale

Step by step

1. Open Scale.
2. Enter a percentage from 25 to 200.
3. Apply.
4. Preview the report and inspect readability and page count.

Try it

75 percent for a slightly smaller printed table.

Options in this control

Keep learning

Apply a color preset to selected cells

Choose a simple Green, Blue or Violet preset for the selection.

WHERE TO FIND ITPage Layout → Themes

Step by step

1. Select the cells to style.
2. Open Themes.
3. Choose the preset and Apply.
4. Inspect its background, white text and bold effect.

Options in this control

Keep learning

Change the worksheet background color

Set the background visible behind otherwise blank/default cells.

WHERE TO FIND ITPage Layout → Colors

Step by step

1. Open Colors.
2. Enter a six-digit hex value.
3. Apply.
4. Check that your data remains readable.

Try it

A gentle background: #fafafa

Options in this control

Keep learning

Set the default worksheet font

Choose a default family for cells without an explicit font setting.

WHERE TO FIND ITPage Layout → Fonts

Step by step

1. Open Fonts.
2. Choose Arial, Calibri, Aptos, Georgia, Times New Roman or Consolas.
3. Apply.
4. Use Home → Font for an individual selection’s font.

Options in this control

Keep learning

Add or remove a worksheet background image

Place a local image behind blank cells for a visual worksheet background.

WHERE TO FIND ITPage Layout → Background

Step by step

1. Open Background.
2. Choose Choose image, then select a supported image.
3. Inspect the blank area of the sheet.
4. Reopen Background and choose Remove to clear it.

Options in this control

Keep learning

Export a worksheet PDF

Create a viewing copy of the current worksheet.

WHERE TO FIND ITFile → PDF

Step by step

1. Check Page setup, print area, titles and scale.
2. Choose File → PDF.
3. Choose a filename and save.
4. Open the PDF and inspect the pages before sharing.

Keep learning

Print the current worksheet

Send the worksheet’s printable rendering to your system print dialog.

WHERE TO FIND ITFile → Print; native File → Print

Step by step

1. Check the print area.
2. Choose Print.
3. Review the system preview, printer and page choices.
4. Print only after confirming the layout.

Keyboard Ctrl/Cmd+P

Keep learning

Return to the editable grid

Leave the printable layout preview and return to normal worksheet editing.

WHERE TO FIND ITView → Normal

Step by step

1. Choose View → Normal.
2. Check that the grid is visible.
3. Click a cell to edit.
4. Use the other view controls when needed.

Keep learning

See approximate page boundaries

Show blue guides as a rough indication of page boundaries.

WHERE TO FIND ITView → Page break preview

Step by step

1. Choose Page break preview.
2. Inspect the blue guide lines.
3. Use Page layout or PDF to inspect the actual output.
4. Choose Normal to remove the guides.

Keep learning

Inspect the printable worksheet

Open a read-only printable table rendering within the application.

WHERE TO FIND ITView → Page layout

Step by step

1. Set the page and print area first.
2. Choose Page layout.
3. Scroll the preview and inspect headers/content.
4. Choose Normal before editing cells again.

Keep learning

Open a separate worksheet snapshot

Open a read-only rendering of the worksheet in another window.

WHERE TO FIND ITView → New window

Step by step

1. Select the worksheet.
2. Choose New window.
3. Inspect the snapshot beside the original.
4. Close the snapshot when finished.

Keep learning

Show a second worksheet view

Add a read-only second table view beside or below the working grid.

WHERE TO FIND ITView → Split

Step by step

1. Choose Split.
2. Use the extra table to compare the visible data.
3. Continue editing in the main grid.
4. Choose Split again to close it.

Keep learning

Keep headers visible while scrolling

Choose what stays visible at the top or left of the grid.

WHERE TO FIND ITView → Freeze panes

Step by step

1. For one header row, choose Freeze top row.
2. For the first column, choose Freeze first column.
3. For a custom boundary, select the first cell below/right of what should stay visible and choose Freeze above and left of active cell.
4. Choose Unfreeze all to clear it.

Try it

Select B2 → Freeze above and left keeps row 1 and column A.

Options in this control

Keep learning

Show or hide gridlines

Toggle this part of the worksheet interface.

WHERE TO FIND ITView → Gridlines; Page Layout → Gridlines

Step by step

1. Choose the control.
2. Inspect the changed view.
3. Choose it again to restore the previous display.
4. Continue editing normally.

Keep learning

Show or hide row/column headings

Toggle this part of the worksheet interface.

WHERE TO FIND ITView → Headings; Page Layout → Headings

Step by step

1. Choose the control.
2. Inspect the changed view.
3. Choose it again to restore the previous display.
4. Continue editing normally.

Keep learning

Show or hide the formula bar

Toggle this part of the worksheet interface.

WHERE TO FIND ITView → Formula bar

Step by step

1. Choose the control.
2. Inspect the changed view.
3. Choose it again to restore the previous display.
4. Continue editing normally.

Keep learning

Switch light and dark interface modes

Choose a lighter or darker working interface.

WHERE TO FIND ITView → Switch modes

Step by step

1. Choose Switch modes.
2. Inspect ribbon and worksheet visibility.
3. Choose it again to switch back.
4. Use worksheet fills for report styling, not this control.

Keep learning

Adjust screen zoom

Use screen zoom to read the worksheet comfortably.

WHERE TO FIND ITBottom-right − / +; View → 100%

Step by step

1. Click + or − in the status bar to change zoom by ten points.
2. Stay within the supported 50–150 percent range.
3. Choose View → 100% to reset.
4. Use print scale separately for output.

Keep learning

Make more room for the grid

Hide the ribbon’s command groups while keeping the tabs available.

WHERE TO FIND ITView → Collapse ribbon

Step by step

1. Choose Collapse ribbon.
2. Use the extra grid space.
3. Click a ribbon tab to show its controls again.
4. Choose the control again if needed.

Keep learning

Check a selection’s totals

Read quick aggregate information without inserting formulas.

WHERE TO FIND ITStatus bar at the bottom; right-click calculations

Step by step

1. Select cells with numeric data.
2. Read Average, Count and Sum in the status bar.
3. Right-click the calculation area.
4. Tick average, count, sum, min or max and Apply.

Keep learning

Check spelling in selected cells

Ask the system dictionary for words and suggestions in the selection.

WHERE TO FIND ITReview → Spelling

Step by step

1. Select the text range to check.
2. Choose Spelling.
3. Read the reported words and suggestions.
4. Close the result and edit the original cells manually.

Keyboard F7

Keep learning

Look up a simple synonym

Search a small built-in English synonym list.

WHERE TO FIND ITReview → Thesaurus

Step by step

1. Select a cell containing the word, or open Thesaurus and type it.
2. Apply.
3. Read the available synonyms.
4. Edit the cell manually if a suggestion fits.

Try it

Try good, fast, clear, help or increase.

Options in this control

Keep learning

Read worksheet statistics

See a short count of stored cells, formulas and workbook sheets.

WHERE TO FIND ITReview → Workbook statistics

Step by step

1. Switch to the worksheet of interest.
2. Open Workbook statistics.
3. Read the populated-cell and formula counts and worksheet total.
4. Close the dialog.

Keep learning

Run the available accessibility checks

Look for a small set of worksheet organization issues.

WHERE TO FIND ITReview → Check accessibility

Step by step

1. Choose Check accessibility.
2. Read the reported image-description, table and merge suggestions.
3. Close the report.
4. Improve descriptive headers and avoid unnecessary merges.

Keep learning

Translate through your chosen provider

Send a selected text cell to a provider endpoint you supply, then write the result into an empty cell.

WHERE TO FIND ITReview → Translate

Step by step

1. Select a text cell, not a formula.
2. Open Translate.
3. Enter a public HTTPS LibreTranslate-compatible /translate endpoint and target language code.
4. Enter an API key only if your provider requires it and choose an empty destination.
5. Choose Send and translate, then inspect the result.

Try it

Target language codes: hi, fr, de

Options in this control

Keep learning

Add or edit a cell note

Attach a plain text note to the active cell.

WHERE TO FIND ITReview → Cell note

Step by step

1. Select the cell.
2. Choose Cell note.
3. Enter the note in the text area.
4. Apply; hover over the marked cell to inspect it.

Try it

Check this price with the purchasing team.

Options in this control

Keep learning

Read all notes in the worksheet

Use the sidebar to review notes with their cell addresses.

WHERE TO FIND ITReview → Show notes

Step by step

1. Switch to the worksheet.
2. Choose Show notes.
3. Read the listed cell addresses and text.
4. Choose Show notes again to hide the sidebar.

Keep learning

Add and follow a hyperlink

Store a display label and an HTTPS destination in one cell.

WHERE TO FIND ITInsert → Link

Step by step

1. Select the cell and choose Link.
2. Enter display text and a complete https:// URL.
3. Apply.
4. Hold Ctrl/Cmd and click the linked cell to open it.

Keyboard Ctrl/Cmd+K opens Link; Ctrl/Cmd+click follows it

Try it

Display text: Company help
URL: https://example.com

Keep learning

Lock or unlock worksheet editing

Use a simple guard to avoid accidental edits.

WHERE TO FIND ITReview → Lock / unlock sheet

Step by step

1. Switch to the worksheet.
2. Choose Lock / unlock sheet.
3. Try a small edit to confirm the guard.
4. Use the same control to unlock before editing.

Keep learning

Guard the workbook’s sheet structure

Prevent ordinary add/delete/rename worksheet operations until the guard is toggled off.

WHERE TO FIND ITReview → Protect workbook

Step by step

1. Choose Protect workbook.
2. Try adding a sheet to confirm structure changes are blocked.
3. Choose Protect workbook again to unlock.
4. Make the intended structural change.

Keep learning

Create a small QuantShell script

Save a named sequence in QuantShell’s original declarative action format.

WHERE TO FIND ITAutomate → New script

Step by step

1. Open New script.
2. Enter a name.
3. Enter a JSON array of supported actions.
4. Apply to validate and save the script definition.
5. Use View scripts → Run to execute it.

Try it

[{"action":"setCell","cell":"H1","value":"Review"},{"action":"setCell","cell":"H2","value":42}]

Options in this control

Keep learning

View, run or delete a saved script

Choose an existing script and an action.

WHERE TO FIND ITAutomate → View scripts

Step by step

1. Create and save a script first.
2. Open View scripts.
3. Choose the name and Run, View or Delete.
4. Apply.
5. If you ran it, inspect the changed cells and use Undo if necessary.

Keep learning

Run a simple automation template

Fill the selection down or clear it in one undoable operation.

WHERE TO FIND ITAutomate → Automation templates

Step by step

1. Select the source/destination range.
2. Open Automation templates.
3. Choose Fill selection down or Clear selection.
4. Apply and inspect the result.
5. Use Undo if needed.

Options in this control

Keep learning

Find the Cells menu actions

The Cells menu collects structural, formatting and worksheet operations.

WHERE TO FIND ITHome → Cells

Step by step

1. Open Home → Cells.
2. Choose an action from the dropdown.
3. Apply to run it or open its next dialog.
4. Read the matching guide lesson before a destructive structural change.

Options in this control

Keep learning

Open shortcut help

Use the in-app summary as a quick reminder.

WHERE TO FIND ITHelp → Help & shortcuts

Step by step

1. Open Help.
2. Choose Help & shortcuts.
3. Read the shared shortcuts.
4. Use this full guide for the release-specific detail.

Keyboard F1

Keep learning

Open this guide from QuantShell

The full guide is bundled so you can read it without a network connection.

WHERE TO FIND ITHelp → User guide

Step by step

1. Choose Help → User guide.
2. Your browser opens the local guide.
3. Use Search or the topic index.
4. Return to QuantShell to try the steps.

Keep learning

Check the scope of this release

Read the release’s capabilities and key compatibility boundaries.

WHERE TO FIND ITHelp → Feature availability; File → Feature availability

Step by step

1. Open Feature availability.
2. Check whether the workflow you need is included.
3. Use the relevant guide lesson for exact steps and limits.
4. Keep native originals when using another file format.

Keep learning

Read version and library information

See the product release and the third-party libraries used by the app.

WHERE TO FIND ITHelp → About QuantShell

Step by step

1. Open About QuantShell.
2. Check the version before reporting a problem.
3. Read the library disclosure.
4. Include the version and operating system with a bug report.

Keep learning

Know the workbook limits

Use this release for bounded worksheets and check exchange copies before relying on them.

WHERE TO FIND ITQuantShell 1.0.0

Step by step

1. Keep large source files unchanged.
2. Try a smaller representative workbook first.
3. Save native .qsheet copies.
4. Check important calculations and exported files manually.

Keep learning

When something does not work as expected

Most problems become easier to understand when you check the selected target and the tool’s prerequisites.

WHERE TO FIND ITStart with the symptom

Step by step

1. If a chart will not delete, click the chart itself, then Delete; a selected cell is a different target.
2. If a column will not move, try its right-click Move column action and check the destination number and referenced ranges.
3. If cells are not editable, leave drawing/print preview mode and unlock sheet protection.
4. If a filter hides too much, clear header filters and the slicer/timeline filter separately.
5. If a formula errors, inspect the stored formula and source value types.
6. Use Undo while the action is still in history; reopen your saved copy if necessary.

Try it

Problem: one click selects but does not open a link.
Solution: Ctrl/Cmd+click the linked cell.

Keep learning

Download from the company repository

Use the release assets for installers; the repository’s Code ZIP is not an installer.

WHERE TO FIND ITQuantOffice repository → Releases → QuantShell 1.0.0

Step by step

1. Sign in with a GitHub account that has access to the private company repository.
2. Open the specific QuantShell release link supplied by your team.
3. Expand Assets.
4. Download the ARM64 DMG for Apple Silicon Mac or x64 Setup EXE for Windows.
5. Download the documentation ZIP for offline help if needed.

Keep learning

Check for application updates

Check for a newer version inside the application. Downloads and installation are separate actions, so you can save your work before restarting.

WHERE TO FIND ITHelp → Check for updates

Step by step

1. Open Help → Check for updates.
2. For private GitHub releases, expand Private repository access and save your own read-only access token.
3. Click Check for updates.
4. If a newer stable version exists, click Download update.
5. When downloading finishes, choose Restart and install, save your native document when prompted, and confirm the restart.

Keep learning