Hi, I have a template that has to be used in multiple worksheets. Can someone help me with a way in which i can paste the headings in all sheets at the same time. The template has a portion where one has to sign.
Hi, I have a template that has to be used in multiple worksheets. Can someone help me with a way in which i can paste the headings in all sheets at the same time. The template has a portion where one has to sign.
Open the clipboard. Select and copy the data that you want on all worksheets. Copy.
Click on the first worksheet that you want the copy to be on. Hold down the shift key and click on the last worksheet for the copy. Select the upper left corner of the area where you want the copy to be and click the copied data that is on the Clipboard. The copy will be copied onto all the grouped worksheets.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
thanx very much Ron![]()
You're welcome. Thanks for the feedback.
Please delete.....duplicated post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks