years serving the scientific and engineering community
Origin vs. OriginPro
What's new in latest version
User Case Studies
3D Function Gallery
Key features by version
Download full feature list
Concurrent Network (Floating)
Why choose OriginLab
Who's using Origin
What users are saying
Published product reviews
Get a quote/Ordering
Find a distributor
Contact Sales(US & Canada only)
Find a Distributor
Concurrent Network (Floating)
Why choose OriginLab
Transfer Origin to new PC
Installation and Licensing
Introduction to Origin
All video tutorials
User File Exchange
News & Events
2.39 FAQ-473 What formatting capabilities are available for the worksheet?
Last Update: 2/1/2018
Rich Text Formatting (RTF): Worksheets support
rich text formatting
toolbar buttons to change font color, background cell fill color, font size, text alignment, bold, border line etc.
merge worksheet cells
. Value/Text in most upper-left corner cell will be displayed.
dialog to make adjacent cells with same value/text merged.
dialog box can be used to format a selected range of data. Right-click on the selected range and choose
from the context menu. In
you can specify such things as
Rich Text, Wrap Text, Disable Editing
Resize row height and column width.
Add gap above worksheet.
Show and Hide column/row header, column label rows and add user-defined column label rows.
Set worksheet to use Spreadsheet cell notation so simple column formula and cell formula notation can be used. E.g. A-B means column A minus column B; =total(A1:A10) set a cell value to be sum of cells from A1 to A10.
color, font, alignment, wrap, theme, template
Skip Navigation Links
Licensing and Installation
FAQ-348 How can I specify the Long Name, Short Name and Comments of the worksheet?
FAQ-409 How do I turn off sparklines when importing ASCII files?
FAQ-410 How can I save ASCII import options to my template?
FAQ-411 What is the difference between ASCII import and the Import Wizard?
FAQ-412 How do I customize Drag and Drop and File Open for various import file types?
FAQ-413 How do I import multiple data files with the same format?
FAQ-414 How do I import data from the clipboard or from a web page?
FAQ-415 How do I double-click to open ASCII files in Origin?
FAQ-416 How do I extract Long Names and Units from same header rows when importing ASCII?
FAQ-418 How do I open and manipulate a MySQL Database inside Origin?
FAQ-419 Can I import data from a database and save and re-use queries?
FAQ-421 How do I digitize an image to get data from it?
FAQ-423 How do I retrieve and use variables extracted from file name and header?
FAQ-424 How do I import custom date and time data?
FAQ-425 How to skip string when testing non-numeric in Import Wizard dialog?
FAQ-426 What should I do if import speed gradually slows when importing many files at one time?
FAQ-427 How to bring in data from another Origin project?
FAQ-428 How to run LabTalk script after import?
FAQ-429 How to directly copy Excel data with more than 15 significant digits to Origin?
FAQ-431 Why does my Imported Image display as just black?
FAQ-433 How to Paste Excel or Plain Text Data into an Origin Worksheet and Set Column Labels
FAQ-434 What is the Sampling Interval header row?
FAQ-435 How to import/export data from/to MATLAB Workspace ?
FAQ-436 Can Origin import the MATLAB file with structure data?
FAQ-437 Can Origin import certain columns from different Excel sheets?
FAQ-438 How can I transpose variable when importing data from MATLAB?
FAQ-454 How to print Origin graph or worksheet to a PostScript file?
FAQ-459 How do I add, arrange, and view multiple matrix objects in one matrix window?
FAQ-460 How do I convert a worksheet with matrix style data to Matrix or X Y Z?
FAQ-461 How do I normalize a data matrix?
FAQ-462 What is the difference between data matrix and image matrix?
FAQ-464 How can I recover a damaged Origin file?
FAQ-465 How do I package multiple Origin files to share with a colleague?
FAQ-466 Is there an auto save feature for projects?
FAQ-467 Are older-version Origin projects forward-compatible with newer versions of Origin? Are newer-version Origin projects backward-compatible with older versions of Origin?
FAQ-468 My Origin project file (OPJ) is very slow to work with. How can I improve this
FAQ-471 How to avoid the input data string converting to a numerical value automatically in the worksheet?
FAQ-472 How to set the date format if the data is not consistent with the desired display format?
FAQ-473 What formatting capabilities are available for the worksheet?
FAQ-474 How do I edit and format text in merged cells?
FAQ-475 How do I resize width/height of multiple columns/rows in a worksheet?
FAQ-476 Can I control what header rows to display in a worksheet?
FAQ-477 How to enable rich text for worksheet header rows?
FAQ-478 How do I set up my worksheet to be always m x n cells?
FAQ-479 What is a Sparkline and how do I customize it?
FAQ-480 What is the difference between embedding and linking a graph in a worksheet cell
FAQ-481 How do I copy data with column label rows?
FAQ-482 How do I copy data with maximum precision?
FAQ-483 How do I copy the column formula?
FAQ-484 Why does Origin assign Types for Columns and how do I work with column types?
FAQ-485 Where is the X data associated with my Y column?
FAQ-486 What should I do if the text label size on a worksheet created in Origin 8.5 appears much bigger when opening in later version?
FAQ-489 How can I easily identify a particular worksheet within a workbook that contains many?
FAQ-494 How do I find the average of multiple columns or data plots?
FAQ-495 How do I further process or plot results contained in report sheet tables?
FAQ-497 How do I use a parameter row or worksheet variable in the Set Column Values dialog?
FAQ-498 How do I use analysis results in the Set Values dialog?
FAQ-499 How do I auto fill cells with data?
FAQ-500 How do I sort my data?
FAQ-502 how do I take the value in a report to use in my worksheet
FAQ-503 Is there a way to extract data from a worksheet based on conditions?
FAQ-504 How do I reduce XY or XYZ dataset?
FAQ-616 What are the different methods to calculate average value in Origin?
FAQ-623 How to find the minimum or maximum value in a dataset and the corresponding x value and index number?
FAQ-662 How do I join two worksheets
FAQ-690 Two Quick Examples of Set Values dialog
FAQ-692 How to set values of a cell or a subrange?
FAQ-783 Can I select and hide worksheet columns by label or index?
FAQ-784 How can I use comma as decimal mark and use semicolon as function arguments separator in formula and script?
FAQ-794 How do I import date data from database?
FAQ-800 How to set up the SQL?
FAQ-806 How do I find the closest date/time value in a dataset?
FAQ-809 How do I import multiple ASCII files directly as the same matrix sheet and different objects?
FAQ-815 How do I copy report sheet table and paste into PowerPoint or Word?
FAQ-820 How to work with large datasets in Origin?
FAQ-823 My German version Origin cannot show AM/PM time format, what can I do?
FAQ-827 How to mask data points on box chart?
FAQ-839 How can I remove sparklines from an Origin project file (OPJ) that is very slow?
FAQ-847 Why are my column formulas not updating when I insert or delete columns?
FAQ-849 Can I turn off or selectively control use of spreadsheet cell notation in my workbooks?
FAQ-852 Can I subtract two images or two matrices?
FAQ-862 How do I update a data filter when I make changes to my data?
FAQ-863 How do I update a data filter during batch operations?
FAQ-864 How do I have different conditions for same column and do further graphing and analysis?
FAQ-865 How do I exclude hidden data rows from my analysis and plotting operations?
FAQ-870 How to extract file name without extension to column comments?
FAQ-871 Does Origin have a "IF" function?
FAQ-913 How to apply format to multiple worksheets?
FAQ-919 ASCII Import filters or import options saved to a sheet fail after upgrading to Origin 2018
FAQ-927 Is there some way to convert the new OPJU file format into the older OPJ format?
FAQ-935 How to get the average value of every 5 points?
FAQ-936 How do I Convert a Unix Timestamp to an Origin Date?
FAQ-939 Is there a way to disable cell formulas in my project?
FAQ-941 Why are my cell formulas not working?
FAQ-961 How to get the difference or sum of two curves?
FAQ-962 How to transpose one column data to one row data?
FAQ-970 What do I do if there is an error while importing an SPC file?
FAQ-973 How to disable editing of the cells in worksheet?
FAQ-974 How do I display Degrees, Minutes and Seconds in Origin?
FAQ-975 How do I use hexadecimal values in my data sheet?
© OriginLab Corporation. All rights reserved.