HOW DO I REMOVE AND UNWANTED FUNCTION IN A CELL OR GROUP OF CELLS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If there is anyone who can answer this please email me (e-mail address removed)
 
You are posting to a newsgroup, so your responses will also go to the
newsgroup.

In a single cell just press the <delete> key. For a group of cells,
highlight the cells and then press the <delete> key.

Hope this helps.

Pete
 
Hi Charles

If by chance you mean to get rid of the formulas
and leave the results, then select your cells,
right click on the selection and pick Copy
right click on the selection again and pick Paste Special
Check multiply and OK out.

HTH
Martin
 
Woops, engage brain before posting!
right click on the selection again and pick Paste Special
Check **multiply** and OK out.
Click to expand...

That should read
right click on the selection again and pick Paste Special
Check **Values** and OK out.
Click to expand...

HTH
Martin
 
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

Protected cells can't be grouped 1
Red cell for negative numbers in Excel 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
formula-add 2 numbers of cell a1 and a2 of sheet1 ans-b9in sheet2 1
Masking out characters in a cell 9
Cell Reference 1
If function across sheets prints value of cell 4
"#VALUE!" Cell Value 1

Back
Top