Page 177 - CA 165 ver 1.0 Class 9
P. 177
Other Shortcut Keys
The other shortcut keys required to work in Calc are:
Purpose Action Required
To Open a New Workbook Press Ctrl+N
To Save an existing Workbook Press Ctrl+S
To Save a New Workbook Press Ctrl+Shift+S
To Close a Workbook Press Ctrl+W
To Exit from Spreadsheet Press Ctrl+Q
To Open an Existing Workbook Press Ctrl+O
To Print a Sheet Press Ctrl+P
SAVING A WORKBOOK
If a workbook is saved for the first time, it must be assigned with a new file name. To save a workbook:
Step 1: Press ‘Ctrl+Shift+S’ key from keyboard. ‘Save As’ dialog box appears on the screen.
Step 2: Select the folder where the workbook has to be saved.
Step 3: Type a name for the workbook.
Step 4: Click on the ‘Save’ button or press ‘Enter’ key.
It will be saved with the given name. The extension of a file in Calc is .ods, whereas the extension
of a file in MS-Excel 2010 is .xlsx.
2
3
4
Notes
The extension of OpenOffice Calc file is .ods, which automatically gets attached with the file name
when a file is being saved.
OPENING AN EXISTING WORKBOOK
To open an existing workbook, follow these steps:
Step 1: Press ‘Ctrl+O’ key from keyboard. ‘Open’ dialog box appears on the screen.
Working with Spreadsheet 175

