By default when you select a range of cells in Excel, hidden cells are also selected. This means any data in hidden rows or columns is included when you copy a selection. Chances are, that's not what you want. In this video, we'll show you how to work with visible cells only.

Here we have a list of real estate properties. Let's say we want to give this list to someone else, but without the data in columns E through I. We can easily hide these columns. But if we then select all the properties, copy, and paste into another worksheet, we get all of the data, including the data in columns that were hidden. This is because Excel is selects both visible and hidden cells by default. To get around this problem, we need to tell Excel to select only visible cells. First, make the selection normally.

Note that if you type anything into those cells, it will automatically be hidden after you press Enter. Also, whatever original value was in the hidden cell will be replaced when typing into the hidden cell. Hide Gridlines. A common task in Excel is hiding gridlines to make the presentation of the data cleaner. Display or hide cell values. Select the cells. On the Format menu, click Cells, and then click the Number tab. Under Category, click Custom. In the Type box, type;;; (that is, three semicolons in a row), and then click OK.

Then on the home tab of the ribbon, click the Find & Select menu and choose Go To Special. In the Go To Special dialog, select Visible Cells Only. [Mac: Edit > Go To > Special > Visible Cells Only] You can now copy the selection, and paste. Only data in cells that were visible will be copied. Back in the original worksheet, we can verify the selection by unhiding the columns. Now you can see the moving dashed line around the cells that were copied. Notice the cells that were hidden are not included.

If that seems like a lot of steps, you'll be happy to know that Excel provides a keyboard shortcut for selecting visible cells: For Windows, use Alt +; On a Mac, use Cmd Shift Z Let's try it out. As before, we'll hide the columns, then make a normal selection. This time, we'll use Alt; to change the selection to visible cells only. Now we'll copy. When we paste, we get only data from cells that were visible.

See solution in other versions of Excel: • • • • • Question: How do I unhide row #1 in a sheet in Microsoft Excel 2016? Answer: In this example, you can see that row 1 is hidden in the spreadsheet. To unhide row 1, select the Home tab from the toolbar at the top of the screen. In the Editing group, click on Find & Select button and select 'Go To.'

From the popup menu. When the GoTo window appears, enter A1 in the Reference field and click on the OK button.

Select the Home tab from the toolbar at the top of the screen. Select Cells > Format > Hide & Unhide > Unhide Rows. Row 1 should now be visible in the spreadsheet.

So to say I’m a power-user of this product would be an understatement. In case you missed it, Quicken is no longer owned by Inuit, which sold it to a private equity firm. I had every bank account, credit card, asset, retirement, investment and liability linked to the software. Long term, I’m not sure what to make of this news or what it means for the future of Quicken. I used to track every one of my 60-plus accounts with Quicken.