MS Excel 2007 - Lesson 12: Develop Workbook
TipsMake.com - Format Workbook tabs
You can rename a spreadsheet or change the colors of tabs if necessary. As well as moving, transferring and deleting sheets in the same workbook.
To rename the spreadsheet:
• Open the worksheet to be renamed
• Click the Format button on the Home tab
• Click Rename Sheet
• Enter a new name
• Press Enter
To change the color of the spreadsheet tab:
• Open the worksheet to change the color
• Click the Format button on the Home tab
• Click Tab Color
• Choose color
Move the spreadsheet in Workbook
To move spreadsheets in a workbook:
• Opening the workbook contains the sheets you want to reorder
• Click and hold the spreadsheet tab until an arrow appears in the left corner of the worksheet
• Drag the spreadsheet to the desired location
Insert and delete spreadsheets
To insert a spreadsheet
• Open the workbook
• Click the Insert button on the Cells group of the Home tab
• Click Insert Sheet
To delete the spreadsheet
• Open the workbook
• Click the Delete button on the Cells group of the Home tab
• Click Delete Sheet
Copy and paste the spreadsheet
To copy and paste spreadsheets:
• Click on the tab of the spreadsheet to be copied
• Right-click and select Move or Copy
• Select the desired location of the sheet
• Click the check box next to Create a Copy
• Click OK .
You should read it
- MS Excel 2007 - Lesson 3: Working with Workbook
- Complete guide to Excel 2016 (Part 11): Check spelling in the worksheet
- Common causes of Excel workbook errors
- How to view Workbook Statistics in Excel
- Lock one or more data columns on Excel worksheet - Freeze data in Excel
- How to Do Trend Analysis in Excel
- Format Excel 2007 spreadsheet
- How to create the first Workbook in Excel
May be interested
- Google Dashboard - Everything Google knows about youon november 5, google officially launched dashboard service, which gathers all the information that users have sent in other google services.
- MS Excel 2007 - Lesson 13: Format sheets and printsthe print titles function allows you to repeat the column and line headings at the beginning of each new page to read more pages than to read when printing.
- 10 scam tricks via emailtoo many emails sent daily can make even the most cautious people reduce the level of potential 'risk' in emails.
- MS Excel 2007 - Lesson 14: Layoutin excel 2007, you can split a spreadsheet into multiple regions to easily view each section of a spreadsheet.
- Use Google Docs to convert MS Office files into PDFif you need to convert some word, excel, powerpoint files into pdf but your computer does not have support software installed, you can rely on google docs service.
- MacBook 2009 - healthy, competitive pricemacbook plastic shell, new version released this year, not only beautiful but the configuration and battery life is also better.