Geek Answers Handbook

Turn function into selected cells

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

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

thanks

+4
source share
2 answers

You can enter values ​​in all cells in the selection by entering the desired text and pressing Ctrl-Enter .

Update

I cannot think of any simple way to automate the input of these formulas, except using a macro. If you just want the values, you can create a second range next to the original with the journal values, and then use special and special copy and paste values ​​to copy the values ​​only.

+2
source

There is no Excel native method for this, but you have two options:

  • Buy a third-party plugin (for example, ASAP Utilities ); or
  • Create a simple macro that applies the formula to all selected cells:
 Sub ApplyLogToSelectedCells() For Each cell In Selection cell.Value = Log(cell.Value) Next cell End Sub
+2
source

More articles:


All Articles