Back to lesson
1. 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, 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.
Select cells A6:G6 and click the “Merge and Center” button on the Home tab.
2. 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?
Right click the column header and select “Shrink to Fit”.
Double click on any line between the column labels.
Select each column individually and resize them one at a time.
3. 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?
Merge cells A10:A20, rotate the text 90 degrees and select Center Vertically.
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.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement