Useful EXCEL shortcuts and functions for digital history
- Selecting all cells in Excel range:
- select uppermost cell
- hold won CRTL + SHIFT + DOWN ARROW
- Select several rows and columns by cell name:
- click cell in upper left corner
- click name box in task bar and type name of lower right corner
- press SHIFT + ENTER
-
Replace all empty cells with value x:
-
Replace sub-string in cell with string from another cell:
-
Select n characters from cells:
-
Add value if cell in same row contains x:
-
Geocoding in EXCEL:
-
Difference between "wechseln" und "ersetzen":