If you’d like to unhide your rows, you can use the arrows again: Then-voilà-those rows will vanish, but they’ll still affect the column totals, of course. Either way, you’ll pick “Hide Selected Rows” from the choices. Then you can either hover over and click the arrow I mentioned above on any of the selected rows, or you could right-click anywhere within the selection. Here’s how you do that! First, click and drag on the row numbers to select the ones you’d like to hide. You see, I’m usually concerned with the totals, not the individual item details, so it makes sense just to focus on the most relevant entries without having fifty million rows to scroll past. The benefit of this is that when you scroll up and down, your header will stay put, making it easy to see where you’re supposed to be entering info.Īs I mentioned, though, the way I like to handle this is by hiding rows I’ve already finished entering data into. …and then when you click the arrow, a contextual menu will appear with the “Convert to Header Row” option. One way to make this simpler is by designating a header row-if the template you’re using doesn’t have one included automatically, you can hover over the number next to your header row to reveal an arrow… So in a spreadsheet like this, if you keep on entering row after row of data, eventually you’re going to get tired of scrolling down to get to the next blank line. I mean, I do have this spreadsheet, but let’s say I do, too. So for example, let’s say I have this spreadsheet. Here’s a trick I use in Numbers all of the time-hiding rows to better see what I’m doing.
0 kommentar(er)
