New Views for Excel - Tech Learning

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
Author:
Publish date:

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 Ctrl and ~ (tilde)

Filling Across the Cells

  • Select all the cells you want to fill.
  • Type in the active cell.
  • Press Ctrl and Enter.

Change the Default Font

  • Go to the Tools menu to Options to General tab.
  • Use the pull-down menu next to "Standard font" to select the font name and size/.
  • Click OK.
  • Restart Excel in order for the change to take affect.

See as Much as You Can

  • Go to the View menu to View Full Screen to squeeze more data onto the screen even if you already have Excel maximized.
  • Click Full Screen again to restore window view.

For more tips on Excel go to http://www.uky.edu/IS/Training/tipsexcel.html

Submitted by:Barbara Bray

Next Tip: Limited Technology

Featured

Related

New Views for Excel(2)

Tip: Teachers need help in managing students with only one or few computers available in their classrooms. Some strategies that you can offer your teachers: Create multiple activities with stations. Consider small groups of students rotating through the stations for a limited time doing research: one station with

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

PowerPoint Presenter View: Tools for Speakers

I need to make a presentation to the school board. I’ve heard there’s a way I can view my speaker’s notes during a PowerPoint presentation, but I can’t figure out how to do it. Do you know? If you are using PowerPoint 2002 or later, you can set your presentation to run on two monitors: one monitor will

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

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.

Image placeholder title

Awards of Excellence.

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

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

Image placeholder title

Product: Mobi View

When combined with a projector, Mobi View, the latest mobile interactive whiteboard from eInstruction, can turn any wall into an interactive teaching display.

Image placeholder title

Awards of Excellence

123D Circuits lets students design and simulate circuits in a collaborative online environment, where several users can work on the same projects simultaneously.