Recent I.T. and Business News You Need
Looking for Something Specific?
Search the I.T. and Business News You Need Archives.
Learn high-level tips and tricks to get started in Excel master. Contact BC Networks with your software and hardware questions and needs.
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.
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
Or, select the sheet, and then go to the Home ribbon. Delete > Delete Sheet.
Follow these steps to rename, move or copy sheets.
Rename a Worksheet
To rename a worksheet:
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.
It’s easy to copy a worksheet to have a formatted working template.
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.
Shading, or fill, is a cell background color. You can shade a cell by following these steps:
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.