How to Quickly Enter Similar Data in an Excel 2007 Worksheet

excel logo smaller

A very cool shortcut you can use in Excel 2007 allows you to copy data from the cell above the current cell.

Follow the steps below to learn how:

  • Click Ctrl + “ (quotation mark)

Say you enter the number 456 in cell A6. If you then move to cell A7 and click CTRL + “, 456 appears in the cell.

If you then go to cell A8 and key in CAB and click CTRL + “ you will see CAB456 in your cell.

This can really come in handy when you are entering data with a lot of similarities.

Go ahead and give it a go and see how much time you can save!


Posted in:
About the Author

Carol Bratt

Carol holds A+, MCP, and MOS computer certifications and is the resident DCT Office expert. She trains the staffs of small law firms in the use of Microsoft Office applications and has authored many books covering Microsoft Office as well as written articles for Infopackets, TechnoLawyer, and Digital Harbor. For more Microsoft Office tips visit Carol's Corner Office or follow Carol on FaceBook and Twitter.