Useful Excel Tips - Tech Learning

Useful Excel Tips

Tip: Freeze Panes When you scroll far enough down in a spreadsheet you will eventually lose sight of the header row(s). To show your header row (column titles) or any number of other rows at the top of the screen regardless of how far you scroll down: Highlight the row UNDER the last row you want showing by
Author:
Publish date:
Social count:
0

Tip:
Freeze Panes
When you scroll far enough down in a spreadsheet you will eventually lose sight of the header row(s). To show your header row (column titles) or any number of other rows at the top of the screen regardless of how far you scroll down:

  • Highlight the row UNDER the last row you want showing by clicking the row number.
  • Click on Window in the menu bar.
  • Choose "Freeze Panes".

To return to traditional scrolling,

  • go back to the Window menu.
  • choose "Unfreeze Panes" (you can be anywhere in the spreadsheet this time)

Print Header Row
Suppose you have a three-page printed-out spreadsheet, but the headers appear only on page 1, meaning you have two pages of unlabeled data. To correct this and print the header row on every page, do this:

  • Go to File to Page Setup.
  • Choose the Sheet tab.
  • Click on the box with the little red arrow in the blank field next to "Rows to repeat at top" (or in the blank field itself)
  • Click the row number you want showing at the top of each page; you should see a formula show up in the field)
  • If you clicked the red arrow box, click it again to bring back the dialog
  • box, click Print Preview to check your work, and click OK.

Bonus: If you just need to print the column and row headers (letters and numbers), click the check box next to that option in the Page Setup--> Sheet dialog.

Submitted by: Yiftach Levy
Information Technology Consultant
San Diego State University
ylevy@mail.sdsu.edu

Featured

Related

Excel Text Tips

Tip: I love word wrapping, but a fine way to format your text in Excel is to: Choose alignment Orientation And vertically change the direction of text. This is useful in a document where you are trying to have several headings across the page, as in a grade book, attendance sheet, etc. but using standard

Excel Shortcuts

Tip: Inserting Time and Date Setting up worksheets to use with your teachers? There are shortcuts in Excel or Access that can have the time or dates automatically show up. To show the current date, click Control (CTRL) and ;(semicolon) To show the current time, click CTRL and Shift and ; To have both

Excelets: Excel's Excellent Adventure

from Educators' eZine --> If you have numerical data of any variety, Microsoft Excel is a great way to plot a graph – be it a Bar Graph, Pie Chart, or Scatter Plot! Excel's next capability is to develop a mathematical model

Image placeholder title

Awards of Excellence.

Calling a piece of technology for the classroom a “solution” is easy. Proving it? That can be hard.

New Views for Excel

Tip:When you are showing how to use Excel, you can change the views so your teachers can see just what you want to show them. Changing page breaks in a worksheet: Go to the View menu to Page Break Preview. Drag the page breaks to where you want them. Click OK and go to View to Normal view. Viewing Formulas Press

Image placeholder title

Awards of Excellence

This system allows users to collaborate with other schools, go on virtual field trips with a class, and access new content.

Awards of Excellence

from Technology & Learning A Tradition of Excellence When T&L ran its first Awards of Excellence program back in 1982, Seymour Papert's Logo programming language was all the rage, and Classroom Computer News (this magazine's birth name) was printing pages of code for those early adopters in schools eager

Awards of Excellence 2005

Now in its 23rd year, Technology & Learning's Awards of Excellence program honors the best in educational applications and solutions for the K-12 market. Ranging from scientific probeware to network management tools, and from writing assessment to professional development offerings, this year's winners are an