ExcelBanter - Erasing a spreadsheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Erasing a spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/225250-erasing-spreadsheet.html)

graham8889

Erasing a spreadsheet

How do I erase large amounts of data without erasing the formulas

FSt1

Erasing a spreadsheet

hi,
hit the F5 key. select special button. select constarants. ok
hit the delete key.
all data should be gone. formula remain.

Regards
FSt1

"graham8889" wrote:

How do I erase large amounts of data without erasing the formulas

All times are GMT +1. The time now is 02:44 AM.