Highlight the word or phrase you want to comment on. Hold Control and Alt and press M for a comment. A side note will appear. DO NOT CLICK ON THE NOTE you can start typing right away.
DO NOT touch the mouse! Type your comment and hold down the Ctrl key and press Enter. (Command Enter on a Mac.) The comment will be saved.
Contents
Excel keyboard shortcuts: General
Shortcut no. 1 Shortcut no. 2 Shortcut no. /redo last action or command Ctrl + ZUndo/reverse last action or command
Keyboard shortcuts for checking formulas
These shortcuts are essential for knowing whether you are trying to track down an error in your formula or trying to figure out a formula that has been written by someone else.
Ctrl +
Create Pivot Cache
In Excel 2000 and later, before creating a PivotTable, you must create a Pivot Cache to define the data source. Normally when you create a pivot table, Excel automatically creates a pivot cache without asking you, but when you have to use VBA, you have to write a code for it.
‘Define Pivot CacheSet PCache = ActiveWorkbook.PivotCaches.Create _(SourceType:=xlDatabase, SourceData:=PRange). _CreatePivotTable(TableDestination:=PSheet.Cells(2, 2), _TableName:=”SalesPivotTable”)
Net investment, of course
But could the Fed have been an “investment engine”? The combination of low nominal interest rates and high inflation during most of 1946-1951 meant that real (inflation-adjusted) interest rates were mostly negative, and sharply during 1946 and 1947. Investments have suddenly awakened from their sleep of a decade and a half. Later, as inflation fell, giving way to deflation in 1949, as nominal rates rose, real rates soared and investment fell again. Sounds, some would say, like a classic case of excess money creation causing an unsustainable investment boom by pushing real interest rates below their “natural” levels.
But here too, appearances are deceiving. Taking a step back to look at the bigger picture shows that, despite the setback of 1949, there was nothing unsustainable about the postwar investment recovery. Instead, after that setback, itself relatively modest, net private fixed investment returned and soon surpassed its previous post-war high. Moreover, as the following chart shows, it continued on that modest upward trend, with only minor interruptions, for nearly two decades after the March 1951 Treasury Agreement released interest rates from their previous caps. Thus freed, those rates eventually shot up sharply; and as inflation was held on hold for most of the next two decades, real interest rates also rose. These developments strongly suggest that the postwar recovery in net investment did not depend on the Fed’s ability to keep interest rates low.