how to go to selected cell in excel for mac

By default, the program will copy and paste all of the cells--even if some have been hidden.

Heres the time-saving shortcut that will select only the visible cells in Excel, ignoring those hidden rows and columns.

Whether youve used a filter that hides certain cells, collapsed an outline, or hidden specific rows or columns, sometimes you want to work just with the data you see.

You can select the visible cells with a keyboard shortcut or with the Go To Special menu.

Select the range of cells in your worksheet.

Press Alt; (hold down the Alt key and then press the semicolon key).

Excel will exclude all the hidden data from your selection and then you can copy (CtrlC) and paste (CtrlV) only the visible cells.

Click the Find Select button on the Home tab, then click Go to Special 3.

Select Visible cells only 4.

Click OK. Now you can copy and paste without worrying about the hidden data being pasted also.

How to Freeze Rows and Columns in Excel 2016 How to Lock Cells in Excel 2016 How to Create a Waterfall Chart in Excel 2016.

You can unsubscribe at any time and well never share your details without your permission.

How To Go To Selected Cell In Excel For Mac