When Data is large we may need to remember the range within which our required data is located. To avoid this inconvenience Microsoft Excel has a feature to save the data as a separate workspace. We can open the data directly when we open the workspace directly.
Steps to save the work space in Excel 2010:
1) Select the data range which has to be saved and has to be opened directly on that particular worksheet.
2) Go to View Menu and click on Save workspace.
3) It will ask us to give a name to that part of worksheet.
4) Once it is saved and reopened, the cursor show the saved space but not the row 1 and column A.
This helps us in saving time for navigating the worksheet for the required data. This is possible in all the latest versions of Excel 2003, 2007, 2010.
0 comments:
Post a Comment