Cells, Rows, and Column Formatting
From the Home Ribbon, you can format the font, number, alignment, border, pattern, and protection of your cells, rows, and columns.
You can also click on the Expand icon to open the traditional Format Cells dialog box that contains tabs for these various categories.
Just as the Home Ribbon provides you with the options that used to be only accessible in the Format Cells dialog box, the Page Layout Ribbon gives you access to features that used to be in the Page Setup dialog box (click on the Expand icon to access that traditional dialog box).
In the Page Setup Group, you canset the margins, orientation, and print area. Note that the Print Titles icon evokes the Page Setup dialog box, and that in this instance Print Titles refers to the row and column headings (e. g., A, B, C, 1, 2, 3, etc.) not the sheet‟s headers and footers. With the Page Setup dialog box open, you can click on the Header/Footer tab to change them. You can also access the headers and footers on the Insert Ribbon.
You can change a column's width by putting your cursor between the letter for that column and the next. When you get the two-headed arrow, drag to the right or left as desired.
Resizing Columns and Rows
Double-clicking on that same spot will “autofit” the column, making the column as wide as the largest piece of text/data in that column.
The same technique works for rows; put your cursor between the two numbers until you see the two-headed arrow, and then drag or doubleclick.
Hiding Rows and Columns
To hide a column or row, right-click on the letter or number for the column or row (A, B, C, etc. or 1, 2, 3, etc.) and select Hide.
To unhide a column or row, select the columns or rows before and after the missing column or row, right-click, and select Unhide.