# Range operations

Ranges can be copied, inserted, deleted, filled and sorted. EPPlus adjusts formulas and other references in the workbook that are affected by the change.

- [Copying ranges/sheets](<https://epplussoftware.com/docs/worksheet-and-ranges/range-operations/copy-ranges-or-entire-worksheets/index.md>) - Copy ranges, values without formulas, styles or entire worksheets, within a workbook or to another workbook.
- [Insert/Delete](<https://epplussoftware.com/docs/worksheet-and-ranges/range-operations/insert-and-delete-rows-columns-and-ranges/index.md>) - Insert and delete rows, columns and ranges, with formulas, tables, pivot tables, conditional formatting and drawings adjusted.
- [Filling ranges](<https://epplussoftware.com/docs/worksheet-and-ranges/range-operations/fill-ranges/index.md>) - Fill a range with numbers, dates or a list of values with `FillNumber`, `FillDateTime` and `FillList`.
- [Sorting ranges](<https://epplussoftware.com/docs/worksheet-and-ranges/range-operations/sorting-ranges/index.md>) - Sort the rows or columns of a range on one or more columns or rows, ascending, descending or by a custom list.