Editing & Data Entry
Master cell editing and data entry in Probably’s spreadsheet. Learn how to work efficiently with different data types and use advanced input features.
Cell Editing and Data Entry
Section titled “Cell Editing and Data Entry”Direct Cell Editing
Section titled “Direct Cell Editing”- Click any cell to edit values inline
- Tab navigation moves between cells
- Enter key confirms changes and moves down
- Escape key cancels edits
Data Type Awareness
Section titled “Data Type Awareness”- Text fields: Full text editing with validation
- Numbers: Numeric input with format preservation
- Dates: Date picker for temporal data
- Categories: Dropdown selection for discrete values
Text Editing
Multi-line text support with smart text wrapping
Numeric Input
Automatic number formatting and validation
Date Selection
Interactive date picker with format detection
Text Data Entry
Section titled “Text Data Entry”Multi-line Text Support
Section titled “Multi-line Text Support”- Line breaks preserved within cells
- Smart text wrapping for readability
- Full text search across all content
- Rich formatting options for display
Text Validation
Section titled “Text Validation”- Length limits automatically enforced
- Character encoding handled automatically
- Special characters fully supported
- Unicode compatibility for international text
Numeric Data Entry
Section titled “Numeric Data Entry”Number Formatting
Section titled “Number Formatting”- Automatic detection of numeric patterns
- Decimal precision preserved from input
- Scientific notation supported for large/small numbers
- Currency formatting with locale awareness
Validation Features
Section titled “Validation Features”- Range checking for reasonable values
- Data type enforcement prevents invalid entries
- Error highlighting for problematic values
- Automatic correction suggestions for common mistakes
Date and Time Entry
Section titled “Date and Time Entry”Date Input Methods
Section titled “Date Input Methods”- Manual typing with intelligent parsing
- Date picker interface for visual selection
- Multiple formats automatically recognized
- Relative dates like “yesterday” or “next month”
Time Handling
Section titled “Time Handling”- Time zones automatically managed
- Precision levels from seconds to years
- Date arithmetic for calculations
- Format preservation from original data
Categorical Data
Section titled “Categorical Data”Dropdown Selection
Section titled “Dropdown Selection”- Value lists automatically generated from existing data
- Type-ahead search for quick selection
- Custom values can be added on the fly
- Consistency checking prevents typos
Data Integrity
Section titled “Data Integrity”- Validation rules enforce data consistency
- Standardization of variant spellings
- Case sensitivity options
- Null value handling with clear indicators
Bulk Editing Operations
Section titled “Bulk Editing Operations”Copy and Paste
Section titled “Copy and Paste”- Range selection for multiple cells
- Format preservation during copy operations
- External clipboard integration with other applications
- Undo/redo support for all paste operations
Fill Operations
Section titled “Fill Operations”- Auto-fill patterns for sequences
- Copy down/across for repeated values
- Formula filling with relative references
- Smart suggestions based on existing patterns
Data Validation
Section titled “Data Validation”Real-time Checking
Section titled “Real-time Checking”- Immediate feedback on invalid entries
- Visual indicators for data quality issues
- Suggested corrections for common problems
- Batch validation for imported data
Quality Controls
Section titled “Quality Controls”- Duplicate detection across columns
- Range validation for numeric fields
- Format checking for dates and other structured data
- Completeness indicators for required fields
What’s Next?
Section titled “What’s Next?”Learn Filtering & Sorting
Discover powerful data filtering and sorting capabilities for data exploration.
Advanced Transformations
Learn how to use PXL expressions for powerful data transformations.