![]() Excel Worksheets |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Excel Worksheets Additional Resources |
Renaming A WorksheetExcel Worksheets, by default, are named Sheet 1, Sheet 2, Sheet 3 and so on. Providing more meaningful names helps you identify a particular worksheet.Don't make the names too long though, there is only so much space on the screen that you have to keep the names short but meaningful! If you use lengthy names, you can see fewer Excel worksheets tabs without scrolling. (Unless, of course, you have a widescreen - where space is no problem!)
To change a Worksheet's name, use any of the following methods:
You'll notice that any of these methods selects the text in the tab. Just type the new sheet name directly on the tab and press ENTER once you're done.
Moving A WorksheetSometimes, you want to rearrange the order of the Excel worksheets in a workbook or move a sheet to a different workbook.
There are usually more than one way to move a Worksheet tab around. To move a worksheet to another workbook, follow these steps:
|
Excel XP Topics- Tips- Excel Screen Layout - Navigational Techniques - Working with Workbooks - Templates - Working with Worksheets - Moving Around - Move Worksheets - Copy Worksheets - Insert & Delete Cells - Insert & Delete Rows - Insert & Delete Columns - Resize Row - Resize Column - Editing Data - Content Color - Cell Color - Number Formats - Fonts - Alignment - Text Direction - Indent Contents - Merge Cells - Copy - Move - Undo & Redo - Using Zoom - Freeze & Unfreeze Titles - Split Worksheet - Spreadsheet Data - AutoFill - AutoComplete - Comment - Find - Replace - Spellcheck - Formulas - Functions - Password - Sorting - AutoFilter - Advanced Filter - Macros - Charts - Charting - Charting Elements - Gantt Chart - PivotTable - PivotTable Calculations - PivotTable Layout - PivotTable Format - PDF to Excel - PDF-to-Excel Converter - Excel to PDF Converter |