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.

I have a work sheet, it has 10,000 rows.2,000 of those are for the state of New York.So I add a filter, then drop down on the state column and select New York.I then have 2,000 rows displayed.I ...

How to Copy Format Changes From One Table to Another in an Excel Spreadsheet. Microsoft Excel lets you format tables, adding borders and colors, and lets you format the text in them, editing font ...