Perform formatting, insertion, and deletion operations on multiple rows at once. This tool is accessed via the Macabacus > Cells > Reverse Rows button. Reverse Rows reverses the order of selected rows, similar to Reverse Columns. This tool is accessed via the Macabacus > Cells > Reverse Columns button. Macabacus, on the other hand, preserves formula references to reordered cells so that columns can be safely reversed, without breaking formulas. Native Excel functionality supports reordering columns similarly, but if any cell formulas refer to the reordered data, those references will be incorrect after reordering. Macabacus lets you reverse the order of entire columns, or the order of columns in a smaller selection of cells, only. In financial modeling, however, we typically prefer later periods on the right to support projections. For example, financial statements downloaded from the Internet often have the most recent periods on the left, and the oldest on the right. This is especially useful for reordering periods in financial statements from oldest to newest or vice versa. Reverse Columns reverses the order of selected columns, using the first row of dates found in the selection as the basis for reordering.
0 Comments
Leave a Reply. |