To copy only visible cells in Excel or Google Sheets, use the 'Visible cells only' feature, or apply filters to hide data. We show you how!

If Excel is not highlighting cells in the formula, enable 'Allow editing directly in cells' and 'Enable fill handle and cell drag-and-drop' in Excel options.

Drag the Fill Handle across all the cells in the row you want to fill with the formula. Click the "AutoFill Options" button to select your options for how you want the cells automatically filled.

Sometimes it's necessary to split cells in a spreadsheet, and Microsoft Excel makes it easy enough to do.

You can wrap text in Excel in several ways to ensure that all the text in a cell is visible at once. You may also want to edit the cell height.

Click "Format" in the Cells group of the Home tab. Select "Visibility," and then select "Hide & Unhide" and "Unhide Columns" to make all missing columns visible.