Page 156 - Excel 2013 All-in-One For Dummies

138 Adjusting Columns and Rows
clicking a single cell anywhere in the worksheet or by dragging through a particular cell range that you want to work with.
Keep in mind that when you hide a column, the data in the cells in all its rows (1 through 1,048,576) are hidden (not just the ones you can see on your computer screen). This means that if you have some data in rows of
a column that need printing and some in other rows of that same column that need concealing, you can’t use the Hide command to remove their dis- play until you’ve moved the cells with the data to be printed into a different column. (See Book II, Chapter 5 for details.)
Rambling rows
The controls for adjusting the height of the rows in your worksheet paral- lel those that you use to adjust its columns. The big difference is that Excel always applies AutoFit to the height of each row so that even though you find an AutoFit Row Height option under Cell size on the Format button’s drop-down menu, you won’t find much use for it. (Personally, I’ve never had any reason to use it.)
Instead, you’ll probably end up manually adjusting the heights of rows with the mouse or by entering new height values in the Row Height dialog box (opened by choosing Row Height from the Format button’s drop-down menu on the Home tab) and occasionally hiding rows with sensitive or potentially confusing data. Follow these instructions for each type of action:
✦ To adjust the height of a row with the mouse: Position the mouse on the lower edge of the row’s border in the Row header and then drag up or down when the mouse pointer changes to a double-headed, verti-
cal arrow. As you drag, a ScreenTip appears to the side of the pointer, keeping you informed of the height in characters and also in pixels. (Remember that 15 points or 20 pixels is the default height of all rows in a new worksheet.)
✦ To manually adjust the height of a row by touch: Tap the lower edge of the row border with your finger or stylus to select the row and make the black, double-header pointer appear. Then swipe the pointer up or down as needed. As you swipe, the Name box on the Formula bar indicates
the current row height in characters and pixels. When you have the row adjusted to the desired height, remove your finger or stylus from the touchscreen.
To make this operation easier, remember that you can instantly zoom
in on the row border by stretching your forefinger and thumb on the touchscreen — doing this makes the row number area larger, making it a lot easier to tap and swipe the border up and down with your finger or stylus.