Clearing Contents

  • Thread starter Thread starter AMANDA
  • Start date Start date
Hi,
Select the range you want to clean up--include as many formula cells as you
want.

Then edit|goto|special
check Constants
click ok

hit the delete key on the keyboard.

(You may have constants that you want to
keep--headers/descriptions/instructions.)
 
Hi Amanda

Press F5 from worksheet. From Goto window select Constants. Select the
option you needed. Hit OK to select all cells. Press delete key,.

If this post helps click Yes
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clear Contents 1
Clearing content from a cell (or a group) but retain its formula 2
Clearing cells without clearing formulas 2
Windows 10 Changing folder view settings to a folder and sub folders but not contents. 3
How to clear up useless content within worksheet? 1
Macro to clear contents of certain cells 4
Clearing cells takes long, long time 9
Conditional Format on another cell's value 7

Back
Top