With an item in a column selected in a dataview, you can highlight the entire column by pressing Ctrl+Space on your keyboard.
Maptitude Learning Portal articles tagged with Dataview
You can clear cells by right-clicking on a highlighted range of cells and choosing Clear.
If you want to create a new blank field to fill with data, modify the underlying table using Dataview>Table>Modify. Then, click Add Field and set up the field as you need.
You can use the copy shortcut (Ctrl+C) to copy cell values and the paste shortcut (Ctrl-V) to edit cell values with data that has been copied. You can paste these cell values into another dataview or into Microsoft Excel.
If a field name contains spaces or other special characters or starts with a digit, you must put square brackets around it. For example a field called “Age <5" will need to be "[Age <5]" in your formula. Fields that require brackets will automatically display with them in the Formula Builder Field List.
You can export demographic overlay data and other information to Excel by choosing the layer to export, making it the working layer, and clicking the Export to Excel button on the Standard toolbar.