If you press Ctrl+` again, we're back to our normal displays. And what happens? All column widths have been doubled and wherever there's a formula we see the formula. But as a keystroke shortcut don't use the shift key but do use the control key and press that key on your keyboard, Ctrl+` I'll call it. The one below it is usually referred to as accent grave from the French. The symbol on top is called tilde.Still, it isn't foolproof, though. And the reason this feature doubles the width of columns is to give us a better opportunity to see the formula. Ctrl+` doubles the width of columns as it exposes formulas or it takes us back to normal.This will readjust all column widths and then we could print the worksheet in its current form. What we might do is click in the upper left corner and then double click any column boundary. Particularly if you know the worksheet is valuable and you're going to be working with it a bit or if you want to absorb its content faster. Which you might also want to consider doing in these situations.Then double-click any column boundary between the letters. It's probably still selected anyway. So if we press Ctrl+` , we'll go back to normal and since we did readjust the column widths when the columns were wider, we'll want to do this again, clicking in the upper left-hand corner.
![]() ![]() Notice that the pop up tip below it does refer to the other symbol. So from the ribbon, go to the Formulas tab and you will see the choice called Show Formulas. We also find this feature in the menu, but it's easy to overlook and they do refer to the other symbol that's on that same key, that so called accent groove. ![]() I'll just use this tan color right here. Give it a color that's light enough for the text to show through it. We can do that simply from the Home tab, the Fill Color bucket right here. Now before clicking anywhere what you might want to consider doing is applying a color to all these so you remember which cells have formulas. And all cells that have formulas in this worksheet are currently highlighted. Safari versus google chrome for macHere too begin with the active cell in a single location. A companion to this is the idea that you might want to highlight all of the cells that have pure numbers in them, not formulas but just pure numbers. Or if we erase this formula here, it would continue to stay tan, so from time to time, you will want to run the feature again, to make sure that it's up to date. Now, the feature's not dynamic if we were to write a new formula here it's not going to turn tan. And similarly as we did with formulas we might want to choose a contrasting color here, I'll use a light blue. Click OK and now we've selected these. And in the go to special dialog box, choose Constants, but then uncheck the boxes for Text, Logicals and Errors. In other words, it removes duplicates from a data set. You will have a much better capability for understanding and working with sheets that have formulas.Excel Details: UNIQUE is a Dynamic Array Formula that returns all the unique values from a data range. And the more you work with these the two features and its predecessor where we were able to highlight the formulas. So it really helps you figure out what is going on in a worksheet. The tan cells are those that contain formulas.
0 Comments
Leave a Reply. |
AuthorGary ArchivesCategories |