Search results
Results from the WOW.Com Content Network
By default, Microsoft Excel prints worksheets in portrait orientation (taller than wide). You can change the page orientation to landscape to print it sideways.
Repeat specific rows or columns on every printed page. Applies To. If a worksheet spans more than one printed page, you can label data by adding row and column headings that will appear on each print page. These labels are also known as print titles.
You can convert the table to a range first, or you can use the TRANSPOSE function to rotate the rows and columns. Here’s how to do it: Select the range of data you want to rearrange, including any row or column labels, and press Ctrl+C.
If your worksheet has many columns, you may need to switch the page orientation from portrait to landscape. To do this, go to Page Layout > Page Setup > Orientation , and click Landscape . Consider using a larger paper size to accommodate many columns.
Create a Map chart with Data Types. Map charts have gotten even easier with geography data types. Simply input a list of geographic values, such as country, state, county, city, postal code, and so on, then select your list and go to the Data tab > Data Types > Geography.
Orientation Choose between landscape and portrait. Scaling Enlarges or reduces the worksheet or selection when you print so that it fits on the specified number of pages. Adjust to When you select Adjust to , you can enter a percentage in the % normal size box.
To quickly specify the orientation of the printed pages, on the Page Layout tab, in the Page Setup group, click Orientation, and then click Portrait or Landscape.
Go to Insert > Header & Footer. Excel displays the worksheet in Page Layout view. To add or edit a header or footer, select the left, center, or right header or footer text box at the top or the bottom of the worksheet page (under Header, or above Footer). Type the new header or footer text. Notes:
To change the layout of a PivotTable, you can change the PivotTable form and the way that fields, columns, rows, subtotals, empty cells and lines are displayed. To change the format of the PivotTable, you can apply a predefined style, banded rows, and conditional formatting.
You can create basic flowcharts, cross-functional flowcharts, and organizational charts. The diagrams are drawn automatically from data in an Excel workbook. If you then edit the diagram in Visio, your changes are synced back to Excel. This means you don't need a Visio subscription to make stunning diagrams in Excel.
You can change the font, style, and size of the headers and footers that you want to print with along with contents of your worksheet. Also, there are options you can configure to ensure that the header and footer font size settings don't change when you scale the worksheet for printing.