cutting and pasting columns in excel
Options
Jonathan_161201
Posts: 2
in Questions
what would be the appropriate catalytic action for cutting and pasting columns in different areas? example cutting column A and inserting in Column C.
0
Answers
-
There are a few actions that might be helpful:
Excel: Apply Filters - This would be helpful to work primarily with Excel.
Tables: Apply formulas to columns - This would require you to first convert the Excel to a Table using Excel: Save Spreadsheet to Table.
CSV: Apply formulas to columns - This would require you to first convert the Excel to a CSV using Excel: Convert to CSV. The advantage of this over a Table is that it is limited to 1 GB (vs. 100K rows) and not encrypted so more performant for processing larger data sets.
0