About ITIT for StudentsIT for FacultyIT for StaffServicesHelpDocumentationIT Home

Technology Tip of the Week - December 4, 2006
 

Excel Tips

Inserting a Line Break in a Cell

Did you know that you can insert a line break in a cell just like you can insert one in a Word document? You know that if you hit the Enter key while typing in a cell in Excel, the program bounces you down to the next row - not the next line within the cell. Frustrating! In the past, every time I wanted more than a single line while I was typing in a cell I would type the whole line and then then go into Format-Cell and set the alignment to Word Wrap. Then I'd adjust the width of the column so that the lines were forced down to where I wanted them. This wasn't the easiest solution but it worked in a clunky way. Well, then I discovered this handy tip!

To insert a line break in a cell

Moving through Multiple Worksheets in a Workbook

Most of you probably already know about using the keyboard shortcut ALT+TAB to move between open programs in Windows - for example if you have Word, PowerPoint, and Excel all open, ALT + TAB will switch you back and forth among them. (If you haven't tried this, do so now — it's a great Microsoft Windows® trick.)

However, this doesn't work when you're moving between worksheets in the same workbook. Don't despair; there are a couple of neat little shortcuts that handle the job quite nicely.

If you want to move one worksheet to the right

If you want to move one worksheet to the left

Now you can skip through those worksheets with lightning speed and amaze your friends and coworkers (if they're the type to be amazed by that sort of thing, of course)

Making Individual Worksheets Stand Out in a Workbook

If you end up with multiple worksheets in a workbook and you want a way to make them easy to identify here are two suggestions:

Wow! You look soooo organized!

For more help with these features, please contact one of the IT Instructional Support team (Norm Grant, Gene Grande or Linda Beith) or faculty mentors Tony Basilico or Kathy Beauchene.

Website of the Week

Tech'ing It to the Next Level at MIT

Our winter break is fast approaching and if you find you have a little time on your hands once classes have ended, you may be interested in this special exhibit featured at the Massachusetts Institute of Technology's Museum. It's called Tech'ing It to the Next Level and provides an opportunity for educators to learn about integrating cutting-edge technologies into the classroom and other learning environments. Tech'ing It to the Next Level is a multi-disciplinary, interactive exhibition of tools and innovations developed by MIT researchers in the iCampus program, which has sponsored more than 50 faculty and student projects. For more information on this exhibit as well as the Museum's hours and directions, see: http://web.mit.edu/museum/about/news/teching.html. Hurry though, the exhibit is only there through December.

Feel free to post your thoughts or opinions of this site in the Teaching Forum message board.

These tips are provided by the Department of Information Technology instructional support team. If you have any questions on these tips, or wish to offer your own, please feel free to contact Linda Beith at lbeith@ccri.edu or call 825-2487. View an archive of past technology tips at http://it.ccri.edu/Training/Tips/tip_week.shtml.

Go to top of page