Basic Features

SheetRocks supports familiar spreadsheet operations for data entry, formatting, and calculations.

Data Entry & Editing

  • Enter basic values: Values are interpreted as their appropriate types, for example 10/24/2025 as a date and 97% as percent.
  • Enter formulas: Write powerful formulas with support for all standard spreadsheet operators and 150+ functions.
  • Copy, paste and cut: Copy (Ctrl+C), cut (Ctrl+X) and paste (Ctrl+V) cell ranges. For pasting values only use (Ctrl + Shift + V). You can also paste values in from Excel or Google Sheets.
  • Autofill a range: Hold and drag the little square on the bottom right of a selection to autofill the selection into the new range. Double clicking the autofill square autofills to the end of the sheet.

Cell Formatting

  • Cell formatting: Apply bold, italic, underline, and strikethrough formatting to cells.
  • Text & Background Colors: Change text and background colors. Colors have been optimized for high contrast.
  • Number formats: Set number formats: currency, percent, date, time, text, scientific, fraction, and more.
  • Text positioning: Adjust the text justification (left, center, or right), vertical alignment (top, middle, bottom) and word wrap settings.
  • Borders & Merged Cells: Organized and highlight cells in your sheet with borders and merged cells.

Keyboard Shortcuts

SheetRocks supports familiar spreadsheet keyboard shortcuts. On Mac, use Cmd instead of Ctrl.

Navigation + Selection

  • Arrow Keys: Move to adjacent cell.
  • Shift + Arrow Keys: Extend selection.
  • Enter: Save cell data and move down to the next cell.
  • Tab: Save cell data and move right to the next cell.
  • Escape: Clear clipboard.

Editing

  • Ctrl+C: Copy selected cells.
  • Ctrl+X: Cut selected cells.
  • Ctrl+V: Paste.
  • Ctrl+Shift+V: Paste values only (no formulas).
  • Delete or Backspace: Clear selected cells.
  • Ctrl+Z: Undo.
  • Ctrl+Y or Ctrl+Shift+Z: Redo.
  • Ctrl+F: Open Find/Replace.
  • F3 or Ctrl+G: Find next (when Find/Replace is open).
  • Shift+F3 or Shift+Ctrl+G: Find previous (when Find/Replace is open).

Formatting

  • Ctrl+B: Toggle bold.
  • Ctrl+I: Toggle italic.
  • Ctrl+U: Toggle underline.
  • Ctrl+S: Toggle strikethrough.

Other Shortcuts

  • Ctrl+` (backtick): Toggle Formula View Mode. Shows formulas in cells instead of calculated values. When enabled, copy operations also copy formula text. Press again to return to normal view.
  • F2 or Ctrl+E: Toggle edit mode lock. Prevents range selection in formulas, useful when editing formula text directly.