Easily add and print title/header row to each page easily with Kutools for Excel. Print title on every page repeatedly with Kutools for Excel. Print title on every page repeatedly with Print Titles feature. Actually, we can specify the Page Setup settings, and print the title (top row) on every page repeatedly.
![]() Quick Access toolbar – Includes the File button, which contains commands to open a new, recently used, or saved workbook the toolbar also has Save, Undo, and Redo buttons Menu bar – Access most of Excel’s tools either through these menus or the Ribbon The first row frequently contains titles for the columns of data below it these titles are called “column headings,” and are often formatted differently than the rest of the data in order to differentiate them.In Excel, each spreadsheet page is called a “worksheet,” and a file containing one or more worksheets is called a “workbook.” By default, worksheets have the name “Sheet1,” “Sheet2,” etc., but it’s a good idea to rename your worksheets to reflect the data they contain.The top of an Excel worksheet contains several toolbars, and each toolbar contains its own set of tools.Here are the toolbars for Excel 2016 for Mac:(If you use a different version of Excel, some of your options may appear in a different order or format.) In the image below, the selected cell would be called “cell B2.”Typically, data records are entered into the rows of Excel, with similar data for each record being organized into columns. The RibbonThe Ribbon is the go-to toolbar for all your data manipulation needs. Ribbon – Excel 2013 for PC doesn’t include the Menu bar, and instead relies on the Ribbon for nearly all of its functionalityFile tab – Unique to the PC version of Excel opens a separate window that includes commands to open a new workbook, print a worksheet, and access Excel preferencesData tab – Contains commands such as Sort and FilterNote: Versions of Excel not shown here may display options in a different order or format, but the functionality is the same. Quick Access toolbar – Contains Undo, Redo, and Save buttons Formula bar – Use to view and edit the formula in a selected cellHere are the toolbars for Excel 2013 for PC: A few examples include:Home tab – Contains tools for formatting cellsFormulas tab – Lists the different functions in Excel by typeData tab – Contains such commands as Sort and Filter In Excel Make Top Row Repeat On Each Printed Page How To Use TheIn the following activities, explore how to use the Ribbon’s Home tab, as well as the Format Cells window, to change the appearance of your data. Formula Builder (accessed by clicking Insert Function)Tools for analyzing and manipulating data on the worksheetTools for checking, protecting, and commenting on dataOptions regarding how the worksheet appears and acts on the screenUsing Excel’s default formatting is fine, but to create professional-looking worksheets that clearly present your data, you’ll need to apply some custom formatting. Rows and columns to repeat on each pageTools and options surrounding the building of formulas Tab Name(Unique to the PC version in the Mac version, the commands on this tab appear in the Excel and File menus of the Menu bar)Commands that create or affect Excel files as a wholeFormatting tools used to alter the appearance of your dataOptions for objects that can be inserted into your worksheetOptions that affect what the worksheet will look like when it is printed Take a look at the table below to review each of the tab names, brief descriptions of each tab, and some of the most frequently used tools that each tab contains. You’ll adjust the column widths to fit the values in a later activity.Increase the size of your column headings to make them easier to read.4. Make the column headings bold by clicking the Bold button in the RibbonYou may notice that many of the column headings, as well as many of the data values don’t fit in their cells. Select all the cells in the first row, which contains your column headings, by clicking the row number 13. The worksheet is functional as it is, but could use some formatting adjustments to make it appear professional and easy to read.Make your column headings stand out by bolding them.2. With the Excel_Basics.xls activity file open, select the PowerSchool Export worksheetData that is exported from PowerSchool will typically look a lot like this when opened in Excel. Download geckodriver for firefox for macClick cell A1 and press Command + Shift + the right arrow(Control + Shift + the right arrow on a PC)7. Click cell A1, press and hold the Shift key, and then click cell M1 Click and drag your cursor from cell A1 to cell M1 Since only the cells containing the column headings should have color added, rather than the entire first row, select only the cells in the first row that contain text this can be done in one of three ways: Click the Save button at the top of the window to save your workActivity 2 –Using the Format Cells Window to Apply FormattingAnother way to apply formatting to your data is to use the Format Cells window. With the column headings still selected, click the Center Align button in the Ribbon10. Select a color from the color options (preferably a light color so the black font will be legible)Center the column headings within their cells.9. Under Presets, select both Outline and InsideNotice that under Border, a preview of the borders appears. In the Line Style area, select one of the solid line options5. In the Format Cells window, select the Border tab4. With your column headings still selected, right-click any of the selected cellsAlternately, on a Mac, press and hold Control and left-click any of the selected cells.3. You may notice that the headings that don’t fit in their cells don’t have complete borders.
0 Comments
Leave a Reply. |
AuthorJeff ArchivesCategories |