Copy first and last names into separate cells without retyping (Excel 2016/2013/2010)
If you have a spreadsheet containing a list of people’s names, and each first and last name is in a single cell, you can break the first and last names into separate cells without having to retype each name yourself...
Paste data on more than one sheet at a time (Excel 2016/2013/2010)
When you’re creating multiple, similar worksheets in a workbook, you can paste data onto more than one sheet at a time, as long as you’re pasting it into the same location on each sheet....
Name data ranges to build formulas more easily (Excel 2016/2013/2010)
Naming ranges of data helps you give plain English titles to otherwise cryptic groups of cells. Rather than selecting cells B4:B12, all the numbers in your Prices column, ....
Using Drop-Down Lists in Excel
Want to Learn More? Contact
New Horizons Central at