Back to School Sale -
20% off all courses with code BTS2019
Search for courses or lessons
Redeem a coupon
Start free trial
Suppose you want to center the title you have in cell A6 over the data table in A7:G40. Which method is the best?
Select cells A6:G6 and click the “Merge and Center” button on the Home tab
Select cells A6:G6, right click, choose Format Cells, and set the horizontal alignment to “Center Across Selection”
Select A6:G6 and click the Center icon on the Home tab
Suppose you have selected columns B:E and you want them resized to fit your data without excess space. Which method is the most efficient?
Double click on any line between the column labels
Select each column individually and resize them one at a time
Right click the column header and select “Shrink to Fit”
Suppose cell A10 contains text and you want to display it rotated on its side and centered vertically over A10:A20. Which method is the best?
Select cells A10:A20 and select the Merge and Center button
Select cells A10:A20, rotate the text 90 degrees and select Center Across Selection
Merge cells A10:A20, rotate the text 90 degrees and select Center Vertically