Microsoft Office Tutorials and References
In Depth Information
Entering data and formatting on many worksheets at the same time
Entering data and formatting on many worksheets at the same time
After you work with Excel for a while, you’ll probably develop
standard worksheets that you use over and over. When
working with worksheets that follow a common layout, you might
want to enter a set of data across multiple worksheets. For
example, you might have a set of column headers that you
want to appear on several worksheets, and you would like to
avoid creating them from scratch for each individual worksheet.
In Excel 2013, you can save lots of time by entering data and
formatting in equivalent blocks of cells on multiple worksheets.
If you have existing data that you want to paste into several
worksheets at the same time, you can do that as well.
2
3
5
Enter and format data on several worksheets
at one time
1 Hold down the Ctrl key, and click the sheet tabs of the worksheets
that you want to edit.
2 Select the cell or cells in which you want to enter the data.
3 Type the data that you want to appear in the same cell or cells on
the worksheets that you selected.
4 Right-click the selected cells.
5 Using the Mini toolbar, specify the formatting options that you
want.
6 Press Enter.
7 Click the sheet tab of any unselected worksheet.
TRY ThIS To format your cells by using controls that aren’t
available on the Mini toolbar, right-click the cell(s) and choose
Format Cells to display the Format Cells dialog box.
TIP If you select all of your workbook’s worksheets, you can
ungroup them by right-clicking any selected worksheet’s sheet
tab and then clicking Ungroup Sheets.
1
7
Search JabSto ::




Custom Search