In a few cells a plain number 12 would be inserted, but in a few cells ’12 would be inserted. I will give four samples that will give you an idea of the usefulness here, but do feel obliged to explore this command further. Defining or refining your selection (Go To Special) So a far more bulletproof method than the Name Box although it takes an extra key to get there :). Press enter and something great happens, instead of renaming the active cell Excel warns me that the reference is not valid! So I press F5 and in the “Reference:” field I write _E4.
Now I will attempt the same with the Go To… command. I will write _E4 in the Name Box by mistake and press enter.Īlthough Excel gives no warning, cell A1 was renamed to _E4. Now this can be very useful but also a source of confusion. If you make a mistake and write something that isn’t a valid cell address, Excel will (without warning) give the cell (or range) that is selected a name. You probably know that you can move through and even select a range of cells in a workbook by using the Name Box, but there is a catch. Let’s take a look at each functionality separately. The Go To… command which you get by either pressing F5, Ctrl + G or HOME/Find & Select/Go To… does it both. Very often you will find yourself in a position where you wish to either move efficiently through the workbook or you wish to select only cells containing certain kind of data (text, numbers, errors, objects, formulas…).
0 kommentar(er)
