[discussion_vu] [Tips for Computer] How to customizing your workspace in Microsoft Excel?

Change default worksheet options.
By default, Excel includes three worksheets in a new workbook. But if most of your users rarely use more than one worksheet per workbook, you can prevent Excel from generating the two extra worksheets.

Follow these steps:
1. Go to Tools | Options.
2. On the General tab, set the value in the Sheets In New Workbook box to 1, and click OK.

The next time you create a new workbook, it will have only one worksheet. You can also increase the number of sheets per workbook.

You can also use the Options dialog box to change the worksheet's default font. For example, to change the default font from Arial 10 to Times New Roman 12, follow these steps:

1. On the General tab, select Times New Roman from the Standard Font drop-down list.
2. Select 12 from the Size drop-down list, and click OK.

You must restart Excel for your font changes to take effect.

Opening multiple windows.
One of the most frustrating problems for Excel users is viewing all the information they need, especially because it often lives in different worksheets. Let your users know about this simple way to view multiple sheets, and they'll love you forever.

1. Click on the tab of the worksheet you want to view.
2. Choose New Window from the Window menu.
3. Repeat this process for each of the worksheets you want to display. (Excel opens each sheet in a window that sits on top of the previous one.)
4. To see them all at one time, choose Arrange from the Window menu.
5. Select Tiled, Horizontal, or Vertical.
6. Select the Windows Of Active Workbook check box.
7. Click OK.

Creating a workspace in Excel.
Often, your users will be working with several workbooks at a time. They will be happy to know that they can arrange the workbooks, save them as a workspace, and then open everything at once in the viewing configuration they prefer. Here's how:

1. With all the workbooks in the preferred positions, go to the File menu.
2. Choose Save Workspace.
3. Type a name for the file.
4. Click Save.

The next time your users want to work with those workbooks, they can go to File | Open and select their workspace.

--
Posted By Blogger to Tips for Computer at 2/20/2012 02:14:00 AM

--
You received this message because you are subscribed to the Google Groups "Virtual University of Pakistan" group.
To post to this group, send email to discussion_vu@googlegroups.com.
To unsubscribe from this group, send email to discussion_vu+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/discussion_vu?hl=en.