Add And Navigate An Excel Worksheet

Worksheets are great for when you need to maintain separate spreadsheets within one document. They are located at the bottom left of your excel document. As you can see in FIGURE 1,  my worksheets are named “Home Expenses”, “Work Expenses”, “Tax 2015” and “Tax 2016”.

https://i0.wp.com/imgsrv.worldstart.com/images/ct-images/2017/04/excel-worksheets-figure-1.jpg?w=648

Adding worksheets is easy, right click on the name of an existing worksheet then click on Insert (see FIGURE 2).

excel-worksheets-figure-2

Then click on Worksheet (SEE FIGURE 3). If you prefer a quick keyboard shortcut use Shift + F11. A quick way to navigate between worksheets is to simply use CTRL + PAGE UP or CTRL + PAGE DOWN.

https://i0.wp.com/imgsrv.worldstart.com/images/ct-images/2017/04/excel-worksheets-figure-3.jpg?w=648

~ Eli Spetgang

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.