- Entering Data and Making Changes
- Entering Data
- Editing and Deleting Existing Data
- Zooming Into Your Data
- Undoing and Redoing Changes
- Copying and Pasting Data
- Freezing Rows and Columns
- Splitting a Worksheet
- Inserting Cells
- Deleting Cells
- Inserting and Deleting Rows
- Inserting and Deleting Columns
- Moving Data
- Finding Data
- Replacing Data
- Applying a Data Filter
- Sorting Data
- Adding and Managing Cell Comments
This chapter is from the book
This chapter is from the book
This chapter is from the book
Zooming Into Your Data
If you want to zoom in and get a closer look at data in your worksheet, you can select a higher percentage of magnification. On the other hand, if you want to zoom out so more of the worksheet shows on the screen at one glance, select a lower percentage of magnification. Excel 2010 provides several ways to zoom in and out.
)
Slide the Zoom Slider on the lower-right corner of Excel. Watch your worksheet increase and reduce in magnification as you slide.
Select a Range and choose the Zoom to Selection command on the View tab. Note how Excel automatically increases or reduces magnification so that only that selection is visible.
Select the Zoom command on the View tab, then choose your desired magnification. After you click the OK button, observe how Excel applies your zoom preference.
Tip: Zoom with your Mouse Wheel
You can use your mouse wheel as another quick way to zoom. Hold down the Ctrl key on your keyboard while you spin your mouse wheel. This increases or reduces magnification depending on the direction you spin (up or down).