Why Do I Have to Zoom in Again in New Excel Tav

4.2.1 Basic Operations on Worksheet

Basic-operations-on-WKS

A workbook window mostly has at least i sheet and tin can have up to 1024 sheets.

• Click the sheet tab to activate the worksheet.
• Right-click on a sheet tab, to show a menu of basic operations for the current worksheet.
• Double-click on the tab to Proper noun the sheet.

Insert, Delete and Add a Canvas

Right-click on the canvass tab to select Insert or Delete or Add item to insert a new sheet in front end of current canvass or delete current sheet or add a new sheet as the concluding sheet.

Right-click on the sheet tab to select Add Graph as Sheet or Add Matrix as Sheet particular to open the Hunt dialog(as below), click the window you want to add as a sheet to add together the graph or matrix window equally a new sheet into current workbook window.

Right-click on the sheet tab to select Add Notes as Canvas item to add a Notes window as a new sheet into the current workbook.

Copy and Paste a Canvass

From Origin 2018b, you are allowed to re-create current sheet with all information(including the header lines and structure) into the clipboard, so paste it as a new canvass from the clipboard into a workbook window, by right-clicking on the sheet tab and selecting Re-create Sail and Paste every bit New Sail context menu item.

One time you lot selected the Copy Sheet particular, you tin

• right-click on Origin'south greyness work space to select Paste every bit New Canvas to paste this sheet as a new workbook.
• correct-click on some other canvass(might in another workbook window) to select Paste as New Sheet to paste this sheet as a new sheet into current workbook window.
• switch to another Origin session and select a sheet tab in the target workbook window, right-click information technology to select Paste every bit New Canvas to paste this canvass into the selected workbook of electric current Origin session. In this example, you lot are able to copy and paste a sheet between different Origin sessions.

Duplicate a Sheet

Right-click on the canvas tab, you lot tin can select Duplicate Without Data or Indistinguishable to duplicate the electric current worksheet with data or without information.

When you select Duplicate Without Data context menu item, a worksheet with same structure and header lines but without information will be created and added to the current workbook as the last worksheet.
Delight note, since Origin 2020, when you lot select Duplicate Without Data to indistinguishable the sheet, only the raw data will be deleted merely the prison cell links(such equally cell references, prison cell formula etc.) will be kept to farther uses. You lot can use the arrangement variable @DkL to roll dorsum to the older behavior which will delete the cell links too.

When you select Duplicate context bill of fare item, a new worksheet looks exactly akin will exist created and added into current window as the terminal sheet.

Name and Comments

Right-click on any sheet tab, and then click Name and Comments... context carte du jour to open up the Proper name and Comments dialog to manage the proper name and comments in the electric current worksheet.

• Each canvass has a Name which is displayed on the canvas tab.
• Optionally, the sheet can accept a Label and Comments.
• Tab Color tin can be fix using the drop-down list; or when nothing is selected in the canvass, by clicking on the Fill Color push button on the Style toolbar.
• For naming data, see Naming Workbooks, Worksheets and Columns.
• For more information on sail naming options, see FAQ-348 How do I add or edit Name and Comments in the worksheet?

Tag Sail as Exclude from Plotting Dialogs

Right-click on the sheet tab and select Exclude from Plotting Dialogs context menu to exclude current sheet(s) as from the plotting dialogs, such as Plot Setup, Layer Contents etc..

You tin also run the LabTalk command wks.epd = 1; to execute this operation on current agile sheet.

Additionally, yous are allowed to perform this functioning on multiple sheets in ane time by

• Printing Ctrl key to select multiple sheets, and and so right-click to select Exclude from Plotting Dialogs context carte du jour.

In one case the sheets have been tagged as exclude, their names will be indicated with a specified colour which is controlled by the system variable @TCE.

Tag Sheet equally Exclude from Excel Export

Right-click on the sheet tab and select Exclude from Excel Export context card to exclude electric current sail from exporting the whole workbook as an Excel file.

Navigate Worksheets

Correct-clicking on the canvass tab to select Navigate... context menu will open up the Navigate Worksheets dialog box which can be used to manage the worksheets in current workbook. To larn the details nigh this dialog, delight refer to this folio.

Zoom and Pan Worksheet

To zoom the Worksheet, printing Ctrl central and and then coil the mouse to zoom in and out the electric current worksheet in the workbook. You lot can also use the Zoom toolbar to set the percentage to zoom in and out the worksheet columns and rows.

To pan the Worksheet, click the Zoom-Panning Tool button to enable panning, then press the left button of mouse to drag the horizontal scrollbar or/and vertical scrollbar to view all columns and rows in electric current worksheet.

Sometimes, if you have embedded a floating graph in current worksheet, and this graph has been moved beyond the worksheet workspace and can not testify in full, you tin can select View: Arrange Graphs menu to become the graph back to the view.

millerovereatitese.blogspot.com

Source: https://www.originlab.com/doc/en/Origin-Help/Basic-operations-on-WKS