Office challenge: How can you view formulas and results for a range at the same time?

This week's Microsoft Office Challenge: How can you view both formulas and the results of those formulas on screen?

Recently, I found a colleague bent over a printout of formulas, bobbing his head up and down from the printout to the screen. He was auditing formulas in the printout and comparing those formulas to the results of each on screen. He didn't need the printout at all—not to mention the crick in his neck the chore gave him. How can you view both formulas and the results of those formulas on screen?

Last week, we asked…

What's the quickest way to copy the contents of the active cell to the other cells in the selected range? Len222 responded with a couple of helpful keystroke combinations:

  • [Ctrl]+D: Copy from the anchor cell down to selected cells.
  • [Ctrl]+R: Copy from the anchor cells to selected cells to the right.

Both keystroke combinations are more efficient than the more commonly used shortcut of pressing [F2] and then pressing [Ctrl]+[Enter]. You can still use the [F2] combination to copy up and to the left (unless someone knows a shorter shortcut). Thanks Len222 for a great solution to this week's Office challenge!

TechRepublic's Microsoft Office Suite newsletter, delivered every Wednesday, is designed to help your users get the most from Word, Excel, and Access. Automatically sign up today!

By Susan Harkins

Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.