By Cameron Dyett at April 09 2019 09:19:27
Microsoft Excel includes a number of little known shortcuts, tips, and tricks to quickly manage the worksheets in a workbook. These hidden tricks can be big timesavers as you move between worksheets, and add, rename, and copy Excel worksheets.
In 1986, mimeograph machines were (for the most part) replaced by digital copiers in elementary schools. Those of us teachers who experienced using mimeograph machines will forever remember the distinct smell of the still_damp, purple_ink worksheets that we handed out to our students _ by the ream full. (If you're like me, you can remember that smell right now!)
Let us explore the benefits of using worksheets for Nursery to Grade 2 learners. Benefitη _ Innovative worksheets for kids created by educationists can be used to teach Maths, English and EVS to make the foundational concepts easy and intriguing in an enjoyable format.
1. Quickly Move to a Worksheet _ To quickly navigate to a worksheet in an Excel workbook, right_click on any of the 4 triangle navigation buttons (located immediately to the left of the worksheet tabs) to display a pop_up menu of worksheet names. Then, left_click on any worksheet name you want to move to. If the worksheet you want isn't shown, click on the More Sheets... option. 2. Move Between Worksheets in a Workbook _ With up to 1꯸ worksheets possible in a Microsoft Excel workbook, try these keyboard shortcuts to toggle or cycle between worksheets: Next worksheet: [Ctrl] + [Page Down] Previous worksheet: [Ctrl] + [Page Up] 3. Easy Worksheet Management _ Right_click on any sheet tab (Sheet1, Sheet2, etc.) for a shortcut menu of worksheet options. This is a quick way to rename, delete, add, apply colors to worksheet tabs, copy, and more. By the way, you can also rename a worksheet by double_clicking on any sheet tab (Sheet1, Sheet2, etc.) to highlight the sheet name. Type a new name and press [Enter]. Tip: avoid ALL CAPS which increases the width of the sheet name and decreases how many worksheets can be displayed in one view. 4. Insert a New Worksheet _ Just press [Shift] + [F11] to create a new worksheet. 5. Fast Worksheet Copy.