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!

Microsoft Excel updates cell references when you copy an expression. Here are a couple of workarounds for those rare occasions when you don't want to change the cell references.

Excel's Subtotal command allows you to quickly create subtotals in your sorted data, and then collapse the view to to show only the new subtotal rows. When you try to copy the subtotals by ...

Figure G Now, try copying and pasting from Word to Excel. Select the text you want to copy. Tap the Copy command from the popup toolbar, move to Excel, tap an empty cell, and then tap the Paste ...