Enter Data Into Scattered Cells


Q. How do I copy the same information into many different Excel cells when the cells aren’t contiguous?

A. Think of the Ctrl key as the repeat key. For example, to easily move a bunch of noncontiguous files in Explorer, hold down the Ctrl key and then select each file. When done, move them in one step. Likewise, in Excel, hold down the Ctrl key as you click on each cell in the set. Then type the information you want to enter. But be careful: Do not press Enter. Instead press Ctrl+Enter.

SPONSORED REPORT

CPEOs provide peace of mind around payroll services

The creation of these new IRS-certified service providers for small businesses clarifies some issues around traditional professional employer organizations.

QUIZ

8 sentences to help you master subject-verb agreement

When professionals prepare written material for readers inside their organization or outside, they should make sure that no errors distract from the message they need to convey. Take this short quiz for practice in subject-verb agreement.