DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
File
|
|
|
Home
|
|
|
Review
|
|
|
View
|
Detailed explanation-1: -Click the worksheet for which you want to change the printing order. next to Page Setup. Click the Sheet tab, and then under Page order, click Down, then over or Over, then down.
Detailed explanation-2: -Select File > Print, or press CTRL+P. Select the Print button or adjust Settings before you select the Print button.
Detailed explanation-3: -On the Review tab, click Protect Sheet. In the Allow all users of this worksheet to list, select the elements you want people to be able to change.
Detailed explanation-4: -You also learned that there are seven major settings that can be modified to help change the layout of your printout, which included the page orientation, margins, and scaling. It may take a bit of practice, but next time you need to print from Excel, remember to preview and adjust your settings.
Detailed explanation-5: -To print the entire workbook, before you click Print, under Settings, click the arrow next to Print Active Sheets, click Print Entire Workbook.