From the course: Excel 2016: Tips and Tricks
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Zoom in and out quickly
- [Voiceover] As you work with Excel data, there will be times when you want to zoom in on the data, make it larger on your screen, perhaps somebody's looking over your shoulder in the good sense and needs to see this larger than it currently is. At other times, you might want to zoom back to see more of the worksheet. And in the lower right-hand corner, there certainly is a standard way to do this. There's a slider bar, and you've got to put the mouse right on that bar, move it left or right to zoom in and out. And that's reasonably fast. To the right you see a percentage number, usually you don't care about that too much, but sometimes you use it as a reference point to zoom in and zoom out. But you do have to position the mouse. Now, with no concern whatsoever as to where the mouse is pointing, even up on at the menu or up at the very top of your screen, if you hold down the Ctrl key and use the mouse wheel, you will zoom in or out as needed. Simply Ctrl with the mouse wheel. As…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
Enter data or formulas in nonadjacent cells simultaneously3m 17s
-
Copy data or formulas down a column instantly2m 49s
-
Instantly enter today's date or time3m 20s
-
Convert formulas to values with a simple drag5m 4s
-
Adjust all or selected column widths or row heights in a flash4m 43s
-
Display all worksheet formulas instantly3m 30s
-
Create charts instantly with either of these keystroke shortcuts2m 54s
-
Display Print Preview instantly2m 25s
-
Undo, redo, and repeat with keystrokes3m 53s
-
Zoom in and out quickly3m 23s
-
-
-
-
-
-
-
-
-
-
-
-
-
-