TechOnespot

    Data Editing and Formating in Calc A spreadsheet is made up of rows and columns intersecting each other forming multiple cells Operations such as opening a new or an existing spreadsheet, saving the spreadsheet, renaming the whole spreadsheet with save as option; renaming work sheets, adding/deleting worksheets etc. are frequently used operations on spreadsheet or work sheet level. To open a new Calc document, that is a Calc spreadsheet, perform the following procedures. Select File → New → Spreadsheet; from the Menu Bar. Press CTRL + N; or The first way is to open the Calc first and go to file menu and select open. Select File → Open;  To insert a worksheet using the sheet tab, perform the steps mentioned. • Select a worksheet and right click on it; • A vertical menu will open; Select a cell from a column (row); • Select Format → Column → Width or Format → Row → Height; . Freezing a Pane When many rows and columns are accommodated in a single worksheet, the row or column headers d