tailieunhanh - Office 2010 visual quick tips phần 4

tùy chọn (thay đổi). Chọn tiêu chuẩn để in, hoặc kích cỡ tối thiểu cho việc xuất bản trực trình Xuất bản dưới dạng PDF hoặc XPS hộp thoại sẽ mở ra với các định dạng tập tin PDF được lựa chọn theo mặc hoặc XPS, bấm vào đây và chọn kiểu tập tin chính xác. | Chapter 5 Optimizing Excel Caution Designate a Startup File o Click the File tab. 2 Click Options. The Excel Options dialog box appears. 3 Click Advanced. 4 Scroll down to the General settings. 5 In the At Startup Open All Files In field type the folder path to your alternate startup folder. Note Be sure to type in the full folder path accurately or Excel cannot locate your file. 6 Click OK. The next time you open Excel the designated file opens too. Note To remove a startup file repeat these steps and delete the path found in the Excel Options dialog box. More Options If you use Excel every day you can tell your computer tO open the program automatically When you turn on your computer. You can place a shortcut to the Excel program in your Windows XP WindoWs Vista or Windows 7 Startup folder. Look up your system s Startup folder and place a shortcut to Excel in the folder. If you ever run into trouble with automatically launching a workbook such as a system crash you may have to visit the Advanced resources and enable the workbook startup again. Click the File tab and click Options to open the Excel Options dialog box. Click Advanced and check the folder path in the General settings. If you accidentally moved the file you may need to fix the designated path listed. 1Õ1 Automate Data J Entry with AutoFill Often the data that needs to be entered into an Excel worksheet is part of a series or pattern. In that case you can use Excel s AutoFill feature to automate data entry. For example you might type the word Monday in your spreadsheet and then use AutoFill to automatically enter the remaining days of the week. Alternatively you might type January and then use AutoFill to enter the remaining months of the year. In addition to automating data entry using predefined data lists such as the ones described in the preceding paragraph you can create your own custom data lists for use with Excel s AutoFill feature. For example you might create a custom list that includes the