Double-Click Excel Cells To Maintain Formatting

It's a simple tip if you know it, but I must admit it's new to me: to ensure that content pasted into Excel matches the existing format of your spreadsheet, double-click the cell before pasting. Certainly faster than pulling up the smart tag or using Control+Space if you're a mouse jockey. [Office Blog]


    What if you're pasting to multiple cells?
    Is there anyway to lock row height?

    You can also press F2

Join the discussion!

Trending Stories Right Now