Saturday, January 12, 2013

How to Increase the Height of a Row to Pixels in Excel 2007


1. Open an Excel spreadsheet. You will see on the left side of the spreadsheet that the rows are numbered (1, 2, 3, etc.).
2. Place the cursor on the line under the row you want to increase the height of. For example, if you want to increase the height of row 2, place the cursor on the line between row 2 and row 3. Note that the cursor changes from the usual arrow to what looks like a plus sign ( ).
3. Click your mouse and while continuing to hold it down, drag the row to increase (or decrease) to the height you want. When you click your mouse on the line between rows, you will see a small dialogue box appear that will say 'Height: 20.25 (27 pixels)'--or whatever height the row is.
4. To increase the height of several rows at once and to ensure they are all exactly the same size, place the cursor over the number of the first row in your selection. You will see that the cursor is now a black arrow. Do not place the cursor on the line as you did in Step 2.
5. While holding down the mouse, drag it to select as many rows as you want. Now perform Step 2.

Blogger news