Pick the print option you want to preview and click Print. The areas with borders will now appear with darker lines. To see the print preview, click on Print tiles in Page Setup group. On the Hometab, in the Fontgroup, click Borders> All Borders.From the drop down list, select Set Print Area.Go to Page Layout tab, select Print Area in the Page Setup group.To print the filtered area, follow below given steps:. Only selected date’s related data will appear.If you want to put the data as per date.Pick the sheet from the drop-down list where you want to change the grid lines color. Scroll down to Display options for this worksheet. Select the Advanced category on the left pane of the Excel Options window. Press the key Ctrl+Shift+L on your keyboard. Choose Options from the FILE menu to open the Excel Options dialog.To print the filtered data, we have to put the filter in data Column A contains Date, column B contains Agent name and column C contain Revenue amount. Let’s take an example to understand how we can print a filtered list. Shortcut Key:- Press Ctrl+Shift+L on your keyboard.
This option is available in the Data Tab under the Sort & Filter group. Even we can sort the data as per the number, text, cell colors, and font colors, etc. We can filter the data according to the particular text, month, date, number, cell color, font color, etc. To Printing a filtered list, we will use the Auto filter option and Print option in Microsoft Excel 2010.Īuto Filter: - This option allows us to filter the data based on content of cells and conditions applied on them.
0 kommentar(er)
