Software & documents
Choosing CSV or a spreadsheet workbook
Data exchange and an editable calculation require different file features.
The knowledge library
Search for a task, a term, or a question.
Software & documents
Importing CSV without damaging dates or identifiers
Correct column boundaries are only the beginning; data types also need to match the source.
Software & documents
Keeping leading zeros in a spreadsheet
An identifier such as 00417 is often text even though it contains only digits.
Software & documents
Sorting a spreadsheet without separating rows
Sorting must move the whole record, not just the selected name column.
Software & documents
Removing spreadsheet duplicates with a clear rule
Two matching names are not automatically the same record. Define the comparison key first.
Software & documents
Using validation lists for consistent entries
A short list of allowed values prevents many spelling variations, but it needs clear maintenance.
Software & documents
Understanding relative and absolute cell references
You can control whether a copied formula follows its new position or keeps pointing to the same cell.
Software & documents
Checking a spreadsheet before sharing
Review dependencies and included content as well as the visible results.
Software & documents
Separating input data from calculations
An understandable workbook shows which values may change and how they produce results.
No matching articles. Try another term or select all topics.