Browse » Home
Sunday, September 16, 2012
How to Set a Fixed Height Width in Excel
1. Open the Microsoft Excel 2010 file with which you want to work.
2. Click and hold the mouse button on the row number or column letter that you want to adjust to a fixed height and width. Then drag the mouse to select the adjacent rows or columns. You can then press 'Ctrl' and click to select nonadjacent columns or rows. If you want to change the height and width of the cells for the entire spreadsheet, just click the box to the left of 'A' and just above '1.'
3. Click the 'Home' tab at the top of the screen. Locate the Cells area of the Ribbon and click on the 'Format' button found there.
4. Choose 'Row Height' from the menu, and a small window appears. Type the value for your desired row height and click 'OK.'
5. Click the 'Format' button again and choose 'Column Width' from the menu. Enter your desired column width into the small window that appears and click 'OK.' Your column width and row height are now set.