Tag Info

Hot answers tagged

4

Supposing you want to put the formulas in column F I would try in this way: write your formula on F1 (so the first cell will contain =LEFT(E1,2) ) select and copy the cell containing the formula (F1) select the entire F column (click with your mouse on the column letter on top) finally paste-special/formula and your formula will be in the entire F column ...


2

Select a cell in a column in your table that has values filled in all the way down to the bottom row of your table (if there is such a column), hit Ctrl + down, which will jump you to the bottom row. Then move over to the column where you want to fill the formula down, hit ctrl+shift+up to select all the cells from there up. If you have a header row or ...


2

Enter your formula in the first row. Arrow over into the column E. Press Ctrl+Down. If E has any blanks, you'll have to push this a few times to get to the last row with data. Arrow over back to your formula column (in the last row). Press Ctrl+Shift+Up. This will select all the cells above, including the top row that includes the formula you entered. Press ...


2

Assuming that you want to put the formula into Column F: Type F1:F30000 into the Name Box (to the left of the Formula Bar) and press Enter.  This will select that range. Type =LEFT(E1, 2) … … and press Ctrl+Enter (not Ctrl+Shift+Enter). That’s it.


1

As I see it, there are two options here: It's a hardware issue. I lean towards this option because you said you have to press hard before the letter prints, suggesting some issue with the keyboard itself. If the keyboard is old, this is to be expected - most keyboards, as with mice, actually have a keypress rating, or about how many times you can press a ...


1

Same thing happens to me ... but only once in a while. The problem then is that my password needs to be entered on waking from sleep, and that's hard to do when the keyboard doesn't work. What works for me every time is to click on the "Handicapped" icon in the lower left of the screen. One of the options lets us use the mouse to select letters and numbers. ...



Only top voted, non community-wiki answers of a minimum length are eligible