Friday, 8 August 2014

Microsoft Excel - How to Enter the same data in other worksheets?

If you've already entered data on one worksheet, you can quickly copy the data to corresponding cells on other sheets.
  1. Select the sheet that contains the data and the sheets to which you want to copy the data.
  2. Select the cells that contain the data you want to copy.
  3. On the Edit menu, point to Fill, and then click Across Worksheets. 
See more:

Microsoft Excel - How to Fill in a series of numbers, dates, or other items?

Microsoft Excel - How to Enter or edit the same data on multiple worksheets?

Microsoft Excel - How to Automatically fill in repeated entries in a column?

Microsoft Exel - How to Enter the same data into several cells at once?

Microsoft Excel - How to Stop automatically completing file names and URLs?

Microsoft Excel - How to Insert a symbol and Unicode Character in Excel?

Microsoft Excel - How to Add an XML map to a workbook?

No comments:

Post a Comment