Lesson 13 Organizing and Enhancing Worksheets. Computer Literacy BASICS: A Comprehensive Guide to IC 3 , 3 rd Edition. Morrison / Wells. Objectives. Hide and unhide columns and rows. Freeze and unfreeze columns and rows. Create, rename, and delete worksheets.
Computer Literacy BASICS: A Comprehensive Guide to IC3, 3rd Edition
Morrison / Wells
A header row contains column headings or field names in a data source, such as a table or spreadsheet.
Two ways to prevent a header row from scrolling out of view include:
Changing the zoom setting
Hiding rows and columnsManaging Worksheets
Another way to keep rows and columns visible is to freeze them. When you freeze columns and/or rows, you lock them so you can keep an area visible as you scroll through the worksheet.
You can also split the worksheet horizontally or vertically so the panes appear side by side or one above the other.Managing Worksheets (continued)
When a spreadsheet grows to a large size, you can organize related information in multiple worksheets.
When you need to add a new category to an Excel workbook, you click the Insert Worksheet button at the bottom of the screen, and a sheet tab appears.Managing Worksheets (continued)
When you delete the contents of a cell using the Delete key or the Backspace key, the formats for the cell remain in the cell.
You can clear the contents and the formats from the cell, clear only the contents, or clear only the formats.Formatting Cell Contents
Merging Cells: appears.
You can merge cells and combine several cells into a single cell.
You can use merged cells to create a title or other informational text.
The Merge & Center button automatically centers the text in the merged cells.Formatting Cell Contents (continued)
Changing Font Styles and Sizes: appears.
Fonts are available in a variety of styles and sizes, and you can use multiple fonts in one document.
The font size is a measurement in points that determines the height of the font.
Bold, italic, underline and color formats also add emphasis to cell contents.
When you move or copy data in a cell, the formats are also moved or copied.Formatting Cell Contents (continued)
By default, Excel aligns text at the left of the cell and numbers at the right side of the cell.
You can also center cell contents.
You can adjust vertical alignment to top, middle, and bottom.
Buttons for these and other settings are available in the Alignment group on the Home tab.Formatting Cell Contents (continued)
Formatting Numbers and Dates: appears.
Numbers are displayed with no formatting and are aligned at the right side of a cell.
Dates are automatically formatted in the default styles (such as 20-Jan-12).
Change the format of number data using the options from the Number group on the Home tab.Formatting Cell Contents (continued)
Adding Shading and Borders: appears.
Emphasize important information in a cell, a row of cells, or a column by applying color, shading, or border formats.
Use the Format Painter to copy the format of a worksheet cell without copying the contents of the cell.Formatting Cell Contents (continued)
Applying Styles: appears.
A cell style is a set of predefined formats you can apply to some of the worksheet data, such as a header row or a cell showing a total.Formatting Cell Contents (continued)
Applying Styles (cont): appears.
A table style is a set of predefined formats that you can apply to all worksheet data with a single click.
When you apply a table style, the selected cells are converted to an Excel table.
You can choose from more than 60 table styles in the Quick Styles gallery.Formatting Cell Contents (continued)
To sort worksheet data, you must indicate the column on which you want to base the sort.
You can base the sort on data in as many as three different columns.Sorting and Filtering Data
In addition to sorting data, you can filter worksheet data. which you want to base the sort.
When you filter data, you screen data that matches specified criteria. The data that does not meet the criteria are hidden, and only the data that meets the criteria will show.Sorting and Filtering Data (continued)
Changing the Page Setup: which you want to base the sort.
Page Break Preview view will show exactly how the worksheet will print.
Excel determines where to break a page and begin a new one.
You can create your own page break by dragging the page break to a new location.Formatting the Page Layout
Changing the Page Setup (cont): which you want to base the sort.
Sometimes changing the page orientation will fit all the worksheet data on one page.
Another option for fitting the worksheet on one page is to use the Fit to command.Formatting the Page Layout (continued)
Adding a Header and a Footer: which you want to base the sort.
Headers are printed in the top margin of every page; footers are printed in the bottom margin.
You can choose from built-in headers or footers which are constructed using fields to insert dates, times, and page numbers automatically, or you can create headers and footers manually by inserting these fields yourself.Formatting the Page Layout (continued)
If you don’t want to print the entire worksheet, you can identify a range that you want to print before you choose the print command.
You can print the row and/or column headings on every page.
Change print settings on the Page Layout tab.Customizing Print Options
In this lesson, you learned: