only value

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

Guest

Hi,
I've got rand() function in a cell. What's the way to exclude function so
only value stays in a cell?

Thanx

alekm
 
Hi
first copy the cell and insert the value with 'Edit -
Paste Special - Values'
 
there is no predefined keyboard shortcut.

you could record a macro to copy and paste special, and assign
shortcut key to the macro
 
It's not a keyboard shortcut, but a quick way to do this with the mouse:

Select the cells
Point to the border of the selection
Hold the RIGHT mouse button, and drag the selection slightly to
the right, then back to the original location
Release the mouse button, and from the shortcut menu, choose
Copy Here as Values Only
 
That's cool Debra!!! You're the bomb!
Rita



Debra said:
It's not a keyboard shortcut, but a quick way to do this with the mouse:

Select the cells
Point to the border of the selection
Hold the RIGHT mouse button, and drag the selection slightly to
the right, then back to the original location
Release the mouse button, and from the shortcut menu, choose
Copy Here as Values Only
Click to expand...
 
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

how to address all cells in column excluding first n cells in that column 3
blank range 2
reffering another cell value which contains RAND() 0
positive numbers with '+' sign 2
Excel Repeating a RAND() function under certain conditions 0
how to print label on the very end of excel sheet 5
sending clipart to background 1
Random Numbers 4

Back
Top