Streamline the setup of Excel worksheets — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily

Streamline the setup of Excel worksheets

Get PDF file

by on
in Excel Training,Office Technology

Are you setting up separate tabs for each month when collecting information for Excel workbooks? Try this fast-track method to do the hard work only once!

Insert 12 blank worksheets. Click on the one farthest to the left. Then, holding down your Shift key, click the one farthest to the right. (You might need to drag the horizontal scroll bar out of the way.) With all 12 worksheets selected, create the worksheet framework, column and row titles, formulas, etc.

Now, right-click on any worksheet tab, and choose Ungroup sheets. Voila! Just label the months on your worksheets, and you’re all set.

Leave a Comment

 

Previous post:

Next post: