Copy and insert formulas
- Interface overview
- Screen elements
- Toolbar
- Quick actions box
- General information
- Files
- New file
- Save as template
- New from template
- Open a file
- Recent files
- Open with
- Send a file
- Print document without entering the application
- Preview and print
- Save a file
- Autorecovery of documents
- Close a file
- Sheets
- Insert a sheet
- Rename a sheet
- Hide or unhide sheets
- Duplicate a sheet
- Change sheets order
- Zoom a sheet
- Hide or display zero values
- Delete a sheet
- Cells, columns, and rows
- Expand the workspace
- Select cell ranges
- Resize cells
- Merge or unmerge cells
- Insert columns or rows
- Select colums or rows
- Hide or unhide a column or row
- Resize a column or row
- Freeze columns, rows, or area
- Group columns or rows
- Delete columns or rows
- Data
- Enter data
- Sort and filter
- Data validation
- Remove duplicates
- Links
- Notes
- Special characters
- Current date or time
- Check spelling
- Find and replace
- Delete data
- Number formats
- Identify cell format
- Open number format settings window
- General
- Number
- Currency
- Accounting
- Date, Time, and Date and Time
- Percentage
- Fraction
- Scientific
- Text
- Formulas and functions
- Formulas and functions basics
- Order of operations in a formula
- Reference cells and cell ranges
- Recalculation of formulas
- Automatic calculation
- Enter functions
- Replace a formula with its result
- Copy and insert formulas
- Names in formulas and functions
- Reference to data in another document
- Structured references
- Calculation operators
- Arithmetic operators
- Comparison operators
- Text concatenation operator
- Reference operators
- Tables
- Create a table
- Open the table settings pane
- Table customization
- Automatic table expansion
- Add a calculated column
- Select the type of calculation in the total row
- Convert a table to a regular range
- Delete a table
- Pivot tables
- Create a pivot table
- Open the pivot table settings pane
- Customize a pivot table
- Customize the pivot table parameters
- Collapse or expand the elements of pivot table
- View cell details
- Refresh a pivot table
- Delete a pivot table
- Charts
- Create a chart
- Chart settings
- Move a chart
- Copy, cut or insert a chart
- Change chart type
- Resize a chart
- Change data in chart
- Change chart data source
- Delete a chart
- Images
- Insert an image
- Resize an image
- Move an image
- Save an image
- Delete an image
- Shapes
- Insert a shape
- Fill a shape
- Outline
- Line style
- Resize a shape
- Fit shape size to text
- Change line length and angle
- Select arrow type
- Move a shape
- Delete a shape
- Format
- Font
- Font size
- Font formatting
- Font сolor
- Highlight color
- Alignment
- Rotate text
- Wrap text
- Character spacing
- Cell background color
- Cell borders
- Copy and apply formatting
- Edit content
- Undo and redo
- Clipboard
- Automation tools
- Macros
- Document protection
- Protect content from changes
- Appendices
- Appendix A. List of functions
- Appendix B. List of supported currencies
If necessary, you can cut or copy formulas from one cell/row/column and paste the formula totals into another cell/row/column without the formulas themselves. To do this, follow the steps below:
1.Select the cell, cell range, rows, or columns from which you want to cut or copy formulas.
2.Copy or cut a formula in the usual way.
To insert the result of formula calculation without the original formatting, do the following:
1.Select the place where you want to paste the data:
•If the clipboard contains data from a single cell/row/column, select the cell/row/column where you want to paste the data.
•If the clipboard contains a range of cells/rows/columns, select the appropriate size range or select the cell/row/column where you want to paste the contents of the first cell/row/column in the range.
2.Paste the content in one of the following ways:
•In the Command menu, select Edit > Paste Values Only.
•On the Toolbar, select the Edit section and click the arrow to the right of the 
Paste button. In the drop-down list, select the Paste Values Only command.
•Right-click the selected cells or the contents of the selected rows/columns to open the context menu and click Paste Values Only.
To insert the result of formulas calculation with the original formatting intact, do the following:
1.Select the place where you want to paste the data:
•If the clipboard contains data from a single cell/row/column, select the cell/row/column where you want to paste the data.
•If the clipboard contains a range of cells/rows/columns, select the appropriate size range or select the cell/row/column where you want to paste the contents of the first cell/row/column in the range.
2.Paste the content in one of the following ways:
•In the Edit menu, select Paste Values and Format.
•On the Toolbar, select the Edit section and click the arrow to the right of the Paste button. In the drop-down list, select the Paste Values and Format command.
•Right-click the selected cells or the contents of the selected rows/columns to open the context menu and click Paste Values and Format.
•Press Ctrl+Alt+V.
