The Microsoft Excel is heavily used and widely used. There are so many tricks/tips that help make the spreadsheet powerful and easy to use. For example, suppose you have a column of data, and want to compute another column that has a formula. You could fill a cell first and drag the cell down to auto complete other cells in the column. It seems easy for a few rows, but image if you have thousands of columns, that might be a tedious task to drag and scroll down.
The solution is even simpler than you think, just double click the right bottom dot of the cell and the excel will automatically fill the columns (downwards) according to the formula in the current cell.
Noted that it will fill downwards to the maximum rows in the current spreadsheet.
Excel Tutorial
- Microsoft's Excel Just Got Smarter: The New Copilot Function
- Excel Tutorial: SUMIF Function
- Iterative Computing Fib Number using Excel
- How to Transform the Values in Excel Files to a Column of Values
- Excel Sheet to Calculate the Miles Per Gallon Average Gas Cost
- How to Calculate Mortgage Monthly Payment using Excel with Formula
- Four Useful Cell Functions/Values in Excel
- Excel Tip: Faster Auto-Complete
–EOF (The Ultimate Computing & Technology Blog) —
215 wordsLast Post: Test SD Card Speed on Raspberry PI
Next Post: Different Approaches to Reduce the CPU Temperature of Raspberry PI