30+
years serving the scientific and engineering community
Log In
Buy Now
Try Origin for Free
Watch Videos
English
日本語
Deutsch
Toggle navigation
Products
PRODUCTS
Origin
OriginPro
Origin Viewer
All products
Origin vs. OriginPro
What's new in latest version
Product literature
SHOWCASE
Applications
User Case Studies
Video Tutorials
Graph Gallery
Animation Gallery
3D Function Gallery
FEATURES
2D&3D Graphing
Peak Analysis
Curve Fitting
Statistics
Signal Processing
Key features by version
LICENSING OPTIONS
Node-locked(fixed seat)
Concurrent Network (Floating)
Dongle
Academic users
Student version
Commercial users
Government users
Non-Profit users
Why choose OriginLab
Who's using Origin
What users are saying
Published product reviews
Online Store
Get a quote/Ordering
Find a distributor
Apps
Data Import
CSV Connector
Excel Connector
HTML Connector
HDF Connector
NetCDF Connector
Import NMR Data
Import PDF Tables
Google Map Import
Import Shapefile
More...
Graphing
Graph Maker
Correlation Plot
Paired Comparison Plot
Venn Diagram
Taylor Diagram
Volcano Plot
Kernel Density Plot
Chromaticity Diagram
Heatmap with Dendrogram
More...
Publishing
Graph Publisher
Send Graphs to PowerPoint
Send Graphs to Word
Send Graphs to PDF
Send Graphs to OneNote
Movie Creator
Graph Anim
More...
Curve Fitting
Simple Fit
Speedy Fit
Piecewise Fit
Fit ODE
Fit Convolution
Rank Models
Fitting Function Library
Neural Network Regression
Polynomial Surface fit
Global Fit with Multiple Functions
More...
Peak Analysis
Simple Spectroscopy
Peak Deconvolution
Pulse Integration
Align Peaks
Global Peak Fit
PCA for Spectroscopy
2D Peak Analysis
Gel Molecular Weight Analyzer
More...
Statistics
SPC
DOE
Stats Advisor
PCA
RDA
Bootstrap Sampling
Time Series Analysis
Factor Analysis
General Linear Regression
Logistic Regression
SVM Classification
More...
How do Apps work in Origin?
Suggest a New App
Purchase
New Orders
Renew Maintenance
Upgrade Origin
Contact Sales(US & Canada only)
Find a Distributor
Licensing Options
Node-locked(fixed seat)
Concurrent Network (Floating)
Dongle
Academic users
Student version
Commercial users
Government users
Non-Profit users
Why choose OriginLab
Purchasing FAQ
Support
SERVICES
Transfer Origin to new PC
License/Register Origin
Consulting
Training
Renew Maintenance
SUPPORT
Support FAQ
Help Center
Contact Support
Support Policy
DOWNLOADS
Service Releases
Origin Viewer
Orglab Module
Product Literature
Origin Trial
All downloads
VIDEOS
Installation and Licensing
Introduction to Origin
All video tutorials
DOCUMENTATION
User Guide
Tutorials
Python Programming
OriginC Programming
LabTalk Programming
All documentation
Communities
User Forum
User File Exchange
About Us
OriginLab Corp.
News & Events
Careers
Distributors
Contact Us
Contact Us
Log In
All Books
Non-Programming Books
User Guide
Tutorials
Quick Help
Origin Help
Programming Books
X-Function
Origin C
LabTalk Programming
Python
Python (External)
Automation Server
LabVIEW VI
Apps
App Development
Code Builder
License
Orglab
2.37 FAQ-473 What formatting capabilities are available for the worksheet?
Worksheet-Formatting
Last Update: 2/1/2018
Rich Text Formatting (RTF): Worksheets support
rich text formatting
.
Use the
Style
and
Format
toolbar buttons to change font color, background cell fill color, font size, text alignment, bold, border line etc.
Use the
Merge Cells
button to
merge worksheet cells
. Value/Text in most upper-left corner cell will be displayed.
Use
Dynamic Merge
on
Format
tab of
Worksheet Properties
dialog to make adjacent cells with same value/text merged.
The
Format Cells
dialog box can be used to format a selected range of data. Right-click on the selected range and choose
Format Cells
from the context menu. In
this dialog
you can specify such things as
Rich Text, Wrap Text, Disable Editing
, etc.
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.
Keywords:
color, font, alignment, wrap, theme, template
Skip Navigation Links
All Books
Quick Help
Data Handling
User Guide
Tutorials
Quick Help
Origin Help
X-Function
Origin C
LabTalk Programming
Python
Python (External)
Automation Server
LabVIEW VI
Apps
App Development
Code Builder
License
Orglab
Programming
Graphing
Data Handling
Data Analysis
Programming
Miscellaneous
Licensing and Installation
FAQ-348 How do I add or edit Name and Comments in 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 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-427 How to combine data from multiple Origin projects?
FAQ-428 How to run LabTalk script after import?
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 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 add supercripts, subscripts, and special characters in tables and worksheets?
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-1059 How to get the row index and value of visible cell after filtering data in Origin?
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 matrixsheet and different objects?
FAQ-815 How do I copy report sheet tables and paste them into Word, Excel or PowerPoint?
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 in a box chart?
FAQ-839 What should I do when Origin becomes slower as more data is imported?
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-969 What’s the difference between "Save Import setting to Sheet" and "save to <sheet>" in the import dialog?
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?
FAQ-988 How do I add cell formula in column label row during data importing?
FAQ-989 How to display number as 10 000 instead of 10000?
FAQ-993 When I paste my Excel time data into Origin, Origin displays 12/30/1899
FAQ-995 Data: Connect to Web Fails to Import Data from Certain URLs in Windows 7
FAQ-1008 How to resolve possible loss of precision when importing date time data?
FAQ-1009 How to extract unmasked data to a new worksheet?
FAQ-1011 Why i and I in equations give different results?
FAQ-1013 Can I use a simple formula to do simple math on columns or curves?
FAQ-1014 What Can I do to Reduce the Size of My Origin Project?
FAQ-1020 Is there a difference between Connect and Import?
FAQ-1025 Why does the embedded graph disappear or show partially in current worksheet?
FAQ-1034 How to not use Data Connector when drag and drop data into Origin?
FAQ-1042 How to show formulas in worksheet cells?
FAQ-1043 How do I know the categorical values if I set a column as categorical?
FAQ-1050 Does Origin have a tool like MS Excel's Text to Columns Wizard?
FAQ-1052 Origin worksheets used to display truncated content as ### pound signs. What changed?
FAQ-1053 How to allow changing data when Data Connector is used?
FAQ-1066 How do I copy and paste date-time data from MS Excel?
FAQ-1067 How can I paste strings into Origin and not have it split strings across columns?
FAQ-1069 How do I align column numbers on the decimal character?
FAQ-1080 I used a Data Connector to import data but when I reopen my project, the data is missing
FAQ-1101 How to set a row as the beginning of my data?
FAQ-1106 How to merge multiple NetCDF files into one?
FAQ-1107 How to merge separate date and time columns into one column?
FAQ-1110 What should I do if Origin crashes when pasting link from Excel?
FAQ-1128 What should I do if Origin becomes very slow when working on large dataset?
FAQ-1134 How to remove DDE links in a project?
FAQ-1137 How to insert image to a cell note
FAQ-1144 How do I Autofill my rows or columns with data?
FAQ-1154 How to import columns of Excel or ASCII data that look like numbers in the source file but need to be treated as Categorical?
FAQ-1155 How to import multiple files to a sheet and separate each file with an empty column?
FAQ-1163 How do I add a file extension to a Data Connector?
FAQ-1173 How to copy and paste comma separated data into Origin?
FAQ-1181 Why my Connect to Web/Cloud menu grey out?
FAQ-1182 How to import Eastern/Central European characters?
FAQ-1184 How to Extract a Region of data points from Data Plot?
FAQ-1186 How to insert one row for every certain number of rows?
English
|
Deutsch
|
日本語
© OriginLab Corporation. All rights reserved.
×
☐
_
Let's Chat