If you’re working on a huge spreadsheet which contain a lot of data sets, you may want to zoom-in selected area to focus on single data set. Excel 2010 offers Zoom-In selected area option which can help you edit the content easily without having to adjust the screen manually.
For zooming-in only the selected range, select the data range and head over to View tab, under Zoom group, click Zoom to Selection.

Upon click It will instantly zoom-in the selected range.

Advertisement


