only value

A

alekm

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
 
F

Frank Kabel

Hi
first copy the cell and insert the value with 'Edit -
Paste Special - Values'
 
I

icestationzbra

there is no predefined keyboard shortcut.

you could record a macro to copy and paste special, and assign
shortcut key to the macro
 
D

Debra Dalgleish

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
 
R

Rita Palazzi

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...
 
Top