PxPixel
Excel Shortcuts - Tech Learning

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

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 date and time, click CTRL and ; then put a space, then click CTRL plus Shift plus ;

Fred Mindlin shared a printing tip:

When printing an Excel document on the Mac, go to page setup and select "fit to one page." This is especially helpful since we use so many highly formatted forms, and it will avoid the chopped up printouts we sometimes get from these.

Barbalee Blair has a quick way to format cells:

The usual method, using control-enter to allow more text to show than fits in cells, should work, but if there are many such cells, it takes too long! My favorite with Excel is using word wrap on whole groups of cells. After selecting the group, click ctrl + 1 to open the formatting dialogue. From there, the alignment tab gives you the ‘word wrap’ option. It’s great!

Submitted by:Barbara Bray

Next Tip: Change the Font Size in Microsoft Word

Featured

Related

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

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.

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

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.

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

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.

Image placeholder title

Awards of Excellence Winners 2008

NEW AWARDSAdobe Visual Communicator 3Adobe Systems IncorporatedAlthough Visual Communicator isn't for beginners, older middle schoolstudents and teachers with some computer experience will appreciatethe program's ease of use, intuitive interface, and quality presentations.The program is great for classroom use, and one

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