Return to site

Finding hidden cells in excel for mac

broken image

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.