Right-click context menu of worksheet cell: Insert Notes
Insert a Notes window into a worksheet cell
X-Function not designed for Auto GetN Dialog.
Command Line Usage
2. insertnotes str:="original image" cell:=[Book1]Sheet1!Col(2);
3. insertnotes cell:= [Book1]Sheet1!Col(1)
X-Function Execution Options
Please refer to the page for additional option switches when accessing the x-function from script
| "Double-click to replace this text"
The notes content
Specify the worksheet cell to save the embedded notes
See the syntax here.
The insertNotes function embeds notes inside a worksheet cell. The right-click context menu for worksheet cell offers an "Insert Notes" item. When this context menu is selected, a new Notes window is embedded into that cell. User can double-click the cell to pop up the Notes window for editing. Once done with editing, clicking the Close button on the Notes window will put the changes back into the worksheet cell.
The worksheet cell can then be sized to show as much of the embedded notes as desired. Note that existing notes windows cannot be embedded in cells, and only new Notes windows can be added and then opened for editing.
A cell with an embedded notes window is marked with black triangles in the four corners to distinguish it from a worksheet cell that contains text.
Run the following scripts in the command window respectively:
insertNotes str:="original image" cell:=[book1]sheet1!col(3);
Insert the notes "original image" into column 3 row 4 of book1_sheet1;
This will embed a Notes page into the specified worksheet cell.
insertArrow, insertGraph, insertImg