MS Office Tips, Excel Notes, Accounts, ERP, Use Excel, Professional tips, Training, Learning, Computer Basics, MS Excel, Spread Sheet, Data calculations, Formula, Functions, VBA, Visual Basic, Macro Codes
Post Labels
- Absolute and Relative references
- Charts
- Countif with format
- database function
- Date Function
- Find Duplicates
- Named Range
- Networkdays Function
- Pivot Table application
- Principle component in EMI
- Project Finance
- shortcut key
- Subtotal function Usage
- Text to column function
- Trend Application
- User Defined Function
Tips - Exact Formula copy or Value of Formula
This problem is how to copy the result of the formula as a value.
If you go to cell and Press Ctrl+Shift+",Excel copy the result from cell above as a value in cell current cell.
How to copy the formula
Use the Ctrl+'quotation mark to make an exact copy of a formula.
Use the Ctrl+d to do copy paste the above cell value / formula in the current cell.
The above tips will be useful for fast data entry and processing.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment