How to remove columns from a spreadsheet
Here are some results from the 2012 London Marathon. Lets say we are just interested in the first few columns; that means we want to remove all other columns from Beyond Compare.
(Don't worry -- your original table will be unaltered: Beyond Compare works with a read-only copy extracted from your spreadsheet file.)
In Excel: the original spreadsheet
First, a wider view may make things easier to see. Menu: View->OverUnder Now eliminate the unwanted columns. Menu: Session->SessionSetting->Columns The view is twisted: each row here in the screenshot below, describes a column(!) in the table. (It's only disorienting the first time you do this.) Select the unwanted rows. Rightclick and remove them.
In Beyond Compare: Removing the unwanted columns.
In Beyond Compare: the final result, with the unwanted columns removed
Copy link