Back to lesson
1. You want to center the title you have in A6 over the data table in A7:G40. What is the best route to do this?
Select A6:G6 and click the Center icon on the Home tab
Select A6:G6, right click, choose format cells, and set the horizontal alignment to “Center Across Selection”
Select A6:G6 and click the “Merge and Center” button on the Home tab
2. Assuming that you’ve selected columns B:E and you want them resized to fit all of your data without excess space. What is the most efficient way to do this?
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”
3. Assume that you have data in A10 and you want to display it rotated on its side and centered vertically over A10:A20. What do you need to do?
Select A10:A20, rotate the text 90 degrees and select to Center Across Selection
Merge A10:A20, rotate the text 90 degrees, and select to center vertically
Select A10:A20 and select the Merge and Center button
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement