Modelling and the mouse gap, following, accounts, holding, without

ishfaque

Ok, everybody serious about modelling seems to say that the use of a mouse is inefficient & amateur.

Now I am by all accounts an amateur modeller and I wonder how a serious modeller without a mouse would do the following extremely simple things:

- If you want to add a few cells for a quick check, but these is no sum in the spreadsheet for these cells exclusively and they are not next to each other. I just select these cells with the mouse while holding CTRL after the first gap. At the bottom right of the screen there is this little sum that appears and that was it.

- If you want to see which cells come in a sum. The sum cell is in say, A100, but the inputs for that sum are spread in the column,say in A5, A51, A60 to A70 and A80.
I just click on the A100, then F2 and scroll up and down with the mouse to get a visual of these cells.

So, how would you do these little things effectively without a mouse ?
Txs, I am very curious.

dvilayphet

Shift F8, move cursor with arrow keys, shift F8, move cursor etc.

If the second or subsequent cells are a single cell you will need to press F8 twice for reasons unknown.

If you are just doing single cells dotted all over the place it can be quicker with the mouse. Shift F8 is more useful if you are doing blocks of numbers.

AnalystAlan

i've never used f8 before. i'm not completely sure if i ever will again, but it's interesting to know. thanks big bean

jacksparrow

justin88 Wrote:
-------------------------------------------------------
> If you're "serious" about modeling, you shouldn't
> be using excel.
Disagree, Excel is nice as a frontend app for the models

But I still wish I knew more of these short-cuts, I like the tip.

Walex

Tried it. Cool, thanks.

In this specific case it is , however, slower than using the mouse, isn't it ?

Not trying to be an a$$, really. Just trying to understand why people hate on the mouse so much.

Otabek

Viceroy Wrote:
-------------------------------------------------------
> Tried it. Cool, thanks.
>
> In this specific case it is , however, slower than
> using the mouse, isn't it ?
>
> Not trying to be an a$$, really. Just trying to
> understand why people hate on the mouse so much.

It is much quicker to use the keys if you wish to add two blocks of cells (and use ctrl, shift and arrow keys effectively), but for several single cells it is one of the few things that is quicker with the mouse.

Most people dislike the mouse as virtually everything else is quicker with the keys. I even have a personal macro workbook always open in the background to allow additional short-cuts for things where you might be reduced to mouse use due to the number of key strokes required, such as changing the cell colour. But then, I use Excel a lot.

mamuka12

I would like another tip for cells that are linked to input cells:

1) I disable the direct editing of cells and edit them with F2. So when a cell is linked with another one I double click it and land on the input. What is the keybord equivalent of that double click ?

2) If you want to check a long formula which is linked to other cells in different sheets, what is the best way to doing this if you want to avoid the retarded following things (which I do):
- copy the formula in word
- memorise it
- always go back to the original formula during your check because you failed to memorise it

There has to be some function which brings the formula in a little window or something and even highlights the input cells, as you switch sheets ?


Txs alot in advance, it would really save me some time.

ruchita

Does anyone have a keybord trick for my last question two posts up ?

I made a little search but couldn't come up with anything.

AndyNZ

I only do nude modelling, so having a mouse nearby makes me a little nervous. Better than a shaved gerbil I guess, but still a little unsettling.