excel- applying a function to the selected cells

Question

Is it possible to select a range of cells in excel- A1:B10 and then log everything in the cells?

I have too many cells to go through each and manually enter = and log in each cell.

thanks

Answer 1

You can enter values into all cells in the selection by typing the required text and pressing Ctrl-Enter.

Update

I can't think of any easy way to automate putting those formulas in except by using a macro. If you just want the values, then you can create a second range next to the original with the log values and then use copy and paste special (values) to copy the values over only.