DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
shrink
|
|
|
size
|
|
|
scale
|
|
|
scroll
|
Detailed explanation-1: -Click the Page Layout tab on the ribbon. In the Scale to Fit group, in the Width box, select 1 page, and in the Height box, select Automatic. Columns will now appear on one page, but the rows may extend to more than one page.
Detailed explanation-2: -Make all rows same height or columns same widths with Format command. With the Excel’s Row Height and Column Width functions, you can quickly format all the column width or row height have the same size. icon at the top left corner of the worksheet to select the whole worksheet.
Detailed explanation-3: -Click the sheet. On the Page Layout tab, in the Page Setup group, click Page Setup. Under Print Titles, click in Rows to repeat at top or Columns to repeat at left and select the column or row that contains the titles you want to repeat. Click OK.