Posts Tagged ‘Subtotals’

Copy Visible Excel Worksheet Data

Saturday, August 8th, 2009

See how to Copy or Export only visible Excel worksheet data retaining all formulas, subtotals and worksheet formatting and deleting all hidden rows and hidden columns.

Duration : 0:6:34

(more…)

Split Excel Worksheet to New Workbooks

Friday, July 3rd, 2009

Create multiple identically formatted Excel worksheets by automatically splitting the data in one Excel worksheet by all values or only selected values in any one column. Easily exclude data in hidden columns and hidden rows. Create new split worksheets in one workbook or in multiple workbooks.

Duration : 0:3:11

(more…)