Slider

How to Input the Same Content in Different Cells and Different Sheets of Excel

Date:2019-7-9 Author:Cordelia

While editing a table in Excel, it's hard to avoid a kind of situation which requires you to input the same content in different cells or even different sheets. In this instance, using shortcut keys or shortcuts could greatly improve your efficiency.

Step 1, select all the cells you want to input the same content in, and type in this state.

How to Input the Same Content in Different Cells and Different Sheets of Excel

Step 2, press Ctrl+Enter. The text you input will be filled in all these cells.

How to Input the Same Content in Different Cells and Different Sheets of Excel

Step 3, click the sheet tag and press Ctrl, then click the tag of another sheet which is the one you want to input the same content in. If you do it right, the tags of these 2 sheets will both become white.

How to Input the Same Content in Different Cells and Different Sheets of Excel

Step 4, click Fill in Home tab, choose Across Worksheets... in the list.

How to Input the Same Content in Different Cells and Different Sheets of Excel

Step 5, select All (according to your need) and click OK to confirm it.

How to Input the Same Content in Different Cells and Different Sheets of Excel

Now switch to the new sheet to have a check. The table in sheet 3 has been copied to sheet 5. Mission completed.

How to Input the Same Content in Different Cells and Different Sheets of Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *