Excel Can Be 'Rand'om Too

re: Excel Can Be 'Rand'om Too

Andy Cotgreave — Fri, 14 Oct 2005 17:08:36 GMT

The best bit in this post is your little revelation that Paste Special is only 3 clicks in Office 12.

That's great news!

re: Excel Can Be 'Rand'om Too

Mario Goebbels — Fri, 14 Oct 2005 17:17:28 GMT

Guessing from Excel screenshots I've seen, you click the Copy button on the clipboard ribbon, then on the arrow under the huge paste button to finally click an soon-to-be-listed option called Paste Values. Am I right?

re: Excel Can Be 'Rand'om Too

jensenh — Fri, 14 Oct 2005 20:06:01 GMT

On the 3 clicks: Copy, Paste (which is a split button), Values.

Mario wins the prize.

re: Excel Can Be 'Rand'om Too

Jon Peltier — Sat, 15 Oct 2005 03:39:45 GMT

(By the way, doing this same operation in Excel 12 takes 3 clicks instead of 6!)

No, it's two clicks on Excel 9-10-11. One on copy (or Ctrl+C), and one click on the custom Paste Special--Values button on my custom toolbar. I also have Paste Special--Formulas, Paste Special--Formats, and Paste Special--Values/Transposed. This is the kind of flexibility we're concerned about retaining as we move forward.

(Don't get me wrong, I'm a big fan already.)

re: Excel Can Be 'Rand'om Too

TC — Sat, 15 Oct 2005 12:09:32 GMT

> Excel fills all of the selected cells with
> different random numbers between 0 and 1.

If they're guaranteed different, they ain't random! :-)

re: Excel Can Be 'Rand'om Too

Harvey Motulsky — Sat, 15 Oct 2005 15:47:10 GMT

In a previous post, you explained how Office 12 strived to avoid hiding commands 'under rocks'. Clicking Control-Enter to enter an array formula is way more obscure than that. It comes out of thin air, with no way to discover (other than reading books). Will array formulae be improved in Excel 12?

re: Excel Can Be 'Rand'om Too

PatriotB — Sat, 15 Oct 2005 20:34:52 GMT

It could be 4 clicks -- if you are on a different ribbon than the one that contains the Clipboard chunk, you'd have to click the appopriate tab to get to that.

re: Excel Can Be 'Rand'om Too

Mario Goebbels — Sun, 16 Oct 2005 14:35:00 GMT

The clipboard ribbon is probably one of the ever present ones.

re: Excel Can Be 'Rand'om Too

Kawigi — Mon, 17 Oct 2005 20:33:08 GMT

Clipboard is a chunk on the Sheet tab of the ribbon. It's ever present, but not always in front (so PatriotB makes a good point).