FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -When you select one or more sheets and then click File > Print, you’ll see a preview of how the data will appear on the printout. Select the worksheet(s) you want to preview. Click File, and then click Print to display the Preview window and printing options. Keyboard shortcut You can also press Ctrl+F2.

Detailed explanation-2: -Switch the view that shows all the worksheet elements as they will print, including headers and footers. Click the Page Layout button at the lower right corner of the status bar, to the left of the zoom slider.

Detailed explanation-3: -Changing the column width in Excel automatically You can quickly adjust the column width to accommodate the longest entry. Select any column from the worksheet. From the Cells group on the Home tab, choose Format. Select AutoFit Column Width to set that column to auto-fit the width depending on the contents.

Detailed explanation-4: -The Fill Handle is the small green square located in the bottom right corner of your selection-be it one cell or a larger group of cells. Double-clicking the Fill Handle causes the selected text, formula, or data to be copied downward, with different behaviors resulting depending on the contents of the cell.