Academic journal article Journal of Accountancy

Enter Data Simultaneously on Multiple Sheets

Academic journal article Journal of Accountancy

Enter Data Simultaneously on Multiple Sheets

Article excerpt

Enter data simultaneously on multiple sheets ...Trim the size of inflated spreadsheets ... A better way to color spreadsheet gridlines ... Solve the problem of incomplete uninstalls ... Display multiple Excel worksheet tabs ... Stop Windows from offering to report computer errors to Microsoft ... Shortcuts

Q. I prepare one worksheet for each month of the year and I need to add the same data to some of those worksheets. What I've been doing is setting up the first worksheet with the appropriate data and then copying them to the other sheets that require the same data. As you can imagine, it's a lot of grunt work. Is there an easier way to do this?

A. Yes, there is. The trick is to first group the worksheets in which you want to enter the common data. Then you even can add formulas and formats at the same time and get three solutions for the price of one.

When you group worksheets, what you do in one sheet is automatically copied to all the others in the group. …

Search by... Author
Show... All Results Primary Sources Peer-reviewed

Oops!

An unknown error has occurred. Please click the button below to reload the page. If the problem persists, please try again in a little while.