Learn high-level tips and tricks to get started in Excel master. Contact BC Networks with your software and hardware questions and needs.
With a minimum of 750 million users, Microsoft Excel is still the most popular spreadsheet in the world. Entire books have been written about how to navigate and format Microsoft Excel workbooks. Here, we concentrate on high-level tips and tricks to get you started and point you toward valuable resources that help you become an Excel master. Learn how to do the following in Excel:
Navigating Through Worksheets
Inserting and Deleting Worksheets
Renaming, Moving and Copying Worksheets
How Do I Navigate Between Worksheets?
Worksheet Tab Controls are located at the bottom left of the workbook. They look like two pairs of left and right arrows. Use the arrows to navigate left or right through the worksheets or to go to the first or last worksheet.
When you right-click on the controls, a pop-up list of all worksheets in the workbook appears. Simply click on the sheet name to navigate to it.
If there are more than 15 worksheets, select the More Sheets…. option. In the Activate dialog box, you can scroll through the worksheets to select the one you wish to navigate to.
What’s the Best Way to Insert and Delete Worksheets?
Follow these steps to insert or delete worksheets.
Inserting a Worksheet
1. Choose the Select + plus icon at the bottom of the sheet. (It should appear next to the last worksheet tab.)
Or, use the file menu. File> New > Blank Worksheet.
Delete a Worksheet
Right-click on the Sheet tab of the sheet you want to delete.
Or, select the sheet, and then go to the Home ribbon. Delete > Delete Sheet.
How Can I Rename, Move and Copy Excel Worksheets?
Follow these steps to rename, move or copy sheets.
Rename a Worksheet
To rename a worksheet:
Double-click on the sheet name and type in the new name.
Or, right-click the Sheet tab, select Rename, and enter the new name.
Move a Worksheet
To move a worksheet, click on the worksheet tab and drag it to the desired position.
Copy a Worksheet
It’s easy to copy a worksheet to have a formatted working template.
Right click the worksheet tab and select Copy.
Click on the “Create a copy” checkbox.
Look for the Before sheet option and select a sheet.
What Are Some Essential Formatting Tips?
Use formatting to make your spreadsheet pop. Users can consume complex graphs and financial information much more easily if they are well-formatted. Here are some tips to spruce up your sheets.
Bold, Underline and Italics
These basic formatting tools draw the user’s attention to important text.
To use these effects, highlight the appropriate cells, go to Home>Font, and apply the desired formatting.
Borders segment complex data and carve out sections of like measures. Excel has a variety of borders to choose from.
Highlight the cells you want to apply a border to.
Go to Home>Font>Borders
Use the dropdown menu to pick a border style such as single or double lines.
Shading, or fill, is a cell background color. You can shade a cell by following these steps:
Highlight a cell or group of cells.
Go to Home>Font>Fill Color.
Click the down arrow to the right of the paint bucket. Choose the color you want for the cell background.
While we have covered some of the basic elements of Excel formatting, this robust tool has hundreds of ways to customize your worksheets. Learn more at Microsoft support.
Searching For A New IT Company For Your San Francisco Bay Area Organization?
For 17+ Years, BC Networks has helped large and emerging organizations throughout San Jose and the entire San Francisco Bay Area with all their IT service needs.
Schedule Your Initial Consultation.
Fill out the form below.
Meet Our President & CEO
Dave is an IT Executive with a proven track record of building value, industry relationships, world-class secure network infrastructure, and management teams to lead start-ups to market leadership positions.
Specialties: Office365, Disaster Recovery, Cybersecurity Risk Assessments, Public & Private Cloud solutions, System Design & Architecture, IT support services for Small to Medium-sized Enterprises.
17+ Years of Experience Working With Large & Emerging Organizations
In The San Francisco Bay Area.
Our Results Speak For Themselves!
"BC Networks is one of the best IT support companies I've done business with. Great staff always courteous and knowledgeable. They leverage cutting edge managed services tools that can monitor and protect IT infrastructure from internal and external threats before they happen. BC Networks has different service packages priced to fit almost any sized business. I would highly recommend them!"
Schedule your No-Obligation IT Assessment with BC Networks