Most people who use Excel stumble across the fact that you can increase or decrease the size of a document. A little less known tip is that you can also magnify a single or set of cells, as opposed to an entire document. For example, if you’re working on a table, you can zoom in on just the cells containing the table.
To magnify a group of cells in Excel 2007, begin by selecting the cells you want to magnify. Next, select View on the Ribbon and select Zoom to Selection. Excel magnifies that cells you selected. To return the cells to their normal size, click 100%.