Multiple Sheets

Enter the same data in the same place on 2 or more sheets by selecting the sheet tabs and pushing Ctrl.

Any data entry or editing will be performed on all selected sheets. Select one sheet and push Ctrl again to de-select.

(You can also use Select All Sheets and Ungroup Sheets, but using the Ctrl key is faster)



© Copyright andrewsexceltips.net All Rights Reserved.